Vacancy description
Aspire and Succeed HR
Hyderabad, भारत
Data Warehouse ArchitectLocation : HyderabadDepartment : Data & Analytics / Enterprise TechnologyShift : US shift ESTReports To : Dir, Business systemsEmployment Type : Full-TimePosition 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 https://jobeax.com/link/tlplQAnK5B36KMXq 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 https://jobeax.com/link/UtVxYPWuGnojcWz8 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 https://jobeax.com/link/btlKhyR4QwaFl8m5 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 https://jobeax.com/link/MIYiGEvGhsbM1RjK & 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 https://jobeax.com/link/BPcKjR9CGylAt2Ec & 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 https://jobeax.com/link/N9pctdfEvNv3GiNZ & 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 https://jobeax.com/link/157UJ0YGZTFgXNZ4 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 https://jobeax.com/link/uuGlZ7PGojrNovS6 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). (ref:hirist.tech)