Data Architect Snowflake Medallion Architecture

Role description

Job Description Data Architect Snowflake Medallion Architecture

Orlando FL or Seattle WA Or Burbank CA Onsite any one of the location


Role Overview

We are seeking an experienced Data Architect to lead the design and implementation of enterprisescale data platforms on Snowflake with strong expertise in data modeling and medallion architecture Bronze Silver Gold layers

The role will drive endtoend data architecture governance and solution design ensuring scalable secure and businessaligned data products across domains

Key Responsibilities

1 Enterprise Data Architecture

Define and implement endtoend data architecture strategy aligned to business objectives

Design scalable secure and costefficient Snowflakebased architectures AI upskillion Status Meeting

Establish reference architecture standards and best practices for data platforms

2 Data Modeling Semantic Layer

Lead design of enterprise data models conceptual logical physical

Define dimensional models starsnowflake schema conformed dimensions and KPIs

Build and govern semantic layers for analytics BI and AI consumption

3 Medallion Architecture Ownership

Architect and define Bronze Silver and Gold layers for multiple data domains

Design data transformation frameworks STTM and reusable data products

Establish standards for

Data ingestion Bronze

Data cleansing harmonization Silver

Businessready curated datasets Gold

4 Snowflake Platform Architecture

Architect Snowflake solutions leveraging

Virtual Warehouses RBAC data sharing

Data governance and security features masking rowlevel access AI upskillion Status Meeting

Define performance scalability and cost optimization strategies

5 Data Engineering ETLELT Strategy Mandatory Tools

Define architecture for scalable ETLELT pipelines using IICS and DBT mandatory

Establish DBTbased transformation frameworks across Bronze Silver Gold layers

Design integration patterns using Informatica Intelligent Cloud Services IICS for ingestion and orchestration

Drive standardization of

Reusable pipelines

Data transformation templates

Deployment and CICD practices

6 Data Governance Security Quality

Design and implement

Enterprise data governance frameworks

Access control and approval workflows RBAC policies Data Anae Line ERR Meeting

Data lineage metadata management and data quality controls Data Anae Line ERR Meeting

Ensure compliance with data security and privacy standards

7 Stakeholder Engagement Leadership

Conduct architecture workshops requirement discovery and solution design sessions AI upskillion Status Meeting

Translate business requirements into technical architecture and implementation roadmap

Provide technical leadership and governance across multiple teams

Mentor data engineers and modelers drive architectural reviews and standards

Required Skills Experience

Core Experience

1015 years in Data Engineering Data Architecture

Proven experience designing largescale enterprise data platforms

Strong expertise in

Snowflake architecture and ecosystem

Data modeling dimensional semantic design

Medallion architecture implementation

Mandatory Technical Skills

Strong handson expertise in

Snowflake architecture performance tuning security

IICS Informatica Intelligent Cloud Services Data integration orchestration

DBT Data Build Tool Transformation across medallion layers

Proficiency in

SQL and advanced data transformations

Cloud platforms AWS Azure GCP

Nice to Have

Experience in enterprise data marketplace data product architecture

Exposure to

AIML enablement and Snowflake Cortex integrations Data Anae Line ERR Meeting

Metadata catalog tools Alation Collibra

Experience in largescale migration and modernization programs AI upskillion Status Meeting

Educational Qualification

Bachelors or Masters degree in Computer Science Data Engineering or related discipline

Preferred Profile Proposal Positioning

Experience designing domaindriven data products with medallion architecture

Strong exposure to enterprise governance models and operating frameworks

Proven leadership in multidomain multiteam delivery environments

Role Variants for proposal structuring

Senior Data Architect Snowflake DBT

Lead Data Architect Enterprise Data Platform

Principal Data Architect Solution Architect