Our client, an IT Services and Consulting company, is looking for a Senior Data Engineer (Snowflake, dbt, Fivetran) for their Richardson, TX/Dallas, TX/Hybrid location.
Responsibilities:
Design, build, and maintain scalable ELT pipelines, leveraging Fivetran (or similar tools) for ingestion and dbt for transformation.
Develop and maintain robust dbt projects, including:
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.
Requirements:
We are seeking 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 and Snowflake engineering, along with a strong sense of ownership, accountability, and the ability to operate independently. Fivetran experience is beneficial, but the primary focus is on dbt and Snowflake expertise.
10+ years of experience in data engineering / analytics engineering roles.
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
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
Advanced SQL expertise with ability to build and optimize complex transformations.
Strong Python programming skills for data engineering use cases.
Proven experience with Git integration, including collaborative development workflows.
Strong experience implementing CI/CD pipelines for data platforms and dbt deployments.
Experience building and maintaining production-grade data pipelines with SLAs, monitoring, and reliability standards.
Experience with Fivetran (connector setup, ingestion patterns, schema management, troubleshooting).
Experience with Airflow / Astronomer or similar orchestration tools.
Exposure to data governance, lineage, and observability tools.
Financial services / banking domain experience is strongly preferred and will be prioritized, though not mandatory.
Demonstrates strong ownership and accountability, taking full responsibility for deliverables and outcomes end-to-end.
Highly self-motivated and proactive, able to operate independently and drive work forward with minimal oversight.
A continuous learner who stays current with evolving data technologies and applies best practices effectively.
Takes initiative to identify issues, improve systems, and deliver scalable, high-quality solutions in a fast-paced environment.
Delivers well-structured, scalable, and reusable dbt models with strong testing and documentation.
Builds Snowflake solutions that are high-performing, cost-efficient, and production-ready.
Implements robust CI/CD and Git-driven engineering practices ensuring reliable deployments.
Develops pipelines that are well-orchestrated, monitored, and governed.
Consistently operates with high ownership and delivers quality outcomes at scale.