Data Architect

Priviahealth; United States; On-site; USD 150,000 - 200,000; Full time

Job summary

Privia Health is seeking a Data Architect to lead the technical vision, architectural strategy, and data modeling frameworks for our enterprise data platform. You will design how healthcare data—from EMRs to claims and attribution files—are structured, integrated, and governed across Privia Health.

You will champion the Snowflake ecosystem, applying Medallion Architecture with dbt, Python, and cloud infrastructure.

Qualifications

• 6+ years of progressive experience in Data Architecture, Data Engineering, or Data Platform roles.
• 3+ years of hands-on experience designing on Snowflake.
• Expertise in Medallion Architecture and modern cloud data warehouse design.
• Advanced SQL for complex modeling, schema design, and optimization.
• Experience with dbt, data pipelines, and CI/CD practices.
• Strong Python skills for data platform automation and integrations.

Responsibilities

• Define and govern data architecture on Snowflake platform.
• Design multi-layer data models (Bronze/Silver/Gold) and data vault patterns.
• Blueprint schemas for EMR/claims/attribution data in healthcare.
• Lead governance, security, and HIPAA compliance across the platform.
• Mentor engineers and drive architectural reviews and design decisions.

Skills

SQL

Data Modeling

Cloud Data Platforms

Data Governance

HIPAA Compliance

CI/CD

Tools

Snowflake

dbt

Python

Airflow

Dagster

Prefect

Fivetran

GCS/S3

Job description

We are looking for a Data Architect to lead the technical vision, architectural strategy, and data modeling frameworks for our enterprise data platform. In this role, you will define how healthcare data-spanning EMRs, medical and pharmacy claims, value-based care contracts, and payer attribution files-is structured, integrated, and governed across Privia Health.

You will act as the primary architect for our enterprise Snowflake ecosystem, driving the adoption of Medallion Architecture principles (Bronze, Silver, Gold) alongside dbt, Python, and cloud infrastructure. Working closely with Data Engineers, Analytics Leads, and Product Managers within an Agile framework, you will ensure our data platform is scalable, performant, secure, and built on architectural best practices.

Primary Job Duties

• Enterprise Architecture Strategy: Define, execute, and govern the overall data architecture roadmap on the Snowflake platform, establishing technical standards, data integration patterns, and best practices across the data organization.
• Medallion Architecture & Data Modeling: Design and standardize Privia's multi-layered data architecture (Bronze/Staging, Silver/Conformed, Gold/Marts). Establish core data modeling patterns (Kimball dimensional modeling, Data Vault, slowly changing dimensions) tailored for complex healthcare datasets.
• Healthcare Domain Integration: Blueprint schemas and integration strategies for heterogeneous healthcare data sources, including EMR systems (e.g., AthenaHealth, Epic, eClinicalWorks), historical and ongoing medical/pharmacy claims, eligibility, and Value-Based Care (VBC) attribution and quality metrics.
• Snowflake Optimization & Governance: Establish platform-level Snowflake best practices for performance tuning, warehouse sizing, cost management (finops), RBAC security models, zero-copy cloning, and time travel.
• Pipeline Frameworks & Best Practices: Partner with Data Engineers to establish standardized dbt, Python, and orchestration frameworks, ensuring that pipelines built by mid-level and senior engineers adhere to scalable design patterns, rigorous testing, and CI/CD standards.
• Data Governance, Security & HIPAA: Collaborate with Security and Compliance teams to enforce strict HIPAA compliance, PHI/PII data masking, column/row-level security, data lineage, and data cataloging standards across the ecosystem.
• Technical Leadership & Mentorship: Act as the technical authority for data initiatives. Provide architectural guidance during sprint planning, lead technical design reviews, and mentor engineers on advanced SQL, modeling, and system design.
• Cross-Functional Collaboration: Partner with Analytics, Clinical, and Product stakeholders to understand business capabilities, evaluate tradeoffs, and translate complex healthcare business requirements into scalable architectural blueprints.

• Other duties as assigned.

Experience & Qualifications

• 6+ years of progressive experience in Data Architecture, Data Engineering, or Data Platform roles, with a proven track record of designing cloud data platforms.
• 3+ years of hands-on experience designing and optimizing enterprise data solutions directly on Snowflake.
• Strong expertise in Medallion Architecture design patterns and modern cloud data warehouse design principles (Kimball, Star Schema, Data Vault, SCD types).
• Expertise in establishing best practices for dbt (data build tool) at scale, including project organization, macro design, testing frameworks, and dbt Mesh/semantic layer architecture.
• Advanced proficiency in SQL for complex data modeling, schema design, and query optimization.
• Deep experience with Python for establishing software engineering patterns in data platforms, API integrations, and automation framework design.
• Demonstrated experience with cloud infrastructure (GCP or AWS), version control (Git), and modern CI/CD data pipelines.
• Deep understanding of healthcare compliance standards (HIPAA, PHI) and implementing security frameworks (RBAC, column-level masking, data access policies) in Snowflake.
• Exceptional written and verbal communication skills with the ability to explain complex architectural tradeoffs to executive, technical, and business stakeholders.

Preferred Qualifications

• Strong domain experience in Healthcare Data, specifically working with:
• Claims Data: Professional, institutional, and pharmacy claims (837/835 formats, claim lines, grouping/grouper logic).
• EMR/EHR Systems: Clinical data extraction, HL7/FHIR formats, and clinical data standardization.
• Value-Based Care (VBC): Patient attribution/roster files, risk adjustment (HCC scores), quality measures (HEDIS, eCQMs), and shared savings models.
• Experience with cloud file storage (GCS/S3), SFTP workflows, and ingestion tooling (Fivetran, Airflow, Dagster, or Prefect).Familiarity with data observability, data quality automation (e.g., Monte Carlo, Great Expectations), and data cataloging solutions (e.g., Alation, Atlan).
• Snowflake Certified Data Architect certification.
• Bachel