Healthcare Data Architect & Manager - Harbor Data Systems (HDS)

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 a Healthcare Data Architect & Manager to lead the design of foundational data structures and ontologies that will help us transform healthcare. You will not just move data; you will define how our business understands it. You will take raw chaos (claims, ADT, disparate EMR feeds) and architect the trusted data models and master indexes that power our patient care, risk adjustment, and financial decisions. WHAT YOU WILL DO Architect the Healthcare Data Model: Design the core schemas and data models that define our business. You will decide how we model complex, systemic concepts like "Attribution," "Risk," and "Claims Adjudication" to ensure historical accuracy, scalability, and query performance. Define the Technology Standards & Strategy: Set the overarching strategy for our data stack (Snowflake, realtime streams etc) and dbt environments. You will dictate our approach to data schema, reporting schema, stream and transactional use of data. Dimensional Modeling (Kimball/Star Schema), denormalization vs. normalization, and Medallion architecture progression. Data Usability and Access: Design and implement the deterministic and probabilistic matching logic to assign unique identifiers to patients coming from highly fragmented external sources (HIEs, external EMRs, payers). Bridge Engineering and Clinical Operations: Act as the primary strategic interface between Clinical/Business Operations and Engineering. You will interview stakeholders to uncover the "Why" behind their requests and translate complex, ambiguous business needs into precise architectural specifications. Domain Leadership & Mentorship: Act as the deep subject matter expert on healthcare data for the engineering team. Mentor our engineers on healthcare domain nuances (e.g., why a reversal claim behaves differently than a void) and raise the collective technical bar for system design. Technical Ownership & Execution: Drive complex initiatives from inception to delivery. Leveraging your deep healthcare expertise, you will interpret asks from clinical & business stakeholders and work with the engineering team to design and deliver the optimal data architecture. WHAT WE NEED Healthcare “Payvider” Domain Mastery: You bring deep subject matter expertise in healthcare data domains both on provider and payer side. You are fluent in EDI, FHIR, ADT and other standards used in healthcare, and how this data is aggregated & modelled to support execution. Data Architecture Fundamentals: Proven experience designing highly scalable data platforms from scratch. You deeply understand how column-oriented databases (Snowflake) work under the hood and realtime processing and how to design schemas that optimize partition pruning and compute costs at scale. dbt & Transformation Fluency: You know how to structure a massive dbt project for enterprise scale, including macroarchitecture, incremental strategies, and dependency management while trading off quality management rigor with velocity. Technical Influence: You can deliver hands-on, writing performant, readable, and complex SQL and read/review Python pipelines, as well as influence & coach other engineers through systemic standards and architectural reviews. STRONGLY PREFERRED You bring deep subject matter expertise in healthcare data domains. You are fluent in processing 837 files, modeling the claim lifecycle (Adjudication, Reversal, Denial), and handling provider data nuances (NPI vs. TIN). Proven experience designing Dimensional Models (Kimball/Star Schema) from scratch. You know when to denormalize for performance and when to normalize for integrity . OUR STACK Transformation: dbt (Core/Cloud) Warehouse: Snowflake Ingestion: Fivetran, Python (Custom) Orchestration: Airflow / Dagster BI/Semantic Layer: Omni WHAT WE OFFER Opportunity to shape the financial foundation of an innovative healthcare model Collaborative and dynamic work environment An organization made of people who are passionate about changing the healthcare landscape Competitive salary, company equity and robust benefits package Professional development and growth opportunities A transparent and unique culture Harbor Health is an Equal Opportunity Employer. We do not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, veteran status, or any other characteristic protected by law. We are committed to creating an inclusive environment for all clinicians and teammates and actively encourage applications from people of all backgrounds.