DBT Engineer with Airflow & SQL

NTT DATA Corporation
King of Prussia, PA, United States
7 days ago
Apply on careers-inc.nttdata.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Experienced
Experience required
3 years minimum
Compensation
$96,800 - $145,200
Working hours
Regular working hours

Tech stack

Airflow Amazon Web Services Automation of Tests Microsoft Azure Cloud Computing Data Validation Information Engineering Extract Transform Load (ETL) Data Security Data Warehousing Python (Programming Language) Role-Based Access Control
+5 more
Standard Sql SQL Databases Snowflake Information Technology Software Version Control

Job description

  • Develop and maintain DBT models, macros, and SQL scripts to transform data within Snowflake.
  • Optimize data models, design star/snowflake schemas, manage warehouse performance, and implement clustering/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

Requirements

  • 5+ years of experience with DBT and Hands-on experience developing with dbt.
  • 3+ years of experience with Python development
  • 3+ years of experience with Airflow development3+ years of experience with Snowflake and Strong SQL proficiency.

Education:

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

Preferred Qualifications

Good handle on Datawarehouse concepts. Cloud Platforms: Experience with AWS, GCP, or Azure environments.

Benefits & conditions

NTT DATA provides a reasonable range of compensation for U.S.-based positions. The starting pay range for this role is $96,800.00 to $145,200.00. This range reflects the minimum and maximum target compensation for the position across all US locations. Actual compensation will depend on a number of factors, including the candidate’s actual work location, relevant experience, technical skills, and other qualifications. This position may also be eligible for incentive compensation based on individual and/or company performance. This position is eligible for company benefits including medical, dental, and vision insurance with an employer contribution, flexible spending or health savings account, life and AD&D insurance, short and long term disability coverage, paid time off, employee assistance, participation in a 401k program with company match, and additional voluntary or legally required benefits

About the company

NTT DATA is a $30 billion business and technology services leader, serving 75% of the Fortune Global 100. We are committed to accelerating client success and positively impacting society through responsible innovation. We are one of the world’s leading AI and digital infrastructure providers, with unmatched capabilities in enterprise-scale AI, cloud, security, connectivity, data centers and application services. our consulting and Industry solutions help organizations and society move confidently and sustainably into the digital future. As a Global Top Employer, we have experts in more than 50 countries. We also offer clients access to a robust ecosystem of innovation centers as well as established and start-up partners. NTT DATA is a part of NTT Group, which invests over $3 billion each year in R&D.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on careers-inc.nttdata.com
Prepare application

Good distractions

Loading talks and stories from around this role…