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.

Key Responsibilities :

Data Architecture & Modeling :

- Design and own enterprise-grade dimensional and relational data models across core business domains.

- 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 :

- 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).