Contract Senior Data Engineer - Data Warehouse & dbt Lead

Health Data Innovations, Inc.; San Francisco (CA); Hybrid; USD 124,000 - 172,000; Part time

Job summary

Teal Health is hiring a Senior Data Engineer to own the data warehouse and the modeled data layer used across the company for decisions. You will manage pipelines from sources like HubSpot and AWS, with dbt transformations and a semantic layer to enable reliable analytics.

You will collaborate with Analytics on dashboards, handle integrations, and set standards for data modeling, testing, and documentation, while ensuring HIPAA-aligned governance and secure access.

Qualifications

• 5+ years of experience in data engineering or analytics engineering, including owning a production data warehouse.
• Strong SQL, including window functions, date logic, and complex joins across marketing, product, and operational data.
• Fluency in Postgres/Redshift/Snowflake-style SQL and dbt-core tooling.

Responsibilities

• Own Teal’s data warehouse architecture, performance, reliability, and documentation.
• Manage and extend Fivetran ingestion across source systems and troubleshoot issues.
• Build and maintain dbt transformation layer from raw sources to business-ready models.
• Own the Omni data layer and define relationships, joins, and modeled fields for cross-system queries.
• Partner with analytics to ensure dashboards sit on accurate, well-defined data layers.
• Take on integrations and connect new data sources while supporting partner data flows.
• Write tests and documentation in dbt for trust and clarity of warehouse contents.
• Set standards for data modeling, testing, and documentation; manage ticket-driven work.

Skills

5+ years data engineering

SQL

Postgres/Redshift/Snowflake SQL

dbt-core

Fivetran

data warehouse design

Looker/LookML

Python scripting

Tools

dbt-core

Fivetran

Looker/LookML

Job description

Teal Health is hiring a Senior Data Engineer to own the data warehouse and the modeled data layer used across the company for decisions. You will manage pipelines from sources like HubSpot and AWS, with dbt transformations and a semantic layer to enable reliable analytics.

You will collaborate with Analytics on dashboards, handle integrations, and set standards for data modeling, testing, and documentation, while ensuring HIPAA-aligned governance and secure access.