CRA Business Analyst

Global Technical Talent is an Inc. 5000 Company seeking an experienced Business Analyst to join their CRA Reporting Team. The role focuses on complex reporting, analytics, and compliance support activities, ensuring the accuracy and timeliness of CRA-related data while enhancing the bank's performance monitoring framework.

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

Requirements:

• 4 years of work experience as a Business Analyst, Systems Support, or Data Analytics
• Experience in CRA regulatory framework, lending/investing reporting rules
• Advanced Excel skills with extensive knowledge creating Pivot Tables, VBA/Macros, Power Query
• Experience reading and writing SQL code
• Experience designing, building, and maintaining PowerBI dashboards that monitor CRA lending, investment, and service activity
• Experience in banking/financial services industry
• Excellent communication skills