Data Engineer Sr (DBT)

NTT DATA, Inc.; Indianapolis (IN); On-site; USD 140,000 - 180,000; Full time

Job summary

NTT DATA, Inc. is seeking a senior DBT/ETL engineer to design and implement multi-layer dbt architectures, partner with Snowflake developers, and ensure alignment with legacy Informatica outputs. You will lead testing, documentation, and performance tuning across the data stack.

The role requires extensive experience in DBT development, conformed dimensional modeling, and strong collaboration across teams to deliver reliable data assets and scalable pipelines.

Qualifications

• 10+ years in modern ELT/transformation engineering.
• DBT project standards, modular design, testing frameworks, docs.
• Lead conformed Silver layer models across Policy, Claims, Billing.

Responsibilities

• Design and implement staging, core, and mart dbt layers using standard patterns.
• Develop and maintain dbt tests (schema, data, custom) for quality.
• Implement snapshots, seeds, macros, and reusable components.
• Collaborate with Snowflake developers to optimize data structures.
• Ensure legacy Informatica outputs align with new dbt outputs.
• Performance tune dbt models and Snowflake queries.
• Integrate dbt with CI/CD pipelines (Azure DevOps, GitHub Actions).
• Contribute to documentation of dbt models, data lineage, and business rules.
• Participate in defect analysis, fixes, and enhancements during migration.

Skills

dbt

ELT/ETL

Snowflake

data modeling

CI/CD

Education

Bachelor's degree in CS or related field

Tools

GitHub Actions

Azure DevOps

Delta Lake

Job description

Roles & Responsibilities

• Design and implement staging, core, and mart layers using standard dbt patterns and folder structures.
• Develop and maintain dbt tests (schema tests, data tests, custom tests) to ensure data quality and integrity.
• Implement snapshots, seeds, macros, and reusable components where appropriate.
• Collaborate with Snowflake developers to ensure physical data structures support dbt models efficiently.
• Work with functional teams to ensure functional equivalence between legacy Informatica outputs and new dbt outputs.
• Participate in performance tuning of dbt models and Snowflake queries.
• Integrate dbt with CI/CD pipelines (e.g., Azure DevOps, GitHub Actions) for automated runs and validations.
• Contribute to documentation of dbt models, data lineage, and business rules.
• Participate in defect analysis, bug fixes, and enhancements during migration and stabilization phases.

Experience :

• 10+ years in modern ELT / transformation engineering, with strong expertise in DBT-based development for curated enterprise data layers.
• Experience defining DBT project standards, modular model design, testing frameworks, documentation, macros, environment strategy, and deployment controls.
• Proven ability to lead development of conformed Silver layer models across Policy, Claims, Billing, and shared dimensions / reference domains.
• Strong experience integrating DBT with Databricks / Delta Lake, orchestration tools, version control, and automated quality checks.
• Able to guide developer productivity, code review standards, reusability, performance tuning, and traceability from mapping to model implementation.