Data Warehouse Architect

Tundra Technical Solutions; Hyderabad; Hybrid; INR 2,800,000 - 4,000,000; Full time

Job summary

Tundra Technical Solutions in Hyderabad is seeking a Data Warehouse Architect to design, build, and evolve an enterprise data platform. You will unify data across critical domains and implement scalable, governed warehouse solutions using modern cloud data platforms.

The role requires hands-on experience with data modeling, SQL, and building data pipelines with dbt, Azure Data Factory, AWS Glue, and Airflow, plus SAP integration and data governance practices.

Qualifications

• 10+ years of progressive experience in data warehousing, data architecture, or data engineering roles
• Proven expertise designing enterprise data models for Order to Cash, Procure to Pay, and/or Finance Record to Report business domains
• Strong proficiency in SQL and experience with dimensional modelling (Kimball, Inmon) and modern data vault methodologies
• Hands-on experience building and managing data pipelines using tools such as dbt, Azure Data Factory, AWS Glue, Apache Airflow, or similar
• Demonstrated experience with cloud data platforms, Microsoft Fabric and/or AWS (Redshift, S3, Glue, Athena, etc.)
• Meaningful experience integrating data from SAP, including financial, logistics, and procurement modules
• Solid understanding of data governance, data quality frameworks, and metadata management

Responsibilities

• Design, build, and evolve an enterprise data platform accommodating multiple business domains
• Implement scalable, governed data warehouse solutions on cloud platforms
• Lead data modeling efforts (Dimensional, Data Vault) and manage data pipelines with modern tools

Skills

Data warehousing

Data architecture

SQL

Dimensional modeling

Data vault

dbt

Azure Data Factory

AWS Glue

Airflow

Microsoft Fabric

S3

SAP integration

Data governance

Metadata mgmt

ERP data

Tools

dbt

Azure Data Factory

AWS Glue

Apache Airflow

Job description

Data Warehouse Architect

Location: Hyderabad

Department: Data & Analytics / Enterprise Technology

Shift: US shift EST

Reports To: Dir, Business Systems

Employment Type: Full-Time

Position Overview

We are seeking an experienced Data Warehouse Architect to design, build, and evolve our enterprise data platform. This role is central to unifying data across our organization's critical business domains including Order to Cash (O2C), Procure to Pay (P2P), and Finance Record to Report (R2R) into a scalable, governed, and performant data warehouse. The ideal candidate brings deep expertise in enterprise data modeling, modern cloud data platforms, and hands-on experience integrating data from both large-scale ERP systems and niche industry platforms.

Required Qualifications

• 10+ years of progressive experience in data warehousing, data architecture, or data engineering roles
• Proven expertise designing enterprise data models for Order to Cash, Procure to Pay, and/or Finance Record to Report business domains
• Strong proficiency in SQL and experience with dimensional modelling (Kimball, Inmon) and modern data vault methodologies
• Hands-on experience building and managing data pipelines using tools such as dbt, Azure Data Factory, AWS Glue, Apache Airflow, or similar
• Demonstrated experience with cloud data platforms, Microsoft Fabric and/or AWS (Redshift, S3, Glue, Athena, etc.)
• Meaningful experience integrating data from SAP, including financial, logistics, and procurement modules
• Solid understanding of data governance, data quality frameworks, and metadata management