Senior Data Engineer (Contract) - dbt Optimization

Insight Global (United States); San Jose (CA); On-site; USD 96,000 - 179,000; Full time

Job summary

Insight Global is seeking a contract Data Engineer to help optimize BILL's data warehouse via a structured model program. You will refactor existing dbt models, validate equivalence, and minimize compute costs while maintaining accuracy.

This role requires strong SQL skills and a deep understanding of dbt workflows. Work will involve production-grade dbt, lineage analysis, and collaboration through Git merge-request processes.

Qualifications

• 5+ years in data or analytics engineering with production dbt experience.
• Expert SQL with Trino/Starburst or Snowflake; read lineage and query plans.
• Experience refactoring existing dbt projects and validating equivalence.
• Familiarity with dbt incremental strategies, materializations, tests, and macros.
• Git and merge-request workflow experience.
• Ability to prove data equivalence before/after changes with audit/diff tooling.

Responsibilities

• Refactor existing dbt models to optimize performance and reduce costs.
• Prove equivalence before and after changes and explain diffs.
• Analyze data lineage and query plans to identify improvements.
• Learn and apply dbt modeling standards with precision.

Skills

dbt Production Experience

Advanced SQL (Trino/Starburst/Snowball

Tools

dbt project structure

Git & merge-request workflows

Job description

Insight Global is seeking a contract Data Engineer to help optimize BILL's data warehouse via a structured model program. You will refactor existing dbt models, validate equivalence, and minimize compute costs while maintaining accuracy.

This role requires strong SQL skills and a deep understanding of dbt workflows. Work will involve production-grade dbt, lineage analysis, and collaboration through Git merge-request processes.