DBT Engineer: Airflow & SQL Data Pipeline Lead (Hybrid)

Robotic Process Automation LLC

Pennsylvania

Hybrid

USD 74,000 - 105,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

Robotic Technologies Automation in Oaks, PA, is seeking a DBT Engineer with strong SQL, Python, Apache Airflow, and Snowflake skills to design and maintain scalable ETL/ELT pipelines. You will build DBT models, implement data quality checks, and optimize data warehouses for performance while collaborating with data engineering and analytics teams.

The role requires 5+ years in DBT, 3+ years Python, Airflow, and Snowflake, and a Bachelor's in CS or data-related field.

Qualifications

  • 5+ years of experience with DBT development.
  • 3+ years of Python development.
  • 3+ years of Apache Airflow.
  • 3+ years of Snowflake experience.
  • Strong SQL and data warehousing knowledge.
  • Bachelor's degree in CS, data eng, or related field.

Responsibilities

  • Develop and maintain DBT models, macros, and SQL scripts in 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 and anomaly detection.
  • Implement data security measures, including RBAC and data masking in Snowflake.
  • Collaborate with data engineering and analytics teams.

Skills

DBT development
Python development
Apache Airflow
Snowflake
SQL development
Data warehousing concepts

Education

Bachelor's degree in Computer Science or Data Engineering

Tools

DBT
Snowflake
Airflow
Python

Job description

Robotic Technologies Automation in Oaks, PA, is seeking a DBT Engineer with strong SQL, Python, Apache Airflow, and Snowflake skills to design and maintain scalable ETL/ELT pipelines. You will build DBT models, implement data quality checks, and optimize data warehouses for performance while collaborating with data engineering and analytics teams.

The role requires 5+ years in DBT, 3+ years Python, Airflow, and Snowflake, and a Bachelor's in CS or data-related field.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

DBT Engineer: Airflow, SQL & Snowflake (Hybrid)
DBT Engineer: Airflow, SQL & Snowflake (Hybrid)

Valiant Technologies LLC • Pennsylvania

Hybrid
USD 110,000 - 170,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
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

Ethereum Technologies LLC • Pennsylvania

Hybrid
USD 83,000 - 124,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

Robotic Process Automation LLC • Pennsylvania

Hybrid
USD 74,000 - 105,000
Snowflake & dbt Data Engineer
Snowflake & dbt Data Engineer

TechDigital Group • Arizona

Hybrid
USD 90,000 - 130,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
Snowflake DBT Engineer
Snowflake DBT Engineer

Compunnel Inc. • Irvine (CA)

On-site
USD 120,000 - 150,000