Role : Data Architect
- 10+ years of experience, with a strong experience in Data Architecture, Data Modeling, particularly Kimball dimensional modeling, to support our industrial data initiatives.
- The ideal candidate will play a key role in designing scalable data models, collaborating with cross-functional teams, and driving data architecture best practices across CCEP domains.
- Kimball Data Modeling, Dimensional Modeling, Star Schema, Fact and Dimension Tables, Slowly Changing Dimensions (SCD), Data Warehouse Design, Conceptual, Logical, and Physical Data Models, Enterprise Data Modeling, Data Modeling Tools (e.g., ER/Studio, Erwin, PowerDesigner)
Key Responsibilities :
- Participate in Requirement workshops/ Backlog refinement workshop to understand data requirements for the project.
- Lead the design and implementation of enterprise-grade data models, with a strong focus on Kimball dimensional modeling and star schemas to support analytics and reporting needs.
- Build and maintain conceptual, logical, and physical data models using industry-standard tools (e.g., ER/Studio, Erwin).
- Collaborate closely with Data Analysts, Data Stewards and the Data Governance team to ensure alignment of data models with business requirements and governance standards.
- Architect and optimize data pipelines, ensuring efficient data ingestion, transformation, and integration across diverse systems.
- Translate business requirements into scalable data architecture solutions that support real-time and historical analytics.
Mandatory Skills & Experience :
- 10+ years of experience in Data architecture, Data modeling and Data analysis skills.
- Proven expertise in Dimensional data modelling, Kimball modeling techniques and data warehouse design.
- Proficiency in SQL for data transformation, automation, and querying.
- Experience with ETL/ELT processes,
- Familiarity with Data lakes and Lakehouse architecture
- Familiarity with data integration tools, and data pipeline orchestration.
- Strong communication and stakeholder management skills, with the ability to work in agile teams and participate in sprint ceremonies.
- Experience with Azure Databricks, Azure Data Lake, and related cloud- solutions is desirable.
- Exposure to SAP ERP data is desirable