Senior Data Engineer

Senior Data Engineer (contract) at Teal Health, focused on owning the data warehouse and delivering trusted, analysis-ready models through an Omni semantic layer.

Responsibilities

• Own Teal’s data warehouse, including architecture, performance, reliability, and documentation
• Manage and extend Fivetran ingestion across source systems; troubleshoot connector and schema issues
• Build and maintain a dbt transformation layer using a staging reporting approach from raw sources to business-ready models
• Support forecasting and reporting use cases across marketing, HubSpot, AWS, PostHog, and inventory
• Own the Omni data layer: define relationships, joins, and modeled fields for cross-system questions
• Partner with the analytics lead to ensure dashboards sit on accurate, consistent, and well-defined data layers
• Take on early integration work: connect new data sources and support partner data flows
• Write dbt tests and documentation to improve trust and understanding of warehouse data
• Set standards for data modeling, testing, and documentation, and help shape team growth
• Execute work from a ticketed backlog ( Jira or similar), including scoping requests and keeping priorities visible
• Handle sensitive health data in line with HIPAA and Teal’s data governance practices

Requirements

• 5+ years of experience in data engineering or analytics engineering, including ownership of a production data warehouse
• Strong SQL skills, including window functions, date logic, and complex joins across marketing, product, and operational data
• Fluency with Postgres/Redshift/Snowflake-style SQL (for example: ::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 (example provided: generate_schema_name)
  • 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 the ability to dig into each source’s raw schema details
• Working knowledge of common dbt packages such as dbt_utils and dbt_date (including surrogate keys, date spines, etc.)
• Strong habits for documentation and organized, ticket-driven execution

Technologies

• SQL
• Postgres
• Redshift
• Snowflake
• dbt-core
• Jinja
• Fivetran
• dbt_utils
• dbt_date
• Omni
• HubSpot
• PostHog
• AWS
• HIPAA
• Jira

Location

• United States (hybrid)
• Preferred: Hybrid or Full-time in Office (San Francisco)
• Open to Remote-US

Employment Type

• Contract
• ~5–20 hours per week (project volume fluctuates)

Reporting Line and Department

• Department: Engineering
• Reports to: Head of Engineering

Contract Compensation

• Expected hourly rate: $90–$125 per hour

Preferred

• 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

Ad Platforms / Data Sources Mentioned

• Google
• Meta
• TikTok
• Bing
• Reddit
• Pinterest
• Quora
• Spotify Ads