Senior Data Engineer

HEITMEYER CONSULTING INC; Dallas (TX); On-site; USD 120,000 - 150,000; Full time

Job summary

HEITMEYER CONSULTING INC is looking for a Senior Data Engineer based in Dallas, TX. The ideal candidate will have significant hands-on experience in building scalable data solutions using dbt and Snowflake, alongside expertise in Fivetran.

This role demands advanced skills in developing production-grade data pipelines and CI/CD implementations. Candidates will be expected to work closely with business and analytics teams while ensuring data quality and optimizing performance.

Qualifications

• 10+ years of experience in data engineering or analytics engineering roles.
• Strong hands-on experience with dbt in production.
• Deep understanding of Snowflake architecture.

Responsibilities

• Design, build, and maintain scalable ELT pipelines using Fivetran and dbt.
• Develop and maintain robust dbt projects.
• Implement modular dbt architecture for multi-environment deployments.

Skills

Data engineering / analytics engineering experience

dbt expertise

Snowflake expertise

Advanced SQL skills

Python programming

Git integration experience

CI/CD pipeline implementation

Fivetran experience

Tools

Snowflake

dbt

Fivetran

Airflow / Astronomer

Job description

Heitmeyer Consulting has a banking client that has a need within their Chief Data Office for a Senior Data Engineer who is highly hands‑on and experienced in building modern, scalable data pipelines and transformation frameworks using Snowflake and dbt. This role focuses on delivering high‑quality, production‑grade data solutions with strong engineering discipline, leveraging Python, CI/CD, and Git‑based development practices.

The ideal candidate brings deep, practical experience in dbt coding, Snowflake engineering, and Fivetran, along with a strong sense of ownership, accountability, and the ability to operate independently. Direct, hands‑on experience with Fivetran, dbt, and Snowflake is a mandatory screening requirement. Candidates without strong hands‑on experience across all three will not be considered.

The ideal candidate is a strong individual contributor who enjoys building production‑ready data solutions, collaborating with analytics and business teams, and helping shape scalable data platforms that support critical business decisions. Role must be based in Dallas, TX.

Top Required Skills

1. 10+ years of experience in data engineering / analytics engineering roles.
2. Strong hands‑on experience with dbt in production, including:
   • Model development and dependency management
   • Macro development and reusable frameworks
   • Testing strategies (schema tests, custom tests)
   • Deployment and environment management
3. Strong Snowflake expertise, including:
   • Data modeling and warehouse design
   • Performance tuning and cost optimization
   • Deep understanding of virtual warehouses, micro-partitions, clustering, and query pruning
   • Role‑based access control (RBAC) and secure data access
4. Advanced SQL expertise with ability to build and optimize complex transformations.
5. Strong Python programming skills for data engineering use cases.
6. Proven experience with Git integration, including collaborative development workflows.
7. Strong experience implementing CI/CD pipelines for data platforms and dbt deployments.
8. Experience building and maintaining production‑grade data pipelines with SLAs, monitoring, and reliability standards.
9. Mandatory requirement: direct, hands‑on experience with Fivetran, dbt, and Snowflake in production, including Fivetran connector setup and troubleshooting, dbt model development and testing, and Snowflake data engineering, performance tuning, and secure access patterns. This is a strict screening criterion.

Nice‑to‑have

1. Experience with Airflow / Astronomer or similar orchestration tools.
2. Exposure to data governance, lineage, and observability tools.
3. Financial services / banking domain experience is strongly preferred and will be prioritized, though not mandatory.

Key Responsibilities

• Design, build, and maintain scalable ELT pipelines, leveraging Fivetran for ingestion and dbt for transformation on Snowflake. Direct hands‑on experience with Fivetran, dbt, and Snowflake is required for this role.
• Develop and maintain robust dbt projects, including:
  • Modular models (staging, intermediate, marts)
  • Reusable macros and Jinja templating
  • Snapshots for SCD Type 2 handling
  • Schema and custom data quality tests
  • Documentation using dbt docs
• Implement modular and reusable dbt architecture supporting multi‑environment deployments (dev, test, prod).
• Design and implement scalable data models using best practices (dimensional modeling, star schema, and data vault where applicable).
• Optimize Snowflake performance and cost efficiency, including:
  • Query tuning and execution optimization
  • Warehouse sizing and workload management
  • Effective use of micro‑partitions, clustering, and pruning
• Build and enforce strong data quality and validation frameworks, including:
  • Unit testing for transformations (dbt and custom frameworks)
  • Data reconciliation and consistency checks
• Develop Python‑based solutions for automation, orchestration support, metadata‑driven processing, and operational tooling.
• Implement and enforce Git‑based development practices:
  • Version control, branching strategies, pull requests, and code reviews
  • Consistent and collaborative engineering workflows
• Build, maintain, and enhance CI/CD pipelines for dbt deployments:
  • Automated build, test, and deployment processes
  • Environment promotion (dev ? test ? prod)
  • Integration with enterprise deployment pipelines
• Work with orchestration tools such as Airflow / Astronomer to schedule, monitor, and manage data pipeline execution (preferred).
• Collaborate closely with platform, governance, and business teams to align on data requirements, access control, and delivery expectations.

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.