Data Architect

Job Description:

• 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 analytics ready 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

Key Responsibilities:

• 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

Technical 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 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

Preferred Skills:

Technology->Database->Data Modeling,Technology->Data Management->Data Architecture,Foundational->Development process generic->Data Warehousing Development process