COMPANY OVERVIEW
At Harbor Health , we’re transforming healthcare in Texas through collaboration and innovation. We’re seeking passionate individuals to help us create a member-centered experience that connects comprehensive care with a modern payment model.
If you’re ready to make a meaningful impact in a dynamic environment where your contributions are valued, please bring your talents to our team!
POSITION OVERVIEW
Harbor Health is rebuilding the operating system of healthcare. The HDS team contributes to this by building "HarborOS", the central nervous system of our clinical operations, tying together information from different clinical sources to drive optimal outcomes for our members. Data is our product. We are looking for Analytics Engineers to build and our data ingestion layer to bring in the data that will help us transform healthcare. You will not just move data, you will convert it into actionable insights to help our clinic network change lives. You will take raw chaos (claims, ADT, clinical data) and architect the trusted data marts that power out patient care, risk adjustment, and financial decisions.
WHAT YOU WILL DO
- Build the Semantic Layer: Design and implement production-grade dbt models that transform raw source data into clean, documented, and tested Data Marts.
- Enforce Data Quality: Move beyond basic NOT NULL checks. Implement semantic validation rules (using dbt tests or Great Expectations) that catch business logic failures before they hit the dashboard.
- Own the Pipeline: Manage the lifecycle of your data models from IDE to production, including code review, CI/CD integration, and performance tuning in Snowflake.
- Bridge the Gap: Collaborate with Platform Engineers to understand upstream ingestion patterns (Python/Fivetran) and debug data issues at the source.
- Design the core Star Schemas and data models that define our business. You will decide how we model complex concepts like "Attribution," "Risk," and "Claims Adjudication" to ensure historical accuracy and query performance.
- Act as the primary interface between Clinical Operations and Engineering. You will interview stakeholders to uncover the "Why" behind their requests and translate vague business needs into precise technical specifications.
- Mentorship & Standards: Set the standard for SQL style, dbt macro usage, and testing rigor. Mentor intermediate engineers on healthcare domain nuances (e.g., why a reversal claim behaves differently than a void).
WHAT WE NEED
- SQL Mastery: You can write performant, readable, and complex SQL. You understand window functions, CTEs, and the difference between a LEFT JOIN and a CROSS JOIN intuitively.
- dbt Fluency: You have used dbt in production. You understand incremental models, snapshots, and how to structure a project for scale.
- Pyth