Req ID: 397539
We are currently seeking a
DBT Engineer with Airflow & SQL to join our team in King Of Prussia, Pennsylvania (US-PA), United States (US).
Responsiblities:- 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
Required Qualifications- 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.
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
#LI-NorthAmericaWhenever possible, we hire locally to NTT DATA offices or client sites. This ensures we can provide timely and effective support tailored to each client's needs. While many positions offer remote or hybrid work options, these arrangements are subject to change based on client requirements. For employees near an NTT DATA office or client site, in-office attendance may be required for meetings or events, depending on business needs. At NTT DATA, we are committed to staying flexible and meeting the evolving needs of both our clients and employees. NTT DATA recruiters will never ask for payment or banking information and will only use [redacted].com, [redacted].com and [redacted].nttdataservices.com email addresses. If you are requested to provide payment or disclose banking information, please submit a contact us form, https://us.nttdata.com/en/contact-us.
NTT DATA endeavors to make https://us.nttdata.com accessible to any and all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact us at https://us.nttdata.com/en/contact-us.