Data Architect - Enterprise Data Modeling & Cloud Data Engineering

Data Architect

Core Data Architecture & Modeling Skills: 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 Cloud & Data Engineering Technologies: 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 Industrial & Domain Expertise: Strong understanding of ISA‑95, Industry 4.0, and industrial maintenance strategies Experience working with manufacturing, industrial, or CPG data Exposure to SAP, production and operations data, and time‑series data Lead the design and implementation of enterprise‑grade data models, with a strong focus on Kimball dimensional modeling and star schemas Develop and maintain conceptual, logical, and physical data models aligned with business and analytics needs Collaborate with Data Analysts, Business Stakeholders, and Data Governance teams to ensure model accuracy and compliance Architect and optimize end‑to‑end data pipelines for efficient data ingestion, transformation, and integration Translate complex business and analytics requirements into scalable data architecture solutions Support real‑time and historical analytics use cases across industrial and CPG domains