* Data Warehousing Development: Collaborate with senior developers to design, develop, and maintain reports, dashboards, and visualisations that effectively communicate complex data insights.
* Data Analysis: Work closely with business stakeholders to understand their reporting requirements and translate them into effective data models and visualisations.
* Data Integration: Assist in integrating data from various sources into DW using appropriate Extract, Transfer and Load (ETL) processes, ensuring data quality and integrity.
* Report Optimisation: Optimise existing reports and dashboards for improved performance, usability, and user experience.
* Testing and Troubleshooting: Conduct thorough testing of DW solutions to identify and resolve any issues or bugs, ensuring accuracy and reliability of the data.
* Documentation: Document data models, report specifications, and development processes to ensure clear communication and knowledge sharing within the team.
* Collaboration: Collaborate with cross-functional teams, including business analysts, data engineers, and stakeholders, to gather requirements and ensure successful project outcomes.
* Continuous Learning: Stay up to date with the latest trends and best practices in DW development and business intelligence to enhance technical skills and contribute to ongoing process improvement.
To qualify for the role, you will have:
* Bachelor's degree in Computer Science, Information Technology, or a related field.
* Preferably with working experience and knowledge of IT, Manufacturing industries, regulations and environment.
* Strong understanding of data modelling concepts and experience working with relational databases.
* Proficiency in Data Warehousing tools, including building reports, creating dashboards, and implementing data visualisations.
* Advanced knowledge of SQL for data retrieval and manipulation.
* Familiarity with ETL processes and data integration techniques.
* Excellent analytical and problem-solving skills with a keen attention to detail.
* Strong communication and interpersonal skills, with the ability to effectively collaborate with team members and stakeholders.
* Self-motivated and eager to learn, with a passion for data analysis and visualisation.
* Ability to work in a fast-paced, deadline-driven environment and manage multiple tasks simultaneously
* Exposure to Industry standard Business Intelligence tools such as Power BI, Tableau or QlikView.
* Knowledge of data warehousing concepts and dimensional modelling.
* Familiarity with programming languages such as Python or R.
* Understanding of data security and governance practices.
* Certification in Data Warehousing and related technologies is a plus.