Data Architect Snowflake Medallion Architecture

Mandatory Skills : Data Architecture, Snowflake

Good to Have Skills : IICS - IDMC

Role Overview

We are seeking an experienced Data Architect to lead the design and implementation of enterprise scale 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 business aligned 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 cost-efficient Snowflake based 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 star snowflake 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

Business ready curated datasets Gold

4 Snowflake Platform Architecture

Architect Snowflake solutions leveraging

Virtual Warehouses RBAC data sharing

Data governance and security features masking row level 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 DBT based 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

10-15 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 Google Cloud Platform

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 Master s degree in Computer Science Data Engineering or related discipline

Preferred Profile Proposal Positioning

Experience designing domain driven data products with medallion architecture

Strong exposure to enterprise governance models and operating frameworks

Proven leadership in multidomain multiteam delivery environments

We are an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, sexual orientation, or gender identity), national origin, citizenship status, age, disability, genetic information, protected veteran status, or any other characteristic protected by applicable law.