Financial Crimes Risk & Data Analytics – Analyst

Madison-Davis, LLC; New York (NY); On-site; USD 120,000 - 180,000; Full time

Job summary

Madison-Davis, LLC in New York seeks an experienced data analytics professional to support enterprise financial crimes risk management initiatives, including BSA/AML and sanctions compliance, regulatory reporting, and process improvement.

You will build SQL queries, dashboards, and automated workflows, partner with Technology and Compliance teams, and prepare materials for regulatory examinations and management reviews.

Qualifications

• Bachelor's degree in data analytics, information systems or related field.
• 5+ years of experience in financial crimes compliance, BSA/AML or risk analytics.
• Advanced SQL proficiency with large, complex data sets.
• Strong Excel skills and Power BI or similar visualization tools.
• Knowledge of BSA/AML and OFAC risk assessment methods.

Responsibilities

• Analyze data sets to identify financial crime risk trends across customers, products, and geographies.
• Support BSA/AML and sanctions risk assessments with data collection and quantitative analysis.
• Develop and optimize SQL queries to extract information from multiple systems.
• Collaborate with Tech, BI, and Compliance to define data requirements and improve reporting.
• Build dashboards and automated workflows using SQL, Excel, and Power BI.
• Conduct data quality reviews to ensure accuracy and completeness.
• Contribute to enhancements of risk methodologies and data governance practices.
• Prepare analytical documentation for regulatory examinations and audits.
• Coordinate projects and communicate findings to stakeholders.

Skills

SQL

Excel

Education

Bachelor's degree in data analytics, information systems, or related discipline

Tools

Power BI

Job description

A leading financial institution is seeking an experienced data analytics professional to support enterprise financial crimes risk management initiatives. This role combines advanced technical analysis with BSA/AML and sanctions compliance, offering the opportunity to contribute to risk assessments, regulatory reporting, and process improvements.

Key Responsibilities

• Analyze complex data sets to identify financial crime risk trends across customers, products, transactions, and geographic markets.
• Support periodic BSA/AML and sanctions risk assessments through data collection, validation, and quantitative analysis.
• Develop, maintain, and optimize advanced SQL queries to extract and evaluate information from multiple systems.
• Partner with Technology, Business Intelligence, and Compliance teams to establish data requirements and improve reporting accuracy.
• Build dashboards, analytical reports, and automated workflows using SQL, Excel, Power BI, and related tools.
• Conduct data quality reviews to ensure accuracy, completeness, and consistency of risk assessment information.
• Support enhancements to risk assessment methodologies, reporting processes, and data governance practices.
• Prepare analytical documentation and supporting materials for regulatory examinations, internal audits, and management reviews.
• Coordinate multiple projects, communicate findings to stakeholders, and ensure timely completion of deliverables.

Required Qualifications

• Bachelor's degree in Data Analytics, Information Systems, or a related discipline.
• 5+ years of experience in financial crimes compliance, BSA/AML, risk management, data analytics, or a related field.
• Experience supporting BSA/AML risk assessments within a large financial institution.
• Advanced SQL proficiency with hands-on experience querying and analyzing large, complex data sets.
• Strong Excel skills and experience with Power BI or comparable reporting and visualization platforms.
• Understanding of BSA/AML, OFAC sanctions, and financial crime risk assessment methodologies.
• Strong analytical, problem-solving, project management, and organizational skills.
• Excellent communication skills, including the ability to translate business needs into technical data requirements.
• Ability to independently manage deliverables while maintaining strong attention to detail and data accuracy.

Preferred Qualifications

• Consulting experience involving banking, financial crimes, regulatory compliance, or risk management.
• Experience with data automation, reporting enhancements, or risk assessment methodology improvements.