Bachelor's Degree in Economics, Statistics or related field
7+ years in Data Reporting, CRA or Compliance processes
Deep knowledge of CRA regulations and data requirements
Experience with CRA reporting software such as Wiz or RiskExec
Strong analytical, problem-solving, and organizational skills
Responsibilities
Review loan files for CRA data accuracy and completeness
Gather research to review community development loans
Use CRA Wiz or RiskExec for data management
Log and address data issues with business and technology teams
Prepare error reports and analyze data trends
Collaborate with LOBs to enhance data quality
Support annual CRA Loan Register submissions
Benefits
Comprehensive healthcare coverage starting from the first month
Generous 401(k) matching contributions
Career development support with tuition reimbursement
Valued Time Away benefits including vacation and sick time
Specialized health and family planning programs
Career mobility support from a dedicated team
Networking opportunities through Colleague Resource Groups
Full Job Description
CRA DATA ANALYTICS ANALYST
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
At City National, we strive to be the best at whatever we do, including the benefits and perks we offer our colleagues including:
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 City National Bank (CNB)
City National Bank is a regional bank that was founded in 1954. The bank provides a range of financial services to individuals and businesses. City National Bank has branches in California, Nevada, New York, Georgia, Tennessee, and Washington, D.C. The bank is a subsidiary of the Royal Bank of Canada.