Data Architect

Job description

Educational Requirements Bachelor of Engineering, Bachelor Of Technology, Bachelor Of Science, Bachelor Of Comp. Applications Service Line Engineering Services Responsibilities - Lead the design and implementation of enterprisegrade 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 endtoend data pipelines for efficient data ingestion, transformation, and integration - Translate complex business and analytics requirements into scalable data architecture solutions - Support realtime and historical analytics use cases across industrial and CPG domains Technical and Professional Requirements: - 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 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 Preferred Skills: - Foundational->Development process generic->Data Warehousing Development process - Technology->Data Management->Data Architecture - Technology->Database->Data Modeling