Senior Data Engineer
New
T
Teal HealthHealthcare technology
Open to Remote-USContractSenior
Salary90 - 125 USD per hour
Apply NowOpens the employer's application page
Job Details
- Experience
- 5+ years of experience in data engineering or analytics engineering
- Required Skills
- SQLSnowflakePostgresRedshift
Requirements
- Have 5+ years of experience in data engineering or analytics engineering, including ownership of a production data warehouse.
- Demonstrate strong SQL skills, including window functions, date logic, and complex joins across marketing, product, and operational data.
- Be fluent in Postgres-, Redshift-, or Snowflake-style SQL.
- Have hands-on experience with dbt-core models, sources, configuration, Jinja templating, custom macros, testing, and documentation.
- Have experience designing and developing a data warehouse using a layered staging-to-reporting architecture.
- Have experience working with Fivetran-landed data and investigating source schema quirks.
- Have working knowledge of dbt packages such as dbt_utils and dbt_date.
- Maintain clear documentation and organized, ticket-driven work.
- Preferred: experience with Omni or a similar semantic/modeling layer such as Looker or LookML.
- Preferred: Python for scripting, integrations, or pipeline tooling.
- Preferred: healthcare or EHR integrations experience.
- Preferred: deeper Jinja experience, including control flow and variables in dbt models.
- Preferred: experience owning a data function at an early-stage or fast-growing company with limited support.
Responsibilities
- Own the data warehouse architecture, performance, reliability, and documentation.
- Manage and extend Fivetran ingestion across source systems and troubleshoot connector and schema issues.
- Build and maintain the dbt transformation layer from raw sources to business-ready models.
- Own the Omni data layer by defining relationships, joins, and modeled fields.
- Partner with the analytics lead to ensure dashboards use accurate, consistent, well-defined data.
- Connect new data sources and support partner data flows.
- Write dbt tests and documentation.
- Set standards for data modeling, testing, and documentation.
- Manage work from a ticketed backlog and keep priorities visible.
- Handle sensitive health data in line with HIPAA and Teal’s data governance practices.
View Full Description & ApplyYou'll be redirected to the employer's site
