Business Analyst II-CRA Reporting

First Citizens Bank • Raleigh, NC

95d • Remote

About The Position

This is a remote role that may only be hired in the following location(s): AL, AR, CT, DE, IA, ID, IN, KS, KY, LA, ME, MS, NC, NE, NM, NV, OH, OK, OR, PA, RI, SC, SD, UT, VA, WV. The Business Analyst II serves as a mid-level analyst within the CRA Reporting Team, responsible for complex reporting, analytics, and compliance support activities. This role ensures the accuracy, consistency, and timeliness of CRA-related data, while also supporting strategic decision-making through advanced analytics and reporting solutions. The BA II partners with business units, compliance, and senior leadership to maintain regulatory alignment and enhance the bank's CRA performance monitoring framework.

Requirements

• Bachelor's Degree and 3 years of experience in System Support or Analytics OR High School Diploma or GED and 7 years of experience in System Support or Analytics.

Nice To Haves

• Analytics, or Modeling, or Reporting experience.
• Advanced Data Analytical, Business Analytics, and Computer Software skills.
• Interpersonal communication skills.
• Expert-level proficiency in Tableau, Alteryx, Excel, and SharePoint.
• Strong knowledge of CRA regulatory framework, lending/investment reporting rules, and related compliance requirements.
• Analytical mindset with high attention to detail and ability to manage large, complex datasets.
• Skilled in managing ad hoc requests under tight deadlines while maintaining accuracy.
• Effective written and verbal communication skills to convey findings to multiple levels of leadership.
• Ability to work independently while also contributing to a collaborative team environment.

Responsibilities

• Design, build, and maintain Tableau dashboards that monitor CRA lending, investment, and service activity across multiple business lines.
• Develop and manage Alteryx workflows to automate large-scale data preparation, cleansing, and validation processes.
• Leverage advanced Excel functionality (pivot tables, lookups, Power Query, VBA/macros when applicable) to perform ad hoc analysis and produce reporting templates.
• Ensure all data sources are accurate, reconciled, and compliant with regulatory standards.
• Support preparation of quarterly and annual CRA regulatory submissions, ensuring data integrity and readiness for examiner review.
• Respond to ad hoc reporting requests from senior leadership, internal auditors, and regulators.
• Collaborate with Compliance and Data Governance to interpret CRA regulatory guidance and apply it correctly to reporting outputs.
• Identify opportunities to improve reporting efficiency, accuracy, and automation within the CRA reporting lifecycle.
• Document business rules, data definitions, and process flows to ensure consistency and repeatability of reporting.
• Share subject matter expertise with junior analysts and provide peer review to uphold reporting standards.
• Partner with stakeholders in Compliance, Risk, Community Development, and Business Units to ensure accurate population tracking.
• Translate regulatory requirements and data findings into clear insights for both technical and non-technical audiences.
• Serve as a point of escalation for complex reporting and data interpretation questions within the CRA Reporting Team.

Benefits

• Competitive, thoughtfully designed and quality benefits program.

What This Job Offers

• Career Level: Mid Level
• Industry: Credit Intermediation and Related Activities
• Education Level: Bachelor's degree