Vacancy description

Data Warehouse Architect in Hyderabad, भारत

Theomnihire

Hyderabad, भारत

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.

Requirements

Key Responsibilities

Data Architecture & Modeling

· Design and own enterprise-grade dimensional and relational data models across core business domains: Order to Cash (O2C), Procure to Pay (P2P), and Finance Record to Report (R2R)

· Develop and maintain conceptual, logical, and physical data models aligned to business process frameworks (e.g., APQC, SAP reference models)

· Establish and enforce data modeling standards, naming conventions, and architectural best practices across the organization

· Define and manage data domains, subject areas, and data products to support self-service analytics and enterprise reporting

Data Pipeline & Integration

· Architect and oversee end-to-end data pipelines — ingestion, transformation, orchestration, and delivery — for batch and near-real-time workloads

· Lead the integration of structured and semi-structured data from ERP and operational systems into the data warehouse

· Evaluate, select, and implement ETL/ELT tools and frameworks appropriate to the platform stack

· Ensure pipeline reliability, observability, and scalability through monitoring, alerting, and automated testing practices

Cloud Platform Engineering

· Architect and manage cloud-based data warehouse environments on Microsoft Fabric and/or AWS (Redshift, Glue, S3, Lake Formation, or equivalent)

· Design lakehouse and medallion architectures (Bronze / Silver / Gold) where appropriate

· Optimize platform performance, cost, and security in alignment with enterprise cloud governance standards

ERP & Source System Integration

· Lead data extraction and mapping from enterprise ERP platforms, like SAP including complex financial, procurement, and sales modules

· Integrate data from niche and industry-specific ERP platforms including Clipboard K8 and Stone Profit System

· Collaborate with ERP functional teams to understand business processes, data flows, and source-system data quality characteristics

· Document source-to-target mappings and maintain data lineage across all integrated systems

Governance & Quality

· Define and implement data governance frameworks, including data ownership, stewardship, and quality rules across integrated domains

· Partner with data governance and compliance teams to ensure data accuracy, completeness, and auditability — especially for financial reporting (R2R)

· Implement and maintain master data management (MDM) principles for key entities such as customers, vendors, and chart of accounts

Leadership & Collaboration

· Serve as the technical lead and subject matter expert for all data warehouse and data modeling initiatives

· Mentor and guide data engineers and analysts on architecture standards and best practices

· Partner with business stakeholders across Finance, Supply Chain, and Operations to translate requirements into scalable data solutions

· Engage with vendors, consultants, and third-party data providers as needed

Required Qualifications

· 5–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 modeling (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

Preferred Qualifications

· Experience with niche ERP platforms including Clipboard K8 and/or Stone Profit System

· Familiarity with Microsoft Fabric components: OneLake, Lakehouse, Data Pipelines, and Semantic Models

· AWS certifications (e.g., AWS Certified Data Analytics – Specialty) or Microsoft certifications (e.g., DP-700 Fabric Analytics Engineer)

· Experience with BI and reporting platforms such as Power BI, Tableau, or Phocas

· Background in financial close processes, revenue recognition, or supply chain operations

· Familiarity with data catalog and lineage tools (e.g., Purview, Alation, Collibra)

· Experience with real-time or streaming data architectures (Kafka, Kinesis, Event Hubs)

Similar vacancies

More like this role

... Data Warehouse and Data Platform architecture.- Strong hands-on experience with Microsoft Fabric.- Extensive experience in Azure Data Platform Services: Azure Data Factory, Azure Synapse Analytics, Azure SQL Database, Azure Data Lake Storage (ADLS), Azure DevOps.- Expertise in Enterprise Data Warehouse Design, Data Modeling, ...

Bangalore, भारत

... implement scalable data architectures using Azure services - Build and optimize ETL/ELT pipelines using Azure Databricks and Apache Spark - Architect data lake and data warehouse solutions using Azure Data Lake and Azure Synapse Analytics What you need - Azure - SQL - Python - Pandas - Databricks - Spark Good to have - Data modelling ...

Chennai, भारत

... data discrepancies between ERP and EWM (e.g., mismatched deliveries, open tasks, HU inconsistencies - Support existing interfaces between EWM and external warehouse and automation systems such as ASRS, conveyor systems What you need - SAP - Warehouse operations - SAP HANA - Agile - Reconciliation - ERP Job details - Location: ...

Hyderabad, भारत

... Assess and review the existing Enterprise Analytic Data Warehouse architecture, database structures and data integration processes.- Design and improve enterprise data models covering clinical, operational, financial and revenue-cycle information.- Define data architecture standards, database structures, data relationships and ...

भारत

Sopra Steria

Data Architect

... Ensure reuse of existing Data products 14. Promote best practices and architectural patterns for Data Products Required Skills: Technical: 1. Strong expertise in Data Modelling (CDM, LDM, PDM) [Tool, Lucid] 2. Strong expertise in Snowflake or any other Data warehouse 3. In-depth knowledge of Data Governance, Data Quality, and ...

Noida, भारत

... will architect the platform and also act as the Business Analyst for subject area(s), taking it from stakeholder interviews through to a trusted, business-ready data model. What you'll do • Architect the Fabric platform (OneLake, Lakehouse, Warehouse, medallion layers) for fast, ad-hoc analytics on large data and AI. • Build ...

Pune, भारत

Excelencia I-Tech Consulting Pvt Ltd

Data Modeler - Enterprise Data Architecture

Role Overview : The Enterprise Data Modeler / Data Architect designs and leads enterprise-scale data models that power cloud data warehouses, data lakes, and analytics platforms. This role partners closely with business stakeholders, data engineers, and analytics teams to translate business and analytical needs into scalable, ...

Chennai, भारत

... practices, unit testing, functional programming, etc.- Understanding of Medallion architecture pattern.- Has worked on at least one cloud platform.- Has worked as data architect and executed multiple end-end data engineering project.- Has extensive knowledge of different data architecture designs and data modelling concepts.- ...

Hyderabad, भारत

... role at Quest Global in Hyderabad. Needs 12+ years and a https://jobeax.com/link/2DENLGgQM7whDhaE, B.E. or B.Sc. What you'll do - Own the end-to-end solution architecture across business orchestration, warehouse execution, subsystem execution, real-time controls, UI standards, observability - Define the modular platform blueprint ...

Hyderabad, भारत

Role : Snowflake Architect - Insurance & Data VaultExperience : 10 - 15 YearsMandatory Skills : - Snowflake Architecture- Data Warehouse Design- Data Vault 2.0 (Hubs, Links, Satellites, Business Vault)- Data Modeling- ELT/Data Integration- Performance Optimization- DBT - Azure or AWS CloudMandatory Domain : - Insurance ...

भारत