DBT Engineer with Airflow & SQL

Valiant Technologies LLC

Pennsylvania

Hybrid

USD 110,000 - 170,000

Full time

5 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Valiant Technologies LLC in Oaks, PA (Hybrid – 3 Days Onsite per Week) seeks an experienced DBT Engineer with strong SQL, Python, Airflow, and Snowflake expertise to build scalable data transformation pipelines and ELT/ETL processes.

You will develop DBT models, optimize warehousing schemas, ensure data quality, data security, and performance while collaborating with data teams across analytics and engineering.

Qualifications

  • 5+ years of experience with DBT
  • 3+ years Python
  • 3+ years Apache Airflow
  • 3+ years Snowflake
  • Strong SQL development and data warehousing knowledge
  • Bachelor's degree in CS/Data Eng or 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 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 development
Python
Airflow
Snowflake
SQL
Data warehousing
Bachelor's degree

Education

Bachelor's degree in CS/Data Eng or related

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

Robotic Process Automation LLC • Pennsylvania

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

Quantum Technologies LLC • Pennsylvania

Hybrid
USD 90,000 - 103,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
Sr Data Engineer with Snowflake
Sr Data Engineer with Snowflake

Valiant Technologies LLC • Dallas (TX)

On-site
USD 91,000 - 124,000
Sr Data Engineer with Snowflake
Sr Data Engineer with Snowflake

Ethereum Technologies LLC • Dallas (TX)

On-site
USD 89,000 - 126,000