Snowflake Data Architect

We are looking for Snowflake Data Architect for our client in Warsaw IN.

Job Title: Snowflake Data Architect

Job Location: Warsaw IN

Job Type: Contract

Job Overview:

Pay Range: $55hr - $60hr

Requirement/Must Have:

• 12+ years in data architecture, with 3+ years on Snowflake (SnowPro Advanced certification preferred).
• Deep expertise in dimensional & data vault modeling.
• Hands-on with Azure Data Factory, dbt, Azure Key Vault, Pulumi IaC.
• Data Mesh principles (Domain Ownership, Data as a Product, Federated Governance).
• HIPAA / PHI / PII compliance experience (healthcare/life sciences preferred).

Responsibilities:

• Design conceptual, logical, and physical data models for 9 source systems and 2 MVP data products.
• Define Snowflake account architecture (RAW/CURATED/GOLD layers, warehouse sizing, retention policies).
• Design RBAC hierarchy, Row-Level Security, and column masking policies (SHA-256 hashing for PHI/PII).
• Own naming standards, service user key-pair authentication, network policies, and MFA enforcement.
• Review pipeline patterns and enforce Data Mesh interoperability policies.
• Support ZB InfoSec reviews and HIPAA compliance sign-offs.
• Guide CI/CD promotion path (Dev Test Prod) via Azure DevOps.

Nice to Have:

• Erwin/ER Studio.
• TOGAF certification.
• Horizon Data Catalog.
• Life Sciences domain.

• Medical, Dental, and Vision Insurance
• 401(k) Retirement Plan
• Health Savings Account (HSA)
• Disability Insurance (Short-Term and Long-Term)
• Life and AD&D Insurance
• Paid Sick Leave (where required by applicable state or local law)
• Supplemental Insurance Plans
• Identity Theft Protection
• Pet Insurance
• Employee Wellness Programs
• Employee Assistance Program (EAP)
• Career Growth and Professional Development Opportunities