Snowflake Architect

Snowflake Architect Location : Raleigh,North Carolina On-site "Looking for experienced Snowflake Architect with strong expertise in Data Architecture Snowflake administration Data Vault ODS modeling and dimensional data modeling The role involves designing scalable enterprise data platforms ensuring high performance governance and end-to-end data lifecycle management Key Responsibilities Data Architecture Define and lead enterprise data architecture strategies across ODS STD DWH and Data Mart layers Design end-to-end data pipelines ensuring a unified and governed data ecosystem within Snowflake  Establish standards for data ingestion transformation storage and consumption across layers Drive data modeling best practices schema evolution and data integration strategies Ensure adherence to data quality lineage governance and security frameworks Snowflake Architecture  Administration Architect and manage Snowflake environments DEV QA PROD with strong governance controls Implement RBAC security policies and access control mechanisms Optimize performance cost and scalability of Snowflake workloads Lead administration activities including monitoring tuning and capacity planning Data Modeling Design and implement Data Vault modeling ODS layer for scalable ingestion and auditability Build dimensional models Fact Dimension Star Snowflake Schema for business consumption Define data structures across standardized and curated layers for analytics Engineering  Integration Design and optimize ETLELT pipelines using SQL Snowpark and cloudnative tools Collaborate with business data and engineering teams to translate requirements into scalable data solutions Support integration with analytics reporting and downstream systems Required Skills  Expertise Strong experience in Data Architecture and Snowflake ecosystem Expertise in Snowflake Administration RBAC and performance tuning Deep knowledge of Data Vault and Dimensional Data Modeling Strong understanding of Enterprise Data Warehouse EDW architecture Expertise in SQL data pipelines and data optimization Experience in cloud platforms AWSAzure and data integration frameworks Snowflake Core especially bulk loadingeven driven task graph directory tables streams snowparkpython procedure scripting  AWS  S3 notification codebuild stepfunctions lambda  SQL Strong Secondary skills Talend ETL AWS Snowflake  Terraform Good to Have Experience with Snowpark DBT MLAI integration MLOps Exposure to largescale data modernization programs Domain experience in Insurance  Financial Services

Mandatory Skills : AWS Cloud Architecture, Data Architecture, Snowflake, Snowflake Administration, Spark SQL Good to Have Skills : AWS S3, Qlik Talend - Studio, Terraform