Snowflake Data Architect
Employment Information
Report this job
Job expired or something wrong with this job?
Job Description
Senior Snowflake Data Architect designing Snowflake healthcare data platforms for Datavail. Leading patient identity, dimensional modeling, quality controls, and engineering delivery.
Responsibilities:
- Own Snowflake architecture and define staging, curated and conformed-layer patterns and standards
- Translate business and technical requirements into logical and physical designs for engineering delivery
- Lead dimensional and historical modeling for patient/member data, including SCD Type 2
- Design patient/member crosswalks and enterprise identity structures supporting client-validated MPI logic
- Design payer attribution, member-month and temporal models across payer/plan, provider networks, PCPs and clinics
- Define reconciliation, schema-drift, null/datatype, referential-integrity, exception and alerting controls
- Establish naming, lineage, source-to-target, testing, operational logging and runbook standards
- Protect sensitive healthcare data and support client security and compliance requirements
- Guide engineers, conduct design reviews, manage technical risks and support sprint planning and estimates
Requirements:
- 10+ years in data engineering, warehousing or analytics, including 5+ years as a data or solution architect
- Deep hands-on Snowflake architecture and advanced SQL experience
- Expert dimensional modeling: star schemas, conformed dimensions, surrogate keys and SCD Type 2
- Experience with member identity, crosswalk/entity-resolution models and client-defined matching logic
- Strong data quality, reconciliation, audit/control logging, exception handling, lineage and documentation skills
- Client-facing leadership experience
- Healthcare payer/provider and MPI experience preferred
- Ability to protect sensitive healthcare data and support client security and compliance requirements
Benefits:
- 3-month contract duration
Similar Jobs
Data Architect – VA OCDAO Data and Analytics
Data Architect designing enterprise data models, taxonomies, and metadata standards for the Department of Veterans Affairs. Leading business architecture content and aligning data governance structures.
Data Engineer – VA OCDAO Data and Analytics
Data Engineer building pipelines and integrations for the Department of Veterans Affairs OCDAO enterprise data catalog. Applying data quality and security controls remotely across the United States.
SQL Developer, Data Migration Specialist
SQL Developer and Data Migration Specialist configuring Momentive Software’s cloud platform for nonprofits and associations. Developing client solutions, supporting data conversion, testing deployments, and training users.
Junior Data Engineer – Snowflake, Oracle
Data Engineer Jr apoiando a migração de Data Warehouse Oracle para Snowflake na Keyrus, grupo internacional de dados e IA. Desenvolvendo pipelines, validando código e documentando processos.
Senior Data Architect – North America
Senior Data Architect shaping Snowflake architecture, financial data models, and integrations for a real estate investment firm. Improving governance, performance, quality, and reporting reliability.
Data Engineer, Pharmacy Data, SQL Server
Remote Data Engineer building SQL Server pharmacy data pipelines for Chiri’s AI operating platform. Ensuring reliable ingestion, quality, observability, and high availability.
Middle Data Engineer
Data Engineer owning analytics infrastructure for Boosters’ JustDone AI research assistant. Building reliable event, ETL/ELT, BigQuery, Airflow, and Milvus pipelines.
Senior Data Engineer – Square, APAC
Senior Data Engineer building scalable data pipelines and feature platforms for Binance’s global cryptocurrency ecosystem. Supporting machine learning and recommendation systems across APAC.
Senior FHIR Data Platform Engineer
Senior engineer optimizing HAPI FHIR and PostgreSQL platforms for federal healthcare modernization. Delivering quality reporting, MDM, performance, and reliable data exchange.
Data Engineer – Level III
Data Architect / Engineering Lead guiding AWS modernization, enterprise data platforms, and AI/ML enablement. Supporting AttainX’s federal NRCS technology programs under the USDA OMNI contract.
Staff Data Engineer – Databricks
Staff Data Engineer designing scalable Azure and Databricks data platforms for CVS Health’s connected healthcare services. Leading architecture, pipeline optimization, data quality, and engineering mentorship.
Short-Term Membership Data Migration Consultant
Remote consultant migrating Together for Girls’ contact data from Airtable into EveryAction CRM. Cleansing, mapping, validating and documenting sensitive records for advocacy, fundraising and reporting.
Data Engineer
Senior Data Engineer designing scalable data pipelines and high-value products. Bridging data architecture with business applications in Study Patient projects.
Data Architect
Data Architect designing scalable data models, ETL pipelines, and SQL Server environments. Supporting Corpay’s global commercial payments solutions through migrations, warehousing, and data governance.
Senior Data Engineer – Cybersecurity
Senior Data Engineer modernizing Snowflake, DBT, SQL, and Python data infrastructure. Improving pipelines and security analytics for a global cybersecurity company.
Data Engineer – Databricks, PySpark
Data Engineer building Databricks and PySpark lakehouse solutions for Sigma Software’s AdTech analytics client. Developing scalable batch and near-real-time marketing data pipelines.
Data Engineer II – Data Platform
Data Engineer II building scalable AWS, Snowflake, and dbt data platforms for First Citizens Bank. Developing reliable pipelines, data quality controls, and analytics solutions.
Senior Data Engineer, Developer
Senior Data Engineer owning Azure data pipelines, integrations, and backend development. Supporting Smart Working’s global teams with financial analysis, automation, and business visibility.
Data Platform Engineer – Clearance Required
Data Platform Engineer building Palantir Foundry, Databricks, and Power Platform solutions for LMI’s Army and federal government clients. Leading data pipelines, AI/ML integration, and technical mentorship.
CRM/Data Platform Consultant
iGaming CRM consultant shaping an advanced player data platform for a MarTech company. Advising on strategy, architecture, vendor selection, retention, and multi-brand data.