Enterprise Data Architect: Snowflake & Medallion

Privia Health; Northern (KY); Hybrid; USD 128,000 - 150,000; Full time

Job summary

Privia Health is seeking a Data Architect to lead the architectural strategy for the enterprise data platform. You will define the Snowflake architecture, medallion data modeling, and data governance while collaborating with engineers, analytics leaders, and product managers in an Agile environment.

You will guide dbt and Python-based pipelines, drive security controls for PHI/PII, and ensure scalable, compliant data solutions across healthcare datasets.

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 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.

Responsibilities

• Define, drive, and govern the enterprise data architecture roadmap on Snowflake, setting standards and best practices.
• Design and standardize multi-layered data architecture (Bronze/Silver/Gold) and core data modeling patterns.
• Blueprint schemas and integration strategies for heterogeneous healthcare data sources (EMR, claims, VBC).
• Establish Snowflake optimization, governance, and security models (RBAC, masking, time travel).
• Partner with Data Engineers to implement dbt, Python, and orchestration frameworks with CI/CD.
• Mentor engineers and communicate architectural tradeoffs to stakeholders.

Skills

SQL

Python

Data architecture

Communication

Mentorship

Cloud infrastructure

Education

Bachelor’s or Master’s degree in Computer Science or Health Informatics

Snowflake Certified Data Architect

Tools

Snowflake

dbt

Git

Airflow

Dagster

Fivetran

Job description

Privia Health is seeking a Data Architect to lead the architectural strategy for the enterprise data platform. You will define the Snowflake architecture, medallion data modeling, and data governance while collaborating with engineers, analytics leaders, and product managers in an Agile environment.

You will guide dbt and Python-based pipelines, drive security controls for PHI/PII, and ensure scalable, compliant data solutions across healthcare datasets.