Snowflake Architect

Snowflake ArchitectLocation : 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 managementKey ResponsibilitiesData ArchitectureDefine and lead enterprise data architecture strategies across ODS STD DWH and Data Mart layersDesign endtoend data pipelines ensuring a unified and governed data ecosystem within Snowflake Establish standards for data ingestion transformation storage and consumption across layersDrive data modeling best practices schema evolution and data integration strategiesEnsure adherence to data quality lineage governance and security frameworksSnowflake Architecture AdministrationArchitect and manage Snowflake environments DEV QA PROD with strong governance controls Implement RBAC security policies and access control mechanismsOptimize performance cost and scalability of Snowflake workloadsLead administration activities including monitoring tuning and capacity planningData ModelingDesign and implement Data Vault modeling ODS layer for scalable ingestion and auditabilityBuild dimensional models Fact Dimension Star Snowflake Schema for business consumptionDefine data structures across standardized and curated layers for analyticsEngineering IntegrationDesign and optimize ETLELT pipelines using SQL Snowpark and cloudnative toolsCollaborate with business data and engineering teams to translate requirements into scalable data solutionsSupport integration with analytics reporting and downstream systemsRequired Skills ExpertiseStrong experience in Data Architecture and Snowflake ecosystemExpertise in Snowflake Administration RBAC and performance tuningDeep knowledge of Data Vault and Dimensional Data ModelingStrong understanding of Enterprise Data Warehouse EDW architectureExpertise in SQL data pipelines and data optimizationExperience in cloud platforms AWSAzure and data integration frameworksSnowflake Core especially bulk loadingeven driven task graph directory tables streams snowparkpython procedure scripting AWS S3 notification codebuild stepfunctions lambda SQL StrongSecondary skills Talend ETL AWS Snowflake TerraformGood to HaveExperience with Snowpark DBT MLAI integration MLOpsExposure to largescale data modernization programsDomain experience in Insurance Financial Services