DBT Engineer with Airflow & SQL

NTT DATA Services•Upper Merion Township, PA

1d•$96,800 - $145,200

About The Position

NTT DATA is hiring a DBT Engineer with Airflow and SQL to join its team in King of Prussia, Pennsylvania. The role develops and maintains DBT models, macros, and SQL scripts to transform data in Snowflake, and builds scalable ELT/ETL pipelines for data from diverse sources. It also focuses on designing and optimizing data models and warehouse performance, implementing data quality and security measures, and maintaining modular, testable SQL and DBT project structures using version control.

Requirements

At least 5 years of experience with DBT, including hands-on experience developing with dbt.
At least 3 years of Python development experience.
At least 3 years of Airflow development experience.
At least 3 years of experience with Snowflake.
Strong SQL proficiency.
Bachelor’s degree in Computer Science, Data Engineering, or a related field.

Nice To Haves

Good understanding of data warehouse concepts.
Experience with AWS, GCP, or Azure environments.

Responsibilities

Develop and maintain DBT models, macros, and SQL scripts to transform data within Snowflake.
Optimize data models, design star and snowflake schemas, manage warehouse performance, and implement clustering and materialized views.
Create scalable ELT/ETL pipelines to ingest and transform data from diverse sources.
Write modular, testable SQL code using version control and manage DBT project structures.
Implement data quality checks, automated tests, anomaly detection, and data security, including RBAC, masking, and row-level access in Snowflake.

Benefits

Medical insurance with employer contribution
Dental insurance with employer contribution
Vision insurance with employer contribution
Flexible spending or health savings account
Life and AD&D insurance
Short- and long-term disability coverage
Paid time off
Employee assistance
401(k) program with company match
Additional voluntary or legally required benefits
Potential eligibility for incentive compensation based on individual and/or company performance