Financial Crimes Risk & Data Analyst

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

Job summary

Madison-Davis, LLC in New York, NY is seeking a data analytics professional to provide analytical and data support for BSA/AML and sanctions risk assessments. You will gather, reconcile, test, and analyze data across customers, transactions, products, services, channels, and geographic exposure.

You will build advanced SQL queries, perform data quality checks, and develop repeatable reporting and dashboards using SQL, Excel, Power BI to support risk measurement, regulatory examinations, audits,

Qualifications

• Bachelor's degree required in data analytics, information systems, or related field.
• 5+ years of experience across BSA/AML, financial crime compliance, risk management, data analytics, or related functions.
• Advanced SQL skills with demonstrated experience analyzing large and complex datasets.
• Strong Excel skills and experience with Power BI or similar visualization/reporting platforms.

Responsibilities

• Provide analytical and data support for recurring and ad hoc BSA/AML and sanctions risk assessments.
• Gather, reconcile, test, and analyze data across customers, transactions, products, services, channels, and geographic exposure.
• Build and maintain advanced SQL queries to extract and analyze information across multiple systems.
• Perform data quality checks to ensure information used in risk calculations and reporting is complete and defensible.
• Develop repeatable reporting and analytical processes; support dashboards and reporting automation using SQL, Excel, Power BI.

Skills

Advanced SQL

Excel

Power BI

Data analytics

BSA/AML knowledge

Regulatory risk concepts

Education

Bachelor's degree in Data Analytics, Information Systems, or related discipline

Tools

Power BI

SQL databases

Job description

What You ll Do

Provide analytical and data support for recurring and ad hoc BSA/AML and sanctions risk assessments. Gather, reconcile, test, and analyze data covering customers, transactions, products, services, channels, and geographic exposure. Build and maintain advanced SQL queries to extract and analyze information across multiple systems. Perform data quality checks to ensure information used in risk calculations and reporting is complete, accurate, and defensible. Analyze trends and risk indicators to support financial crime risk measurement, management reporting, examinations, audits, and targeted reviews. Maintain data mappings, query logic, technical specifications, and supporting documentation used in risk assessment processes. Partner with technology, data, reporting, governance, and business teams to identify appropriate data sources and translate business needs into technical requirements. Develop repeatable reporting and analytical processes that improve efficiency, consistency, and control. Support dashboards and reporting automation using SQL, Excel, Power BI, or comparable tools. Assist with enhancements to financial crime risk methodologies, data processes, controls, and governance. Provide analysis and supporting evidence for regulatory examinations, internal audits, and independent reviews. Manage multiple deliverables independently, identify dependencies or potential issues, and drive assignments through completion.

Required Background

Bachelor s degree in Data Analytics, Information Systems, or a related discipline. 5+ years of relevant experience across BSA/AML, financial crime compliance, risk management, data analytics, or related functions. Previous experience supporting BSA/AML risk assessments at a large financial institution. Advanced SQL skills with demonstrated experience analyzing large and complex datasets. Strong Excel skills and experience with Power BI or similar visualization/reporting platforms. Working knowledge of BSA/AML, sanctions, financial crime risk, and regulatory expectations. Understanding of financial crime risk assessment concepts and quantitative methodologies. Strong project management and organizational capabilities with the ability to manage competing deadlines. Excellent attention to data integrity, accuracy, and documentation. Ability to work independently, take ownership of deliverables, and follow projects through completion. Strong written and verbal communication skills, particularly when translating business needs into requirements for technical and data stakeholders.