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

Other details

Variable Compensation: This position includes a bonus or variable payout component based on individual and organizational performance.
Actual compensation within the range will be dependent upon the individual's skills, experience, performance and internal equity.

Benefits/perks listed below may vary depending on the nature of your employment with LTIMindtree (“LTIM”):

Benefits and Perks:

• Comprehensive Medical Plan Covering Medical, Dental, Vision


• Short Term and Long-Term Disability Coverage


• 401(k) Plan with Company match


• Life Insurance


• Vacation Time, Sick Leave, Paid Holidays


• Paid Paternity and Maternity Leave

The range displayed on each job posting reflects the minimum and maximum salary target for the position across all US locations. Within the range, individual pay is determined by work location and job level and additional factors including job-related skills, experience, and relevant education or training. Depending on the position offered, other forms of compensation may be provided as part of overall compensation like an annual performance-based bonus, sales incentive pay and other forms of bonus or variable compensation.

Disclaimer: The compensation and benefits information provided herein is accurate as of the date of
this posting.

LTIMindtree is an equal opportunity employer that is committed to diversity in the workplace. Our
employment decisions are made without regard to race, color, creed, religion, sex (including
pregnancy, childbirth or related medical conditions), gender identity or expression, national origin,
ancestry, age, family-care status, veteran status, marital status, civil union status, domestic
partnership status, military service, handicap or disability or history of handicap or disability, genetic
information, atypical hereditary cellular or blood trait, union affiliation, affectional or sexual orientation
or preference, or any other characteristic protected by applicable federal, state, or local law, except
where such considerations are bona fide occupational qualifications permitted by law.