Data Architect

Job Description:

We are seeking a highly experienced Data Architect to lead the design and implementation of enterprise scale data solutions for industrial manufacturing and Consumer Packaged Goods CPG environments

This role requires strong expertise in data modeling particularly Kimball Dimensional Modeling data warehousing and modern cloud based data platforms

Key Responsibilities:

Design and implement scalable enterprise data architectures to support business intelligence analytics and operational reporting

Lead the development of Kimball dimensional models including star schemas fact tables dimension tables and Slowly Changing Dimensions SCDs

Create and maintain conceptual logical and physical data models using industry standard data modeling tools

Collaborate with Data Analysts Data Engineers Data Governance teams and business stakeholders to translate business requirements into robust data solutions

Architect and optimize data pipelines for efficient data ingestion integration transformation and storage

Ensure data models align with enterprise data governance quality security and compliance standards

Support real time and historical analytics by designing scalable and high performance data warehouse solutions

Drive best practices in data architecture metadata management master data management MDM and data lifecycle management

Integrate data from multiple enterprise and operational systems including manufacturing engineering ERP and external platforms

Enable advanced analytics AI ML initiatives and GenAI use cases through well structured and governed data foundations

Technical Requirements:

Strong expertise in Kimball Dimensional Modeling Dimensional Data Modeling Star Snowflake Schemas Fact Dimension Tables SCD Data Warehouse Design Data Vault Modeling and Enterprise Data Modeling

Experience creating Conceptual Logical and Physical Data Models using industry standard methodologies

Hands on experience with ER Studio Erwin Data Modeler PowerDesigner or similar data modeling tools

Strong knowledge of Azure Data Factory ADF Azure Databricks Azure Data Lake Storage ADLS and Data Lakehouse Architectures

Experience designing and optimizing ETL ELT pipelines data integration solutions and data orchestration workflows

Proficiency in SQL and Python for data transformation automation and analytics

Experience integrating data using REST APIs and implementing scalable data ingestion frameworks

Preferred Skills:

Technology->Data Management->Data Architecture->Data Architecture - Data Modeling,Technology->Data Engineering->Databricks,Technology->Data Services Testing->Data Warehouse Testing->ETL tool,Technology->OpenSystem->Python - OpenSystem->Python