Senior Data Analyst: Financial Crime & Data Pipelines

Madison-Davis, LLC; United States; Remote; USD 120,000 - 180,000; Full time

Job summary

Madison-Davis, LLC is seeking a senior, hands-on data professional to support an enterprise financial crime risk program. The role sits at the intersection of data engineering, analytics, regulatory risk, and business stakeholder management, focusing on building repeatable data processes, pipelines, and data quality controls.

You will work with SQL across source systems, translate requirements into technical logic, and assume end-to-end ownership, partnering with technology and business teams to

Qualifications

• Strong hands-on experience writing advanced SQL against large and complex datasets.
• Experience building or maintaining data pipelines, transformations, mappings, or comparable data-engineering processes.
• Background working with data across multiple enterprise source systems.
• Understanding of BSA/AML, financial crime, risk and controls, sanctions, or another regulated risk environment.

Responsibilities

• Build and maintain data pipelines and repeatable data processes supporting financial-crime risk analysis.
• Write and optimize complex SQL queries across multiple enterprise data sources.
• Translate business and regulatory requirements into technical data requirements, mappings, and query logic.
• Validate the completeness, accuracy, and integrity of data used in risk reporting and assessment processes.
• Partner with technology, data, governance, analytics, and business stakeholders to source and validate information.
• Investigate data discrepancies and coordinate with source-system owners to resolve issues.
• Maintain detailed documentation around data sources, transformation logic, validation procedures, and controls.
• Support regulatory, audit, governance, and management reporting requirements.

Skills

SQL

Data pipelines

Data quality

Documentation

Stakeholder communication

Education

Bachelor's degree in Information Systems, Data Analytics, Engineering, Statistics

Tools

Power BI

Job description

Madison-Davis, LLC is seeking a senior, hands-on data professional to support an enterprise financial crime risk program. The role sits at the intersection of data engineering, analytics, regulatory risk, and business stakeholder management, focusing on building repeatable data processes, pipelines, and data quality controls.

You will work with SQL across source systems, translate requirements into technical logic, and assume end-to-end ownership, partnering with technology and business teams to