CRA Data Analyst

The Business Analyst 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 partners with business units, compliance, and senior leadership to maintain regulatory alignment and enhance the bank's CRA performance monitoring framework. Responsibilities: 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. Qualifications: • 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 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