Description

Design and implement enterprise data models and cloud-based ETL pipelines for industrial manufacturing domains.

This role is on-site.

Responsibilities

• Define conceptual, logical, and physical data models using Kimball dimensional modeling, star schemas, and fact/dimension tables.
• Implement Slowly Changing Dimensions (SCD Type 1, 2, 3) and manage data warehouse architecture.
• Build and maintain ETL/ELT pipelines using Azure Data Factory (ADF) and Azure Databricks.
• Develop data transformation and querying logic in SQL and Python.
• Apply ISA-95, Industry 4.0, and industrial maintenance strategies to data modeling.

Required Skills

• 5+ years of experience in data architecture and data engineering.
• Hands-on proficiency with Azure Data Factory (ADF) and Azure Databricks.
• Strong expertise in SQL and Python for data transformation.
• Deep knowledge of Kimball Dimensional Modeling, Star Schema, and Data Vault Modeling.
• Experience with Azure Data Lake Storage (ADLS) and enterprise data modeling.
• Familiarity with SAP, production/operations data, and time-series data.
• Bachelor's degree in Computer Science, Engineering, or related field.

Preferred Skills

• Direct experience with manufacturing, industrial, or CPG domain data.
• Knowledge of ISA-95 standards and Industry 4.0 frameworks.

Key Skills

Education

Bachelor's degree