Data Warehouse Architect

Job Title:

Data Warehouse Architect

Experience:

Minimum 15 years

Location:

Hyderabad

Role Overview

We are seeking a highly experienced  Data Warehouse Architect  to lead the design, architecture, and evolution of enterprise-scale data warehousing solutions. This role will be responsible for defining end-to-end data architecture, guiding engineering teams, and partnering with business stakeholders to deliver scalable, secure, and high-performance data platforms that support analytics and decision-making.
The ideal candidate brings deep expertise in modern data warehouse architectures, cloud-based data platforms, and enterprise data integration strategies.

Key Responsibilities

• Own and define the  overall Data Warehouse and Data Platform architecture , including conceptual, logical, and physical models.

• Design, implement, and govern  enterprise data warehouse (EDW), data lake, and lakehouse architectures  to support structured and semi-structured data.

• Lead the architecture and integration of data from  SaaS, on-prem, and third-party sources , including metadata management and data lineage.

• Partner with business stakeholders, product owners, and leadership to translate business requirements into scalable data solutions and architectural blueprints.

• Establish  data modelling standards , best practices, and architectural guidelines across the organization.

• Provide technical leadership and architectural oversight to data engineering teams, including design reviews and performance optimization.

• Define and drive  ETL / ELT strategies , data ingestion patterns, and orchestration frameworks.

• Architect and oversee  cloud-based data platforms  with a strong focus on Azure (Fabric, Data Lake, Data Factory, Synapse or equivalent).

• Ensure solutions meet  security, governance, compliance, and data quality standards .

• Guide Dev Ops and CI/CD strategies for data platforms, including automation, monitoring, and cost optimization.

• Stay current with emerging data technologies and recommend improvements to the enterprise data architecture.

Note:

Responsibilities may evolve based on organizational needs and platform maturity.

Required Experience & Skills

• 15+ years of experience  in data engineering, data warehousing, and enterprise data architecture roles.

• Proven experience designing and implementing  large-scale data warehouse and analytics platforms .

• Strong expertise in  data modeling techniques  (dimensional, normalized, hybrid, and lakehouse models).

• Deep hands-on experience with  Azure data services  such as Azure Fabric, Data Lake, Data Factory, Synapse, and related analytics tools.

• Strong understanding of  ETL/ELT frameworks , metadata management, and data governance.

• Advanced proficiency in  SQL  and experience with relational and analytical databases.

• Experience working with  JSON, XML, RESTful APIs , and semi-structured data sources.

• Solid knowledge of  microservices-based architectures  and distributed data systems.

• Experience with  CI/CD pipelines , Dev Ops practices, and automated deployment for data platforms (Jenkins, Git Lab, or similar tools).

• Excellent communication skills with the ability to influence technical and non-technical stakeholders.

• Strong analytical mindset and attention to architectural detail.

Education

• Bachelor’s degree in Engineering, Computer Science, or Bachelor of Science (Master’s degree