Company : Coca-Cola Peninsula Beverages
Location: Cape Town, South Africa
Closing date: 11 January 2024
As part of our ongoing commitment to Continues Improvement, Coca-Cola Peninsula Beverages is offering deserving graduate the opportunity to join the company on a 12-month internship to learn about the business, gain industry exposure and helping to grow their knowledge and skills.
As a graduate you will work directly with the Business Intelligence team to bring business reporting and integration requirement to life. You will play a key role in transforming raw data into insightful to support informed decision-making within the organisation. Your role involves particating in the extract, transform and load process of different data sources, development, testing and maintianing the upkeep of business intelligence solutions.
Responsibilities:
- Extract, clean, and transform data from various sources for analysis and reporting purposes.
- Develop and implement ETL (Extract, Transform, Load) processes to ensure data accuracy and reliability.
- Use programming languages such as Python, Java, or any other to develop and maintain data engineering applications and scripts.
- Knowledge of API management
- Work with relational databases (e.g., SQL Server, MySQL, SSIS ,SSMS,SSRS) to manage and manipulate large datasets.
- Design and optimise database structures to enhance performance and efficiency (Indexing and Stored Procedures)
- Work with relational databases (e.g., SQL Server, MySQL, SQL) to manage and manipulate large datasets.
- Design and implement data models/derived views that facilitate the creation of insightful analytics and reporting.
- Design and optimize database structures to enhance performance and efficiency (Indexing and Stored Procedures)
Requirements:
- 3 year National Diploma (NQF 6) preferbaly in: Information Systems / Computer Science or IT related qualification
- Bachelor’s Degree advantageous
- Familiarity in programming languages (Java, Python, Visual Studio, C Sharp).
- Proficiency in SQL, My SQL, Data Management (VQL would be advantageous)
- Proficiency in Microsoft Office Suite
- Familiarity with PM Tools (Clickup, JIRA, Trello)
- Valid Driver’s Licence