Compliance Data Analyst

Job Summary 

The Compliance Data Analyst is responsible for supporting the Compliance Department with the ongoing data collection, review, research and analyzing of the Bank’s compliance-related data ensuring accuracy and completeness at remaining compliant with regulatory requirements, including obtaining key data for second line of defense compliance testing and other activities. 

This includes supporting the CRA Program, Fair Lending Program, Home Mortgage Disclosure Act/Loan Application Register and using a variety of software and resources to determine fair lending assessment, CRA qualification and ensure proper documentation for CRA reporting, ensuring technical compliance with applicable laws and regulations.

The Compliance Data Analyst ensures timely validation, monitoring, analysis, and reporting of compliance related data for risk identification and reporting purposes.   This position will support all data needed to support an effective compliance program.  

Essential Duties 

• Responsible for managing a large population of various data sets for fair lending, community reinvestment, and various compliance risk assessment purposes. 
• Responsible for ensuring data is complete and accurate. This includes collecting, reviewing, researching, remediation, and analyzing activity using a variety of software and resources to ensure proper and accurate reporting and filing, as needed. 
• Responsible for supporting CRA program in areas related to:
  1. Conduct Small Business and Small Farm Loan reviews.  Involves creating documentation packets, verifying loan data to ensure data integrity, monitoring and documenting data reporting errors, and making necessary corrections.
  2. Conduct Community Development Loan reviews.  Involves creating documentation packets and gathering information on certain loan transactions, conducting research to determine eligibility, and preparing written analyses.
  3. Conduct Community Development Investment reviews.  Involves gathering information on Bank investments, conducting research to determine eligibility, and preparing written analyses.
  4. Conduct Community Development Service activity reviews.   Involves reviewing service reports, conducting research to determine eligibility, and preparing written analyses.
• Assist with generating and developing reports to support the Chief Compliance Officer to present to management, Board, and regulatory examiners.
• Assist with the coordination and monitoring of related projects and initiatives.
• Assist with preparation and support of regulatory examinations and internal audits.  
• Assist in maintaining the Banks CRA Public File.
• Assist in the annual regulatory submission of compliance required data (e.g., CRA and HMDA) to ensure accurate and timely filings.

Complies with all State and Federal Banking regulatory requirements, including but not limited to: BSA, Anti-Money Laundering OFAC, CIP, Financial Elder Abuse Reporting, Sexual Harassment, Information Security and privacy requirements.  This position will elevate suspicious activity to supervisory staff and/or BSA department.  Completes compliance and other technical training workshops as assigned.

Required Knowledge 

• Working experience in a regional bank is preferred
• Working knowledge of key banking regulations and requirements
• Data management experience using macros, SQL, Python or other data analytics tools
• Strong working experience with analyzing data to identify trends, risks and patterns

• Strong computer skills: Outlook, MS Excel, Word and PowerPoint
• Quick learner and able to take mass data and translate to meaningful and layman output

Basic Knowledge, Skills and Abilities 

• Critical thinking, judgment & problem-solving skills
• Flexible and adaptable to new requirements and assignments

• Active listener and keen to learn and respectfully challenge status quo to improve efficiencies and processes
• Strong communication skills, both written and verbal
• The individual for this role is proactive and resourceful to find relevant information to support the task and compliance program
• Experience with collecting, analyzing and reporting data
• Experience with working with third parties to understand the application, software to effectively execute data analytic activities
• Proficiency using various software programs, including but not limited to:
  1. Microsoft Office Suite (Word, Excel, PowerPoint); intermediate Excel skills at a minimum
  2. Laserfiche
  3. B.O.S.S. 
  4. CRA Wiz 
  5. NContracts for fair lending
  6. Verafin for BSA monitoring and reporting purposes
• Strong ability to build collaborative relationships with various business unit managers to improve operational processes associated with regulatory reporting requirements.

Officer Title Eligibility 

For qualified positions, the Bank may designate Officer Titles to employees who meet defined competencies for an eligible position. This position is not eligible for an Officer Title.

Equipment Operated 

• Desk top Computers 
• Standard Office Equipment (copiers, fax machines) 

Physical Requirements & Work Environment 

• Requires repetitive movement.
• Requires sitting for prolonged periods of time.
• Requires lifting up to 25lbs.
• Requires using hands to handle, control or feel objects.
• Office setting w/controlled temperature.

Education and Experience 

• Bachelor’s Degree or equivalent work experience required 
• Working experience in a regional banking environment is preferred 
• Preferred candidate must have 3+ years of experience with data analytics in a banking environment. 

This job description is not intended to be all-inclusive, and employees will be required to perform additional related work duties as assigned by their immediate supervisor and/or management.

Farmers and Merchants Bank of Long Beach reserves the right to revise or change job duties and responsibilities as the need arises. This job description does not constitute a written or implied contract of employment.

April 04, 2025