ERM Data Analyst

Farmers and Merchants Bank of Long Beach•Lakewood, CA

About The Position

The ERM Data Analyst assists in the execution of F&M’s Enterprise Risk Management (ERM) data management goals. This role emphasizes data analytics and automation (leveraging Python, SQL and Power BI) to enhance regulatory compliance monitoring, streamline processes, and strengthen risk reporting. Serves as a support resource for risk analytics and compliance reporting for the 2LOD. This position also provides system administration and governance support for the Verafin FRAML system and the BSA/AML and Fraud models as it relates to tuning and calibration. Additional support responsibilities include ensuring the integrity of the ERM enterprise-wide monitoring by performing data and control testing, analyzing data quality, as well as analyzing system parameters and scenarios for various monitoring systems including Verafin, sanctions screening platforms such as Bridger Insight, and Quantivate’s Governance, Risk & Compliance (GRC) solution. This position maintains core competencies and essential knowledge in Nasdaq Verafin and other applications, including Jack Henry, Power BI and Bridger Insight.

Requirements

Bachelor’s degree in data analytics, information systems, finance or related field.
5+ years of experience in risk data analytics, such as BSA/AML, risk and compliance analytics
Strong proficiency with Python, SQL, Power BI and data warehouses.
Experience with Verafin FRAML, including administration and/or model tuning/calibration and system support.
Knowledge of regulatory frameworks: BSA/AML, CRA, Fair Lending, MRM (SR 11-7 / OCC 2011-12)
Clear understanding of the English Language (Spoken & Written)
Critical Thinking, Judgment & Problem-Solving Skills
Ability to respectfully communicate with supervisors and co-workers
Proficient in Microsoft Excel, Word, Outlook.
Requires repetitive movement.
Requires standing and/or sitting for prolong periods.
Requires lifting up 10 lbs.

Nice To Haves

CAMS Certification preferred but not required.

Responsibilities

Build data pipelines, analytics models, and dashboards that transform complex risk and compliance datasets into actionable insights.
Use Python to: Automate recurring compliance tasks (data quality checks, reconciliation, monitoring scripts), Perform statistical analysis (alert rate, false positive ratio, model performance trends), Conduct anomaly detection, trend analysis and pattern recognition to enhance AML and fraud insights.
Develop and maintain Power BI dashboards to track production for Verafin (alerts, cases, EDDs, SARs).
Create interactive compliance and risk reports (BSA/AML, Fair Lending, CRA) to support regulatory examinations and management reporting.
Utilize enterprise data warehouse tools to aggregate, validate, and reconcile data from multiple systems.
Partner with IT/Business Intelligence team to ensure SQL based data integration from warehouse source into ERM reporting environments.
Automate compliance processes, calculations, reduce manual efforts and improve department’s efficiencies for effective second line of defense program, which includes monitoring and testing activities.
Partner with Compliance and BSA Departments to align monitoring and reporting with internal and external stakeholders.
Support model owners with documentation, testing support, outcome analysis, and ongoing monitoring.
Support risk and compliance reporting deliverables for regulators, internal audit, and management committees.
Responsible for pulling and/or inputting all applicable data for risk assessments performed by the Compliance and BSA Departments.
Support model owners with documentation, back-testing, and outcome analysis in line with SR 11-7/ OCC 2011-12, and ongoing monitoring.
Perform data driven analysis of BSA/AML model performance (alert quality, false positive, SAR outcomes).
Assist in tuning and calibration of Verafin FRAML models by recommending parameters adjustments backed by statistical evidence.
Document tuning rationale and ensure alignment with model governance approval processes.
Provide business-facing system administration support for 2LOD applications: Conduct release testing and escalate vendor issues as needed, Develop governance processes to support Verafin, GRC and other applications including system inputs, data quality and management and day to day activities, Manage system parameters/user permission settings, Assist with workflow configurations and queue management.
Report directly to ERM Data Manager and provide senior level support for risk analytics and data driven reporting initiatives.
Contribute to ERM data governance, automation and analytics strategy.
Function as subject matter experts on BSA/AML data analytics, Fraud data analytics, FRAML system metrics, and regulatory data insights.
May assist in performing monthly/quarterly certifications.
Recommends enhancements and/or input regarding monitoring activities, procedural updates, revisions or creation of department desk procedures to BSA Management.
Performs special projects and other related duties as assigned or requested.
Maintains documentation on the internal, BSA SharePoint.
Complies with all State and Federal Banking regulatory requirements, including but not limited to: BSA, AML, OFAC, CIP, Financial Elder Abuse Reporting, Sexual Harassment, Information Security and privacy requirements. This position will elevate potentially suspicious activity to Management. Completes compliance and other technical training workshops as assigned.
Testing, tuning, ticket/case creating and tracking, and administrator of Verafin.
Maintains System Parameters/User Permission Settings.
Creation of Model Risk Management (MRM) documentation.
Create and maintain policies and procedures Compliance Monitoring & Support.
Verafin Model Calibration/Tuning.
Compile Data and support management with creating Presentation Decks for Management and Board Committees.