Senior Data Engineer

Insight Global (United States); San Jose (CA); Sur place; USD 96 000 - 179 000; Plein temps

Résumé du poste

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.

Responsabilités

• 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.

Connaissances

dbt Production Experience

Advanced SQL (Trino/Starburst/Snowball

Outils

dbt project structure

Git & merge-request workflows

Description du poste

Job Description

BILL's Data Enablement & Operations team owns the data warehouse that Finance, Product,Risk, GTM, and others rely on for executive reporting and planning. Our dbt project has grownto thousands of models. With that growth came deep dependency chains, redundant models,and compute cost that no one feels today. We are now running a structured model optimizationand management program to fix it.You will join as a contract engineer working through that program. Your work is scoped againstexisting models, so the correct output is known and you can prove equivalence. You will learnour systems, processes, and dbt modeling standards quickly, and you will be expected to applythem with precision.

Skills and Requirements

• 5+ years in data engineering or analytics engineering, with at least 3 years in production dbt. We expect experience refactoring existing projects, not only building new models.
• Expert SQL, ideally with Trino/Starburst, Snowflake, or a comparable engine. You should be able to read lineage and query plans and explain where and how improvements could be madeWorking knowledge of dbt project structure, incremental strategies, materializations, tests, and macros.
• Git and merge-request workflow experience
• Experience proving data equivalence before and after a change, such as with audit or diff tooling, and explaining purposeful differences.

Diversity, Inclusion, and Equal Opportunity

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal employment opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to [e-mail].