Database / Data Warehouse

Heitmeyer Consulting
Buffalo, United States of America
2 months ago

Role details

Contract type
Temporary to permanent
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Buffalo, United States of America

Tech stack

API
Data analysis
Databases
Data as a Services
ETL
Data Structures
Fraud Prevention and Detection
Python
PostgreSQL
Power BI
SQL Databases
Data Processing
Flask
Snowflake
Build Management
Data Lineage
Data Pipelines
Microservices

Job description

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.

Requirements

  • 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.

Apply for this position