CRA Data Analytics Analyst
About this role
- 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.
- Bachelor's Degree or equivalent Economics, Statistics, quantitative research, or a related field
- 7+ years of experience in Data Reporting, CRA or Compliance function.
- 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.
- 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
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.
Represents basic qualifications for the position. To be considered for this position, you must at least meet the required qualifications. careers.cnb.com accepts applications on an ongoing basis, until filled.
Unless otherwise indicated as fully remote, reporting into a designated City National location is an essential function of the job.
Company at a glance
City National Bank, a subsidiary of Royal Bank of Canada, is the largest bank headquartered in Los Angeles with $93 billion in assets as of July 31, 2025. Founded in 1954, City National provides personalized banking, investment and trust services in select markets including Los Angeles, Orange County, San Diego, the San Francisco Bay Area, New York City, Nashville, Atlanta, Delaware, Las Vegas, Washington D.C. and Miami.* In addition, the company and its investment affiliates manage or administer $106 billion in client investment assets. City National is dedicated to strengthening communities, and in 2024 alone, the company made charitable contributions of nearly $10 million in charitable contributions to nonprofits that support the communities it serves.
*City National Bank does business in Miami and the state of Florida as CN Bank.
Top Benefits
- Comprehensive healthcare coverage
- Medical plan
- Dental plan
- Vision plan
- 401(k) company matching contribution
- Tuition reimbursement
- Vacation time
- Sick time
- Volunteer time
- Fertility benefits
- Cancer support programs
- Diabetes support programs
- Musculoskeletal support programs
Tired of cold applications?
Sign up with Clera and we'll reach out the moment a role actually fits you — no more spraying applications into the void.
Know someone who'd be great for this?