Business Analyst II-CRA Reporting

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.

Data Management & Analytics:

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.

Regulatory Reporting & Compliance Support:

* 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.

Process Improvement & Documentation:

* 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.

Cross-Functional Collaboration:

* 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.

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

Preferred Experience: Analytics, or Modeling, or Reporting experience

Preferred Skills:

• • Advanced Advanced Data Analytical, Business Analytics, and Computer Software skills preferred
  • Interpersonal communication skills preferred
  • 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

Benefits are an integral part of total rewards and First Citizens Bank is committed to providing a competitive, thoughtfully designed and quality benefits program to meet the needs of our associates. More information can be found at https://jobs.firstcitizens.com/benefits.