Regulatory Reporting Analyst III

Overview

The purpose of this role is to support the processes that ensure data integrity and accuracy for required regulatory annual filings for the Home Mortgage Disclosure Act (HMDA) and Small Business/Small Farm (CRA) Loan Application Registers (LARs). Additionally, the role requires interpretation of the data through statistical and trend analysis to determine fair lending risk exposure for the bank.

• Maintain LARs by ensuring they are complete and accurate throughout the year, ensuring all reportable applications, loans, or line data is received in the Data Warehouse, maintaining and updating data in the data collection software, and performing periodic reviews to ensure data integrity.
• Review reports to detect and correct errors on reportable applications, loans, and lines.
• Assist in performing reviews of validity edits, statistical edits, and quality edits to assure accuracy of the LARs.
• Work with business lines to ensure that identified exceptions are cleared and errors are corrected.
• Assist with special projects assigned by the Regulatory Reporting Compliance Manager and/or the Fair and Responsible Banking Director.
• Stay current on various databases' capabilities and enhancements that affect review and verification processes.
• Provide backup for the other Regulatory Reporting Analyst as needed.
• Coordinate, assist and maintain LARs by performing data imports, downloads, exports, report generation, and data capture.
• Assist in the coordination and performance of data integrity reviews, evaluate deficiencies for root cause(s) and make recommendations to management.
• Assist in submission processes including coordination and perform reviews of logic, validity edits, statistical edits, and quality edits to assure accuracy of the LARs.
• Participate in real-time analytical analysis of LAR and Non-LAR data to support analytic performance and assessment in all lending lines.
• Assist the Regulatory Reporting Compliance Manager in determining the bank's training needs.
• Work in conjunction with department, business line management and IT incorporating any regulatory changes impacting regulatory reporting.
• Provide guidance to Regulatory Reporting Analysts regarding accurate LAR reporting, fair lending best practices and other issues as they arise.
• Handle special projects that analyze and interpret LAR data assigned by the Regulatory Reporting Compliance Manager and/or the Fair and Responsible Banking Director.
• Assist the Regulatory Reporting Compliance Manager with internal audits, regulatory exams, and compliance, including ensuring policies and procedure documents are kept up to date.
• Perform additional duties as assigned.

• 4 year college degree with 2+ years related work experience, preferably in regulatory reporting (HMDA/CRA LAR) in a midsize or large bank environment
  -OR- 2 year college degree with 3+ years related work experience, preferably in regulatory reporting (HMDA/CRA LAR) in a midsize or large bank environment
  -OR
  - High School graduate with 5+ years related work experience, preferably in regulatory reporting (HMDA/CRA LAR) in a midsize or large bank environment.
• Advanced knowledge of the Home Mortgage Disclosure Act (HMDA/Reg
  
  C).
• Advanced knowledge of the Community Reinvestment Act (CRA/Reg. BB).
• Advanced knowledge of policies, practices, and operations that impact data collection and reporting.
• Adept at using loan underwriting and servicing systems.
• Knowledge of lending (mortgage, consumer, small business) bank-specific policies, practices, and operations.
• Knowledge of loan underwriting and servicing systems such as ACTion, Partners, B2B, FIS, M&I, or other similar platforms.
• Knowledge of specialized analytical software such as CRA Wiz, Lending Patterns, Risk Exec, or other similar platforms.
• Advanced knowledge of federal and state banking laws and regulations.
• Advanced computer skills (Excel, database management).
• Ability to work independently and as a team for collaboration when needed.
• Advanced attention to detail and quality, accurate, organized, and dependable.
• Leadership skills: decision making, problem solving, and managing conflicts.
• Advanced communication skills (presentation and written).
• Ability to train others.
• Certified Regulatory Compliance Manager (CRCM) preferred.

Must be able to sit for long periods of time and use computer keyboard and/or mouse, while viewing computer screens.