We are seeking an experienced Data Architect with a strong background in Kimball dimensional modeling, enterprise data architecture, and industrial data platforms. This role focuses on designing scalable, analyticsready data models to support manufacturing and CPG data initiatives.
The ideal candidate will bring deep expertise in data warehouse design, star schema modeling, Azure cloud services, and industrial data standards, while collaborating closely with business, analytics, and governance teams.
Roles & Responsibilities:
Technical Requirements:
Strong expertise in Kimball Dimensional Modeling, Star Schema, Fact & Dimension Tables
Hands-on experience with Slowly Changing Dimensions (SCD Type 1, 2, 3)
Experience with Data Warehouse Design and Enterprise Data Modeling
Knowledge of Data Vault Modeling (plus)
Ability to define Conceptual, Logical, and Physical Data Models
Hands-on experience with Azure Data Factory (ADF)
Strong knowledge of Azure Databricks
Experience working with Azure Data Lake / ADLS
Proficiency in SQL and Python for data transformation and querying
Experience building and managing ETL/ELT pipelines
Strong understanding of ISA95, Industry 4.0, and industrial maintenance strategies
Experience working with manufacturing, industrial, or CPG data
Exposure to SAP, production and operations data, and timeseries data

Keyskills: Azure Data Factory Azure Databricks Data Architecture ETL SQL Pyspark Azure Data Lake Data Modeling Data Warehousing
Tech Mahindra is part of the US $15.4 billion Mahindra Group and is a leading global systems integrator and business transformation consulting organization, focused primarily on the telecommunications industry. Tech Mahindra helps companies innovate and transform by leveraging its unique insights, d...