Database / Data Warehouse

We are seeking a Senior Data Engineer to support our banking client's regulatory remediation and transformation program aligned with AML/BSA/KYC initiatives. This role focuses on consolidating enterprise data, building scalable Python services and secure APIs, and enabling transparent, explainable reporting for compliance and business stakeholders. The ideal candidate has a strong analytical mindset, can trace data lineage end?to?end, and clearly explain "why the data looks like this.", * Analyze and profile enterprise data stored in Snowflake, understanding data structures, lineage, and relationships.

• Perform data validations, quality checks, and metadata reviews to ensure accuracy and completeness.
• Translate business and regulatory reporting requirements into detailed technical specifications.
• Build and maintain Python?based microservices to orchestrate and automate ELT/ETL workflows.
• Develop secure Flask APIs to expose and consume data services for ARK and reporting systems.
• Design and build PostgreSQL data models optimized for analytics and regulatory reporting.
• Translate business requirements into reporting?ready data models for Power BI, including calculated fields and summaries.

• Strong Python experience in data processing, data manipulation, building data pipelines, consolidating data from multiple source systems, and ensuring data quality.
• Strong SQL and data analysis skills; ability to query across databases (PostgreSQL used in this environment).
• Proven analytical problem?solving skills to investigate production issues, trace data behavior, and clearly explain findings to business users.
• Experience summarizing multi?source data for business audiences, building dashboards and reports (Power BI preferred).
• Background in fintech, payments, fraud detection, or transaction?based systems.

Nice?to?Have Qualifications

• Experience or familiarity with KYC, BSA, and AML processing or compliance workflows.
• Experience working with Snowflake and using pandas for data analysis.