Senior Data Engineer: Snowflake, dbt & Airflow

TechWish; New York (NY); On-site; USD 120,000 - 200,000; Full time

Job summary

Fractal design is seeking an experienced Data Engineer to design, build, and maintain robust data pipelines on Snowflake and AWS. You will transform and ingest data from diverse sources, implement data quality checks, and optimize performance at scale using dbt and Airflow.

In this collaborative role, you will work closely with analytics engineers, BI teams, and business stakeholders to deliver production-grade data solutions, ensure governance, and advance our analytics capabilities across the

Qualifications

• 6-10 years of hands-on data engineering experience
• 3+ years with modern cloud data platforms (Snowflake, BigQuery, Redshift, Databricks)
• 3+ years with orchestration tools (Airflow, Prefect, Dagster)
• 2+ years building data transformation logic with dbt or equivalent
• Expert-level SQL: complex queries, window functions, optimization
• Proficiency in Python for data engineering tasks
• Strong knowledge of Snowflake, dbt, and Airflow
• AWS services: S3, Lambda, EC2, IAM, CloudWatch
• Understanding of data quality testing and monitoring
• Experience with version control (Git) and CI/CD practices

Responsibilities

• Design and develop version-controlled data pipelines using dbt and Airflow on Snowflake and AWS
• Ingest data from diverse sources (REST APIs, databases, S3, Splunk, SFTP) following internal standards
• Implement data quality checks, monitoring, and alerting to ensure pipeline reliability
• Optimize query performance and pipeline efficiency through systematic analysis and tuning
• Maintain comprehensive documentation of data architecture, lineage, and dependencies
• Participate in code reviews and mentor junior team members on best practices
• Troubleshoot failed DAGs and resolve production data issues with urgency
• Support feature enhancements and ad-hoc analysis requests from analytics teams
• Implement geospatial data engineering solutions for location-based retail analytics
• Ensure compliance with data governance and PII protection requirements
• Collaborate with analytics engineers and BI teams on data modeling and schema design

Skills

Snowflake

BigQuery

Redshift

Databricks

Airflow

dbt

SQL

Python

AWS

Git

CI/CD

Education

Bachelor's degree in CS/Engineering

Masters preferred

Tools

Git

S3

Lambda

EC2

CloudWatch

Job description

Fractal design is seeking an experienced Data Engineer to design, build, and maintain robust data pipelines on Snowflake and AWS. You will transform and ingest data from diverse sources, implement data quality checks, and optimize performance at scale using dbt and Airflow.

In this collaborative role, you will work closely with analytics engineers, BI teams, and business stakeholders to deliver production-grade data solutions, ensure governance, and advance our analytics capabilities across the