NTT

3 weeks ago

DBT Data Engineer (hybrid)

✓ Verified Job

Canonical indexed version, validated from employer's careers page.

Source: Company careers pageValidated by: Fursa AI

Last checked: 20 hours agoStatus: Live

Job Summary

Design and develop dbt transformation models that target Snowflake, using layered architectures, incremental strategies, snapshots, and dbt macros. Optimize Snowflake performance and cost, translating dimensional/ERD and legacy SQL logic into maintainable dbt-native patterns. Build dbt tests and Python-based data quality checks with strong documentation for observability. Lead peer code reviews, mentor engineers, and troubleshoot pipeline failures and query performance issues.

Location: United States

Workplace: Hybrid

Employment Type: Full time

Job Function: Software Engineering

Key Responsibilities

•Design and develop dbt transformation models targeting Snowflake using staging/intermediate/mart layering, incremental strategies, snapshot patterns, and dbt macros.
•Apply Snowflake-specific optimizations in dbt, including clustering keys, transient tables, and appropriate warehouse sizing for cost and performance.
•Translate traditional warehouse designs (dimensional models, ERDs, and legacy SQL transformation logic) into dbt-native patterns.
•Develop and maintain dbt tests and custom Python-based data quality checks, plus documentation for transformation correctness and observability.
•Perform peer code reviews, provide technical mentorship, troubleshoot data discrepancies and pipeline/query performance issues, and maintain runbooks and handover materials.

Pay and Benefits

Salary: USD 100,000 - 125,000

Perks:Health InsuranceDentalVision401kPaid LeaveLife InsuranceDisability Coverage

Key Requirements

•5+ years of DBT Core experience, including model layering, macros, Jinja templating, incremental materializations, snapshots, and dbt tests.
•3+ years of hands-on Snowflake experience as a dbt target, including SQL dialect proficiency, query optimization, clustering, and RBAC.
•3+ years of Python experience applied to data engineering, including pipeline scripting, automation, and data quality tooling.
•5+ years of SQL experience, including complex joins, window functions, CTEs, and aggregations across large datasets.

Experience:Data engineering

Skills:MentorshipPeer reviewTroubleshooting

Tech Stack:DbtSnowflakePythonSQLJinjaMacrosRBACCTEs

Company Brief

NTT

Dimension Data, operating under NTT Ltd, provides managed IT services, cloud and data center solutions, networking, cybersecurity, and digital transformation services to enterprise customers worldwide.

Industry: Professional Services

Company Size: Enterprise (1,001+ employees)

Revenue: USD 1B+

Growth: Established Company

Valuation: Public Company (Market Cap in USD)

Headquarters: London, United Kingdom

Founded: 1983

Website LinkedIn

Loading job details...

Preparing the role view and application actions.

NTT