Senior Data Engineer (Contract)

The role

The Senior Data Engineer will own the data warehouse, pipelines, and the modeled data layer in Omni. This person will manage data from raw sources to analysis-ready models and partner with Analytics on dashboarding.

What you will do

• Own Teal’s data warehouse, including its architecture, performance, reliability, and documentation.
• Manage and extend Fivetran ingestion across source systems and troubleshoot issues.
• Build and maintain the dbt transformation layer.
• Own the Omni data layer by defining relationships, joins, and modeled fields.
• Partner with the analytics lead for accurate and consistent dashboards.
• Perform integrations work including connecting new data sources and supporting partner data flows.
• Write tests and documentation in dbt.
• Set standards for data modeling, testing, and documentation.
• Work from a ticketed backlog to scope requests from across the company.
• Handle sensitive health data in line with HIPAA and Teal’s data governance practices.

Required 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.
• Fluency in Postgres/Redshift/Snowflake-style SQL.
• Hands-on experience with dbt-core (models, sources, configuration, Jinja templating, custom macros, testing and docs framework).
• Experience designing and developing a data warehouse using a layered staging to reporting architecture.
• Experience working with Fivetran-landed data.
• Working knowledge of common dbt packages like dbt_utils and dbt_date.
• A habit of clear documentation and organized, ticket-driven work.

Nice to have

• Experience with Omni or a similar semantic/modeling layer (Looker, LookML, etc.)
• Python for scripting, integrations, or pipeline tooling
• Experience with healthcare or EHR integrations
• Deeper Jinja experience, including control flow and variables within dbt models
• Experience at an early-stage or fast-growing company where you owned a data function with limited support

About the company

Teal Health is on a mission to provide women with the tools, access, and resources they need to make informed decisions about their health, starting with cervical cancer screening.