Capital Markets CRA Business Analyst

Description

The CRA Business Analyst is responsible to developing analytics, strategic models, and management reporting for the purpose of meeting Citizens’ Community Reinvestment Act (CRA) obligations. This role intersects data analytics, business strategy, and compliance and will be expected transform complex, disparate data sources into actionable intelligence that drives effective compliance and strategic lending decisions. Key initiatives will include the development of tools to monitor MSA-level CRA lending performance against pre-defined thresholds, forecast potential CRA shortages at the MSA-level, and monitor performance in terms of volume and cost.

In addition to a strong foundation in residential mortgage origination and analytics, the individual in this role must be able to effectively partner with various mortgage business units in the creation and exchange of timely and accurate data inputs required for successful strategy management and optimization.

This role will have extensive interaction with leadership and be expected to regularly present findings and recommendations. Effective presentation and communication skills are imperative.

While this role will focus on CRA, there will be significant engagement with the broader mortgage business. The CRA analyst will operate as a member of the Capital Markets business analytics team and may be tasked to assist with non-CRA initiatives as needed.

Primary Responsibilities

CRA Data Integration, Analysis, and Reporting: Design, build, and maintain CRA tracking processes that aggregate data from multiple disparate sources. Create models that track lending performance. Develop automated data validation processes to ensure accuracy and completeness of CRA data. Build dynamic dashboards in Tableau that provide visibility into CRA performance metrics. Generate comprehensive CRA performance reports that synthesize complex data into presentations highlighting trends, risks, and opportunities. (40%)

CRA Forecasting and Predictive Analytics: Develop and maintain forecasting models that project CRA lending volumes across multiple time horizons (ex. 30/60/90 day, quarterly, and annual). Create early warning systems that identify potential CRA shortfalls in advance, enabling proactive strategy adjustments. Analyze data to identify untapped CRA opportunities. Develop "what-if" analyses for executive leadership evaluating trade-offs between profitability objectives and CRA obligations. (25%)

Cross-Functional Stakeholder Collaboration: Partner with various teams across Citizens to optimize CRA lending opportunities. Collaborate with retail banking leadership to track lending initiatives and optimize CRA performance. Work closely with the CRA data team to ensure data integrity, resolve discrepancies, and implement process improvements. (15%)

CRA Presentation / Communication: Develop and deliver presentations to team members and senior leadership showcasing CRA performance and strategic recommendation. Create dashboards that distill CRA metrics into intuitive visualizations enabling rapid decision-making. Prepare written analyses on CRA strategy, market opportunities, and developments for senior leadership consumption. (10%)

Innovation and Continuous Improvement: Lead efforts to create a modern CRA tracking infrastructure through implementation of advanced analytics tools and automation. Identify and implement process improvements that enhance data quality, reduce manual effort, and accelerate reporting timelines. Research alternative data sources that could enhance CRA performance or data tracking. Develop innovative analytical methodologies to provide deeper insights into CRA performance. (10%)

Management Responsibility:

This is an individual contributor role serving as a strategic analyst who manages and supports the broader CRA strategy across the Citizens Home Mortgage Capital Markets group. This position provides functional leadership and guidance to teams involved in CRA initiatives. The analyst will lead projects for special CRA initiatives and coordinate activities across multiple departments including Finance, Treasury, Capital Markets, Retail Lending, and Correspondent Lending.

Skills / Competencies:

Technical Proficiency Requirements:

• Advanced Data Analytics: Expertise in Microsoft SQL for complex data extraction, transformation, and analysis across multiple data sources
• Visualization Expertise: Tableau (or other reporting tool) development skills including calculated fields, parameters, LOD expressions, and dashboard optimization
• Statistical Analysis: Understanding of automation and/or predictive analytics using tools such as Python or PowerShell
• Database Management: Experience with data warehouse concepts, ETL processes, and working with large datasets / databases
• Microsoft Office Mastery: Expert Excel skills including complex formulas, pivot tables, macros, VBA, and financial modeling; Advanced PowerPoint capabilities for executive presentations

Industry Knowledge:

• Knowledge of HMDA data requirements, geocoding methodologies, and fair lending principles
• Mortgage lending lifecycle from origination through sale
• Familiarity with affordable housing programs and community development initiatives

Business and Strategic Competencies:

• Strategic thinking capabilities to identify market opportunities and develop innovative CRA solutions
• Project management skills to lead complex, cross-functional CRA initiatives
• Change management expertise to drive adoption of new processes and technologies
• Risk management perspective to identify and mitigate CRA-related risks

Communication and Interpersonal Skills:

• Exceptional written and verbal communication skills with ability to distill complex regulatory and analytical concepts for diverse audiences
• Executive presence and confidence to present to senior leadership and board members
• Strong interpersonal skills to build relationships across organizational boundaries

Experience:

Minimum Required:

• Minimum 5 years of progressive experience in banking, mortgage lending, or financial services with direct exposure to data analytics
• Demonstrated expertise in data analysis and reporting with proven ability to work with large, complex datasets from multiple sources 
• Hands-on experience with mortgage lending data including loan-level origination data, servicing data, and secondary market execution metrics 
• Track record of developing executive-level reports and presentations that drive strategic decision-making 
• Experience supporting regulatory examinations or audits with data analysis and documentation 
• Proven ability to manage multiple complex projects simultaneously while meeting strict regulatory deadlines

Preferred:

• Previous experience working with and / or tracking data related to CRA requirements or similar regulatory compliance role within a depository institution 
• Exposure to capital markets operations, secondary mortgage market execution, or mortgage servicing 
• Experience with regulatory reporting systems data
• Track record of implementing process improvements or system enhancements that improved analytical capabilities 

Education:

• Bachelor’s Degree in Finance / Economics / Communications / Business Analytics / STEM

Hours & Work Schedule

• Hours per Week: 40
• Work Schedule: M-F

Some job boards have started using jobseeker-reported data to estimate salary ranges for roles. If you apply and qualify for this role, a recruiter will discuss accurate pay guidance.

Equal Employment Opportunity

Citizens, its parent, subsidiaries, and related companies (Citizens) provide equal employment and advancement opportunities to all colleagues and applicants for employment without regard to age, ancestry, color, citizenship, physical or mental disability, perceived disability or history or record of a disability, ethnicity, gender, gender identity or expression, genetic information, genetic characteristic, marital or domestic partner status, victim of domestic violence, family status/parenthood, medical condition, military or veteran status, national origin, pregnancy/childbirth/lactation, colleague’s or a dependent’s reproductive health decision making, race, religion, sex, sexual orientation, or any other category protected by federal, state and/or local laws. At Citizens, we are committed to fostering an inclusive culture that enables all colleagues to bring their best selves to work every day and everyone is expected to be treated with respect and professionalism. Employment decisions are based solely on merit, qualifications, performance and capability.