Role - Data Clienthitect
Location -Warsaw, (Indiana, US - 100% onsite)
Job Details:
Data Clienthitect / Data Modeller (Onshore)
Role Summary: Lead the end-to-end solution Clienthitecture for the Data Mesh platform on Snowflake including data modeling, security design, RBAC/RLS, anonymization, and governance alignment.
Key Responsibilities:
" Design conceptual, logical, and physical data models for 9 source systems and 2 MVP data products
" Define Snowflake account Clienthitecture (RAW/CURATED/GOLD layers, warehouse sizing, retention policies)
" Design RBAC hierClienthy, 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 Clienture DevOps
Must-Have Skills:
" 12+ years in data Clienthitecture, with 3+ years on Snowflake (SnowPro Advanced certification preferred)
" Deep expertise in dimensional & data vault modeling
" Hands-on with Clienture Data Factory, dbt, Clienture Key Vault, Pulumi IaC
" Data Mesh principles (Domain Ownership, Data as a Product, Federated Governance)
" HIPAA / PHI / PII compliance experience (healthcare/life sciences preferred)
Good-to-Have: Erwin/ER Studio, TOGAF certification, Horizon Data Catalog, Life Sciences domain