DBT Engineer with Airflow & SQL

Quantum Technologies LLC

Pennsylvania

Hybrid

USD 90,000 - 103,000

Full time

6 days ago
Be an early applicant

Get a reply from this recruiter

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Quantum Technologies LLC in Oaks, PA is seeking an experienced DBT Engineer with strong SQL, Python, Airflow, and Snowflake expertise. The role focuses on building and maintaining scalable data transformation models and ELT/ETL pipelines while ensuring data quality, security, and performance.

The ideal candidate will design efficient data warehouse structures, optimize queries, and implement robust testing and RBAC-based security in Snowflake. Hybrid onsite flexibility offered.

Qualifications

  • 5+ years of experience with DBT development.
  • 3+ years of experience with Python development.
  • 3+ years of experience with Apache Airflow.
  • 3+ years of experience with Snowflake.
  • Strong SQL development and query optimization skills.
  • Good understanding of data warehousing concepts.
  • Bachelor's degree in Computer Science, Data Engineering, or a related field.

Responsibilities

  • Develop and maintain DBT models, macros, and SQL scripts to transform data within Snowflake.
  • Optimize data models and design star and snowflake schemas.
  • Manage data warehouse performance and implement clustering and materialized views.
  • Create scalable ELT/ETL pipelines to ingest and transform data from multiple sources.
  • Write modular and testable SQL code using version control.
  • Manage DBT project structures and development workflows.
  • Implement data quality checks, automated testing, and anomaly detection.
  • Implement data security measures, including RBAC, data masking, and row-level access controls in Snowflake.
  • Collaborate with data engineering and analytics teams.

Skills

DBT
Python
Airflow
Snowflake
SQL
Data warehousing concepts

Education

Bachelor's degree in Computer Science, Data Engineering, or a related field

Tools

Snowflake
DBT
Python
Airflow
SQL

Job description

US Citizen, Green Card, H-1B, OPT-EAD, CPT, Other

Job Title: DBT Engineer with Airflow & SQL
Location: Oaks, PA (Hybrid – 3 Days Onsite per Week)
Duration: 12+ Months
Bill Rate: $65 (C2C)
Job Type: W-2, 1099, C2C
Client: To be Disclosed
Work Authorization: US Citizen, Green Card, OPT-EAD, CPT, H-1B, H4-EAD, Other

Job Description:

We are seeking an experienced DBT Engineer with strong expertise in SQL, Python, Apache Airflow, and Snowflake. The ideal candidate will be responsible for developing and maintaining scalable data transformation models and ELT/ETL pipelines while ensuring data quality, security, and performance.

Roles and Responsibilities
  • Develop and maintain DBT models, macros, and SQL scripts to transform data within Snowflake.
  • Optimize data models and design star and snowflake schemas.
  • Manage data warehouse performance and implement clustering and materialized views.
  • Create scalable ELT/ETL pipelines to ingest and transform data from multiple sources.
  • Write modular and testable SQL code using version control.
  • Manage DBT project structures and development workflows.
  • Implement data quality checks, automated testing, and anomaly detection.
  • Implement data security measures, including RBAC, data masking, and row-level access controls in Snowflake.
  • Collaborate with data engineering and analytics teams.
Required Skills
  • 5+ years of experience with DBT and hands-on DBT development.
  • 3+ years of experience with Python development.
  • 3+ years of experience with Apache Airflow.
  • 3+ years of experience with Snowflake.
  • Strong SQL development and query optimization skills.
  • Good understanding of data warehousing concepts.
  • Bachelor's degree in Computer Science, Data Engineering, or a related field.
Nice to Have
  • Experience with cloud platforms such as AWS, GCP, or Microsoft Azure.

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

DBT Engineer with Airflow & SQL
DBT Engineer with Airflow & SQL

Valiant Technologies LLC • Pennsylvania

Hybrid
USD 110,000 - 170,000
DBT Engineer with Airflow & SQL
DBT Engineer with Airflow & SQL

Robotic Process Automation LLC • Pennsylvania

Hybrid
USD 74,000 - 105,000
DBT Engineer with Airflow & SQL
DBT Engineer with Airflow & SQL

Ethereum Technologies LLC • Pennsylvania

Hybrid
USD 83,000 - 124,000
DBT Engineer with Airflow & SQL
DBT Engineer with Airflow & SQL

NTT DATA Services • King of Prussia (PA)

On-site
USD 97,000 - 145,000
Medical insurance
Dental insurance
Vision insurance
+4
DBT Engineer: Airflow, SQL & Snowflake (Hybrid)
DBT Engineer: Airflow, SQL & Snowflake (Hybrid)

Valiant Technologies LLC • Pennsylvania

Hybrid
USD 110,000 - 170,000
DBT Engineer: Airflow & SQL Data Pipeline Lead (Hybrid)
DBT Engineer: Airflow & SQL Data Pipeline Lead (Hybrid)

Robotic Process Automation LLC • Pennsylvania

Hybrid
USD 74,000 - 105,000
Senior DBT Engineer — Airflow, SQL & Snowflake Pipelines
Senior DBT Engineer — Airflow, SQL & Snowflake Pipelines

Quantum Technologies LLC • Pennsylvania

Hybrid
USD 90,000 - 103,000
Senior DBT Engineer — Airflow, SQL & Snowflake
Senior DBT Engineer — Airflow, SQL & Snowflake

NTT DATA Services • King of Prussia (PA)

On-site
USD 97,000 - 145,000
Medical insurance
Dental insurance
Vision insurance
+4
Data Engineer
Data Engineer

Robotics Technologies LLC • Raleigh (NC)

On-site
USD 120,000 - 180,000
Snowflake & dbt Data Engineer
Snowflake & dbt Data Engineer

TechDigital Group • Arizona

Hybrid
USD 90,000 - 130,000