Senior Data Engineer, Contract

Teal Health

. Own Teal Health’s data warehouse architecture, performance, reliability, and documentation .

Posted 10/30/2026contractSan Francisco • California • United StatesSenior💰 $90 - $125 per hourWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in data engineering with a focus on data warehouse architecture, performance, and reliability. Proficient in SQL, dbt transformations, and managing data ingestion processes while ensuring compliance with HIPAA regulations.

Highest-signal resume keywords

Data Warehouse ArchitectureStrong SQL ProficiencyDbt-Core ExperienceFivetran Data ManagementHIPAA Compliance

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

SQLDbt TransformationsData ModelingData Warehouse DesignJinja TemplatingData IngestionComplex JoinsWindow FunctionsPostgresRedshift

Soft Skills

Clear DocumentationOrganized WorkPrioritization

Tools & Technologies

FivetranDbtJiraGoogle SheetsHubSpotAWSPostHog

Industry Keywords

HealthcareEHR IntegrationsData GovernanceOmni Data LayerAnalytics

Tech Stack

Tools & technologies

Amazon RedshiftAWSPostgresPythonSnowflakeSQL

About the role

Key responsibilities & impact

Own Teal Health’s data warehouse architecture, performance, reliability, and documentation
Manage and extend Fivetran ingestion and troubleshoot connector and schema issues
Build and maintain dbt transformations using a staging → reporting pattern
Own the Omni data layer, including relationships, joins, and modeled fields
Partner with Analytics on accurate, consistent dashboards and visualizations
Connect new data sources and support partner data flows
Write dbt tests and documentation
Set standards for data modeling, testing, and documentation
Work from a ticketed Jira or similar backlog and keep priorities visible
Handle sensitive health data in accordance with HIPAA and Teal’s data governance practices

Requirements

What you’ll need

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 (::type casts, date_trunc(), and similar)
Hands-on experience with dbt-core, including models and sources, dbt_project.yml and packages.yml configuration, Jinja templating, custom macros, and dbt’s testing and docs framework
Experience designing and developing a data warehouse using a layered staging → reporting architecture
Experience working with Fivetran-landed data and source schemas including ad platforms, Google Search Console, Google Sheets, HubSpot, PostHog, AWS, and internal application databases
Working knowledge of dbt packages such as dbt_utils and dbt_date
Clear documentation and organized, ticket-driven work
Preferred: Experience with Omni or similar semantic/modeling layers, Python, healthcare or EHR integrations, deeper Jinja, and early-stage or fast-growing companies
Must be legally authorized to work in the United States without employer support or sponsorship
Must not require sponsorship to work in the United States at any time in the future