Senior Data Engineer (Snowflake, dbt, Fivetran)

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.

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

 
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.
• 12.00 Years of Experience

 
Why Should You Apply?

• Health Benefits
• Referral Program
• Excellent growth and advancement opportunities