Senior Python Data Engineer

Location: 4 days onsite per week in Buffalo, NY

Duration: 12 months with strong potential for conversion to full?time based on performance and headcount

Job Summary:

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

Top Responsibilities:

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

Must?Have 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.
  
  
  

Heitmeyer Consulting is an equal opportunity employer, and we encourage all qualified candidates to apply. Qualified applicants will be considered without regard to minority status, gender, disability, veteran status, or any other characteristic protected by law.