The ideal candidate will have deep expertise in dimensional modeling, data warehousing, and a solid understanding of BI reporting and analytics needs, particularly in continuous manufacturing processes.
Key Responsibilities:1. Data Modeling and Architecture
Design and implement dimensional data models aligned with the AI Manara roadmap.
Develop and maintain logical and physical data models adhering to best practices and BI requirements.
Collaborate with IT/OT teams and Data Engineers to ensure optimal data design and performance.
2. Collaboration with Business Stakeholders
Partner with stakeholders to understand reporting needs and translate them into effective data structures.
Ensure data models provide accuracy, consistency, and optimal performance for BI applications.
3. Data Engineering Support
Work with the Data Engineering team to integrate data from multiple sources into the data warehouse.
Ensure data is cleansed, transformed, and loaded into dimensional models for BI reporting.
4. Optimization and Quality Assurance
Conduct regular data model tuning to enhance processing and query performance.
Enforce standards for data modeling, including naming conventions, to maintain model integrity.
5. Documentation and Support
Maintain comprehensive documentation of data models, definitions, and data flows.
Guide and support BI developers and analysts on data structure and model utilization.
