- Short Term Project for 6 Months
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:2. Collaboration with Business Stakeholders3. Data Engineering Support4. Optimization and Quality Assurance5. Documentation and Support
- 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
- 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
- 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
- Conduct regular data model tuning to enhance processing and query performance
- Enforce standards for data modeling, including naming conventions, to maintain model integrity
- Maintain comprehensive documentation of data models, definitions, and data flows
- Guide and support BI developers and analysts on data structure and model utilization
Requirements
Education:
- Bachelor's or Master's degree in Computer Science, Information Technology, Data Science, or a related field
Experience:
- 2-5 years of experience in data modeling, with a strong focus on dimensional modeling for BI
Technical Skills:
- Proficiency in data modeling tools (e.g., ERwin, PowerDesigner)
- Strong SQL skills and experience with data warehousing technologies
- Familiarity with BI tools (e.g., PowerBI)
- Knowledge of the Azure Data Stack (e.g., ADLS, Azure Synapse, Azure Databricks)
- Familiarity with ERP processes, particularly the SAP stack
- Knowledge of OT Data Historians (e.g., Iba) and OT systems
- Experience with SAP BW or SAP Datasphere
- Understanding of ETL processes, tools, and data integration concepts
- Familiarity with Agile methodologies and the Atlassian Suite (JIRA, Confluence)
Soft Skills:
- Strong analytical and problem-solving abilities
- Excellent communication skills for collaboration with technical and business stakeholders
- Detail-oriented with a commitment to data quality
