Snowflake Data Warehouse Architect

TechStar Group; Hyderabad; Hybrid; INR 3,500,000 - 7,000,000; Full time

Job summary

TechStar Group in Hyderabad seeks an experienced Data Warehouse Architect with 15+ years of IT experience and deep Snowflake expertise to lead end-to-end data warehouse design and implementation.

You will develop scalable data pipelines, implement Medallion Architecture, and optimize complex SQL queries while ensuring data governance, security, and reliability across cloud platforms.

Qualifications

• 15+ years of IT experience, with strong data warehousing background.
• Hands-on Snowflake architecture and end-to-end data warehouse design.
• Experience implementing Medallion Architecture (Bronze/Silver/Gold) and scalable ETL/ELT pipelines.

Responsibilities

• Design and implement end-to-end Snowflake Data Warehouse architecture.
• Define enterprise data warehouse strategies, architecture standards, and best practices.
• Design and implement Medallion Architecture (Bronze, Silver, Gold).
• Architect scalable ETL/ELT pipelines for batch and real-time data ingestion.
• Design data integration solutions connecting multiple sources to Snowflake.
• Develop and optimize complex SQL queries, stored procedures, and data transformation logic.
• Implement dimensional modeling: Star/Snowflake schemas; F/S dimensions.
• Optimize Snowflake performance via tuning, sizing, clustering, and cost control.
• Design scalable, cloud-based data solutions and integration frameworks.
• Ensure data governance, security, data quality, lineage and reliability.
• Collaborate with engineering/analytics/business teams to translate requirements into architecture.
• Provide technical leadership and mentor engineering teams.

Skills

Snowflake Architecture

ETL/ELT Pipelines

Medallion Architecture

Advanced SQL

Data Warehouse Design

Cloud Data Platforms

Data Governance

Python

PySpark

dbt

Snowflake Streams

Snowflake Time Travel

Zero-Copy Cloning

Tools

dbt

Informatica

Matillion

Fivetran

Job description

Job Title: Data Warehouse Architect Snowflake

Experience: 15+ Years
Primary Skill: Snowflake Data Architecture
Job Type: Full-Time

Job Summary

We are looking for an experienced Data Warehouse Architect with 15+ years of IT experience and strong expertise in Snowflake architecture, enterprise data warehousing, ETL/ELT development, and cloud-based data platforms.

The ideal candidate should have hands‑on experience designing and implementing end-to-end Snowflake data warehouse solutions, developing scalable data ingestion frameworks, implementing Medallion Architecture (Bronze, Silver, and Gold layers), and optimizing complex SQL queries.

The candidate will be responsible for defining enterprise data architecture, establishing data modelling standards, designing scalable data pipelines, and ensuring data quality, performance, security, and reliability.

Key Responsibilities

• Design and implement end-to-end Snowflake Data Warehouse architecture.


• Define enterprise data warehouse strategies, architecture standards, and best practices.


• Design and implement Medallion Architecture (Bronze, Silver, and Gold layers).


• Architect scalable ETL/ELT pipelines for batch and real‑time data ingestion.


• Design data integration solutions connecting multiple source systems to Snowflake.


• Develop and optimize complex SQL queries, stored procedures, and data transformation logic.


• Implement dimensional data modelling techniques, including Star Schema, Snowflake Schema, Fact and Dimension modelling.


• Optimize Snowflake performance through query tuning, warehouse sizing, clustering, and cost optimization.


• Design scalable cloud‑based data solutions and data integration frameworks.


• Ensure data governance, security, data quality, lineage, and data consistency.


• Collaborate with engineering, analytics, and business teams to translate requirements into technical architecture.


• Provide technical leadership, architecture guidance, and mentor engineering teams.

Mandatory Technical Skills

1. Snowflake Architecture: End-to-end Snowflake architecture, database design, virtual warehouses, storage, compute, security, and performance optimization.


2. ETL/ELT & Data Ingestion: Designing and implementing scalable data pipelines, batch and incremental data loading.


3. Medallion Architecture: Strong experience implementing Bronze, Silver, and Gold data layers.


4. Advanced SQL: Complex SQL queries, query optimization, performance tuning, stored procedures, and analytical functions.


5. Enterprise Data Warehouse Design: Enterprise-level data warehouse architecture, scalability, and data integration.


6. Dimensional Data Modelling: Star Schema, Snowflake Schema, Fact and Dimension tables, SCD Type 1 and Type 2.


7. Cloud Experience: Strong experience with cloud-based data warehouse solutions (AWS / Azure / GCP).

Preferred Skills

• Snowflake Streams, Tasks, Snowpipe, Dynamic Tables.


• Snowflake Time Travel and Zero-Copy Cloning.


• Python and PySpark.


• Data governance, metadata management, and data lineage.


• CI/CD and automated deployment of data pipelines.


• Experience with dbt, Informatica, Matillion, Fivetran, or similar ETL tools.


• Experience with large-scale enterprise data migration and modernization.

Required Experience

• 15+ years of overall IT experience.


• Strong experience in Data Warehousing and Data Architecture.


• Proven experience designing and implementing end-to-end Snowflake solutions.


• Hands‑on experience with Medallion Architecture.


• Ability to lead architecture discussions and make enterprise‑level technical decisions.