Snowflake Architect

Snowflake Architect

Location : Raleigh,North Carolina Onsite

"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 endtoend data lifecycle management

Key Responsibilities

Data Architecture

Define and lead enterprise data architecture strategies across ODS STD DWH and Data Mart layers

Design endtoend 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