CRA Data Analytics Analyst

City National Bank; Los Angeles (CA); On-site; USD 77,000 - 143,000; Full time

Benefits offered by this job

Comprehensive health coverage

Generous 401(k) matching

Tuition reimbursement and training

Job summary

City National Bank is seeking a CRA Data Analytics Analyst to own end-to-end CRA data lifecycle, ensure accurate data collection, validation, and reporting for CRA compliance. You will review loan files, analyze data quality, and coordinate with LOB and Technology to resolve issues.

The role requires a strong background in data reporting with CRA/regulatory experience, knowledge of CRA/Reg C, and proficiency in Wiz, RiskExed, and Tableau. Excellent communication and teamwork are essential.

Qualifications

• Bachelor's degree or equivalent in Economics, Statistics, or related field.
• 7+ years of data reporting, CRA or compliance experience.
• Knowledge of Regulation BB (CRA) and HMDA/Reg C.
• Experience with CRA data collection and reporting.
• Proficiency with Wiz, RiskExed and Tableau for reporting.
• Proficiency with Microsoft Office (Word, Excel, PowerPoint, Outlook).
• Attention to detail and strong written and verbal communication.
• Ability to work in a team and manage multiple tasks.

Responsibilities

• Own end-to-end CRA data lifecycle: collection, geocoding, aggregation, validation.
• Review loan files and validate CRA data accuracy for regulatory reporting.
• Audit community development loans for eligibility via demographic/economic research.
• Oversee data from CRA data reporting lines using Wiz or RiskExed.
• Log data issues and coordinate resolution with LOB and Tech.
• Prepare reports on data errors and track corrective actions.

Skills

Regulatory knowledge

Cross-functional work

Data reporting

Attention to detail

Communication skills

Time management

Problem solving

Compliance risk framework

Education

Bachelor's Degree or equivalent in Economics/Statistics/related field

Tools

Wiz

RiskExed

Tableau

Job description

CRA DATA ANALYTICS ANALYST

WHAT IS THE OPPORTUNITY?

Responsible for the technical expert who is reliable and knowledgeable resource for Community Reinvestment Act (CRA) reporting requirements. Own the end-to-end CRA data lifecycle: collection, geocoding, aggregation, validation. Will assist with ensuring the Bank meets the regulatory requirements of a large institution in compliance with the Community Reinvestment Act (CRA) through the review and validation of CRA data.

WHAT WILL YOU DO?

• Reviews loan files and validate accuracy and completeness of data collected for CRA regulatory reporting purpose
• Review community development loans by gathering information, conducting demographic, economic, and market research to determine eligibility.
• Use CRA Wiz or RiskExec tool to oversee the process and management of data received from assigned CRA data reporting lines of businesses.
• Log and track data issues detected during monthly processing and data integrity reviews and work to address and resolve issues with LOB and Technology department (TECH)
• Prepare timely reports on data errors and process deficiencies for distribution to LOB management. Analyze data errors to determine trends and monitor corrective actions to measure performance and responsiveness by business units.
• Work with the lines of business (LOBs) to improve data quality and integrity through the accurate data collection processes and sound operational controls to mitigate risks.
• Support the annual submission for a complete and accurate CRA Loan Registers (LRs) to the appropriate regulatory agency.
• Project design and management, coordinating on behalf of the CRA Department with internal stakeholders.
• Exercise both thought leadership and initiative in developing and leading the bank’s efforts to implement changes to the CRA program in response regulatory requirements.
• Stay abreast of CRA related regulatory changes and assist in implementation of requirements for the relevant line of business.

WHAT DO YOU NEED TO SUCCEED?

Required Qualifications*

• Bachelor's Degree or equivalent Economics, Statistics, quantitative research, or a related field
• 7+ years of experience in Data Reporting, CRA or Compliance function.

Additional Qualifications

• Deep knowledge of Regulation BB (CRA), HMDA/Regulation C, and CRA data collection requirements
• Support OCC examination requests by producing accurate data extracts, assessment area analyses, and lending distribution tables
• Track regulatory changes to CRA data collection and reporting requirements (e.g., interagency Q&A updates, CRA modernization rule changes) and update processes accordingly
• Experience in a cross- functional environment working with various consumer and commercial products.
• Knowledge of CRA reporting software (e.g., Wiz, RiskExed) and designing reports in database such as Tableau.
• Some knowledge of 1071 Rule
• Proficient with Microsoft office products, such as Word, Excel, PowerPoint and Outlook.
• Strong attention to detail.
• Strong verbal and written communication skills.
• Strong time management, organizational, analytical, and problem-solving skills; attention to detail.
• Ability to work in a team environment, ability to multi-task and to be flexible.
• Knowledge of Compliance risk framework.

WHAT'S IN IT FOR YOU?

Compensation

Starting base salary: $77,000 - $143,000 per year. Exact compensation may vary based on skills, experience, and location. This job is eligible for bonus and/or commissions.

Benefits and Perks

• Comprehensive healthcare coverage, including Medical, Dental and Vision plans, available the first of the month following start date
• Generous 401(k) company matching contribution
• Career Development through Tuition Reimbursement and other internal upskilling and training resources
• Valued Time Away benefits including vacation, sick and volunteer time
• Specialized health and family planning benefits including fertility benefits, and cancer, diabetes and musculoskeletal support programs
• Career Mobility support from a dedicated recruitment team
• Colleague Resource Groups to support networking and community engagement

Get a more detailed look at our Benefits and Perks.

ABOUT US

Since day one we've always gone further than the competition to help our clients, colleagues and communities flourish. City National Bank was founded in 1954 by entrepreneurs for entrepreneurs and that legacy of integrity, community and unparalleled client relationships continues today. City National is a subsidiary of Royal Bank of Canada, one of North America’s leading diversified financial services companies. To learn more about City National and our dynamic company culture, visit us at About Us.

INCLUSION AND EQUAL OPPORTUNITY EMPLOYMENT

City National Bank foster an inclusive environment where all forms of diversity are valued and leveraged to make us a better company and employer. We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sexual orientation, gender identity, national origin, disability, veteran status or other basis protected by law.

It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.

Unless otherwise indicated as fully remote, reporting into a designated City National location is an essential function of the job.