Snowflake Data Engineer

Senior Data Engineer

A senior data engineer with extensive hands-on experience in building and maintaining modern, scalable data pipelines and transformation frameworks. This role involves designing, developing, and optimizing production-grade data solutions using Snowflake, dbt, and Fivetran. The ideal candidate demonstrates strong ownership, accountability, and operational independence to deliver high-quality data infrastructures that meet enterprise standards for performance, cost-efficiency, and reliability.

Responsibilities

• Design, build, and maintain scalable ELT pipelines utilizing Fivetran for ingestion and dbt for transformation on Snowflake.
• Develop and manage modular, reusable dbt models including staging, intermediate, and data marts, with documentation and testing.
• Create scalable data models based on best practices such as star schema, dimensional modeling, and data vault principles.
• Optimize Snowflake performance through query tuning, workload management, micro-partitioning, clustering, and pruning.
• Build and enforce data quality frameworks featuring schema validation, testing, and reconciliation for consistency and accuracy.
• Develop Python scripts for automation, operational tooling, metadata management, and orchestration support.
• Implement and maintain Git-based development workflows including version control, branching, pull requests, and code reviews.
• Build and enhance CI/CD pipelines to enable automated testing, deployment, and environment promotion for data workflows.
• Collaborate with platform, governance, and business teams to align on data requirements, access control, and delivery standards.
• Work with orchestration tools like Airflow or similar to schedule, monitor, and manage data pipeline executions, ensuring operational reliability.

Qualifications

• Over 10 years of experience in data engineering or analytics engineering roles with a focus on scalable data architecture.
• Hands-on production experience with dbt, including model development, dependency management, macros, testing, and deployment.
• Deep Snowflake expertise encompassing data modeling, performance tuning, cost optimization, security, and access control.
• Strong SQL skills for building complex transformations and troubleshooting.
• Proficiency in Python programming for automation, data processing, and operational support.
• Solid experience with Git, including collaborative development workflows and version control.
• Proven track record in designing, building, and maintaining reliable, high-performance data pipelines aligned with SLAs.
• Mandatory: Direct, practical experience with Fivetran connectors setup/troubleshooting, dbt model development/testing, and Snowflake engineering in a production environment.
• Familiarity with orchestration, CI/CD pipelines, and monitoring tools preferred.
• Excellent communication skills with the ability to work independently and actively collaborate across teams.
• Availability to work on-site at the designated location.

Publishing Pay Range: $60.00 to $70.00 hourly

This position is based in office and requires employee to work on-site.

At GDH, we believe in the power of people and the importance of caring. Our culture statement, "We care about people," isn't just a tagline – it's the core of everything we do. GDH is a premier staffing and talent solutions company dedicated to helping businesses find the best talent and assisting job seekers in finding their dream jobs.

GDH, founded in 2001, has grown into a leader in providing staffing solutions across various industries. We specialize in IT across several sectors, connecting top talent with leading enterprises. As a Best of Staffing firm recognized for excellence in client, employee, talent, and women's services, we pride ourselves on our commitment to quality and service.

GDH offers a range of employee benefits that are designed to promote well-being and help maintain a healthy work-life balance. These comprehensive benefits cover various aspects of an employee's life and aim to enhance their overall experience with the company. Our health benefits include three medical insurance options with access to KISx Card, Zero Card, and HealthJoy concierge services. Other plan offerings include dental, vision, life, disability, supplemental insurance, and pet insurance plans. Enjoy additional perks like holiday pay, 401(k) plan, direct deposit, an employee referral program, work-life balance benefits, a Wellbeats membership, a discounted gym membership program, and more! For more detailed information on benefits, please go to GDH's website under the tab for candidates.

GDH provides equal employment opportunities (EEO) to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, gender, sex (including pregnancy), sexual orientation, gender identity, national origin, age, disability, genetic information, marital status, ancestry, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable federal, state, and local laws. Applicants with disabilities who require an accommodation or assistance in applying and/or for interviewing, please contact our HR Department.

Please visit our notice of collection for California applicants.