Data Warehouse Architect

Theomnihire

Hyderabad

Presencial

INR 4 000 000 - 7 000 000

Tempo integral

Há 4 dias
Torna-te num dos primeiros candidatos

Uma candidatura completa num minuto

Currículo e carta de apresentação personalizados, prontos a enviar.

Ultrapassa os filtros ATS

Resumo da oferta

Theomnihire is seeking an experienced Data Warehouse Architect to design, build, and evolve our enterprise data platform. You will unify data across our critical domains (O2C, P2P, R2R) into a scalable, governed data warehouse with a cloud-first approach on Microsoft Fabric and AWS.

You will own data models, lead end-to-end pipelines, collaborate with ERP teams, ensure data quality and governance, mentor engineers, and empower self-service analytics for Finance, Supply Chain, and Operations.

Qualificações

  • 5–10 years of data warehousing or architecture experience.
  • Proven expertise designing enterprise data models for O2C, P2P, and/or F&R business domains.
  • Strong SQL and experience with dimensional modeling and data vault methodologies.
  • Hands-on experience with ETL/ELT tools and cloud platforms (dbt, ADF, Glue).
  • Experience integrating SAP and ERP data.

Responsabilidades

  • Design and own enterprise-grade models across O2C, P2P, and R2R.
  • Develop conceptual, logical, and physical models aligned to business processes.
  • Establish data modeling standards and governance across the org.
  • Define and manage data domains and data products for analytics.
  • Architect end-to-end data pipelines for batch and near-real-time workloads.
  • Lead data integration from ERP systems into the data warehouse.
  • Evaluate and implement ETL/ELT tools and frameworks.
  • Ensure pipeline reliability, observability, and testing practices.
  • Architect cloud-based data warehouses on Fabric and/or AWS.
  • Design lakehouse and medallion architectures (Bronze/Silver/Gold).
  • Optimize performance, cost, and security with governance.

Conhecimentos

SQL
Dimensional modeling
Data vault
ETL/ELT design
Cloud data platforms
ERP data integration
Data governance
Project leadership

Ferramentas

dbt
Azure Data Factory
AWS Glue
Apache Airflow
Redshift
S3
Lake Formation
Power BI
Microsoft Fabric
Kinesis

Descrição da oferta de emprego

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
  • 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
  • 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
  • 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
  • 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)
Obtém a tua avaliação gratuita e confidencial do currículo.

ou arrasta e larga o ficheiro aqui.

Similar jobs

Ofertas semelhantes que vale a pena comparar

Enterprise Data Architect
Enterprise Data Architect

Apptware Solutions LLP • Pune District

Presencial
INR 1 500 000 - 2 000 000
Data Platform Architect
Data Platform Architect

Waisl Ltd • Bengaluru

Presencial
INR 2 500 000 - 4 000 000
Data Architect – Data Engineering & Business Intelligence
Data Architect – Data Engineering & Business Intelligence

Applied Data Finance • Índia

Presencial
INR 2 500 000 - 4 000 000
Data Architect
Data Architect

Techdome • Hyderabad

Presencial
INR 2 500 000 - 4 200 000
Senior Data Engineer
Senior Data Engineer

Recro • Vadodara

Presencial
INR 1 200 000 - 1 600 000
Data Architect
Data Architect

Techdome • Indore District

Presencial
INR 2 500 000 - 4 500 000
Data Solution Architect
Data Solution Architect

atsMantra® • Mumbai

Presencial
INR 4 000 000 - 7 000 000
Data Solution Architect
Data Solution Architect

Netlink Software Group America, Inc. • Gurgaon

Presencial
INR 3 600 000 - 6 000 000
Senior Data Architect
Senior Data Architect

Neoware • Bengaluru, Pune

Presencial
INR 1 500 000 - 2 700 000
Data Architect (AWS, Medalliion Architecture)
Data Architect (AWS, Medalliion Architecture)

Auxo AI • Bengaluru

Presencial
INR 1 500 000 - 2 500 000