Graduate Trainee: BI Developer
7 months ago
**Overview**
Coca Cola Peninsula Beverages is an independent bottling company that manufactures and distributes products of The Coca-Cola Company within the Western and Northern Cape. We take pride in the knowledge that our company is a great place to work and that we have been recognised and certified as a Top Employer in South Africa by the Top Employers Institute.
Inspired by the motto that ‘people are valuable in direct proportion to their ability to work in harmony with other people’ and driven by a performance culture, we work hard to create a work environment in which people are number one. Fairness, Accountability, Continuous improvement and Teamwork (FACT) are the values that guide us in our efforts to achieve this.
As part of our ongoing commitment to Continues Improvement, Coca-Cola Peninsula Beverages offers one 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.
**Data Extraction and Transformation**:
- 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.
- Knowledge of API management
**Database 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)
**Data Modeling**:
- 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)
**Troubleshooting and Support**:
- Identify and resolve data-related issues in a timely manner.
- Provide support to end-users and assist with troubleshooting BI tool-related problems.
- Maintenance of BI Applications
- Monitoring of databases/queries /logs
**Collaboration**:
- Work closely with cross-functional teams to understand business requirements and translate them into technical specifications (when needed)
- Collaborate with business stakeholders to ensure alignment between business goals and BI solutions.
Skills, Experience & Education
- Minimum 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
-
Graduate BI Analyst
1 day ago
Parow, South Africa The Foschini Group Full time**Job ID**:13542**Position Type**:Full-Time**Job Function**:Graduates / Trainees**Workplace Type**:Head Office**Division**:Not Indicated**Province**:Western Cape**Location**:Cape Town North**Suburb**:Parow (Parow)Position Description: **GRADUATE BI ANALYST** **Cape Town** **Permanent** **TFG is on the hunt for a GRADUATE BI ANALYST** **to join our crew...
-
Graduate Planner
1 day ago
Parow, South Africa The Foschini Group Full time**Job ID**:13531**Position Type**:Full-Time**Job Function**:Graduates / Trainees**Workplace Type**:Head Office**Division**:Not Indicated**Province**:Western Cape**Location**:Cape Town North**Suburb**:Parow (Parow)Position Description: **GRADUATE: PLANNER** **Cape Town** **Permanent** **TFG is on the hunt for GRADUATE PLANNERS to join our crew...
-
Graduate Buyer
5 days ago
Parow, South Africa The Foschini Group Full time**Job ID**:13525**Position Type**:Full-Time**Job Function**:Graduates / Trainees**Workplace Type**:Head Office**Division**:Not Indicated**Province**:Western Cape**Location**:Cape Town North**Suburb**:Parow (Parow)Position Description: **GRADUATE: BUYERS** **Cape Town** **Permanent** **TFG is on the hunt for GRADUATE BUYERS to join our crew...
-
Graduate IT Auditor
2 weeks ago
Parow, South Africa The Foschini Group Full time**Job ID**:14176**Position Type**:Full-Time**Job Function**:Graduates / Trainees**Workplace Type**:Head Office**Division**:Not Indicated**Province**:Western Cape**Location**:Cape Town North**Suburb**:Parow (Parow)Position Description: **GRADUATE: IT AUDITOR** **Cape Town** **Permanent** **TFG is on the hunt for a GRADUATE IT Auditor. Join our crew...
-
Graduate System Administrator
1 day ago
Parow, South Africa The Foschini Group Full time**Job ID**:13541**Position Type**:Full-Time**Job Function**:Graduates / Trainees**Workplace Type**:Head Office**Division**:Not Indicated**Province**:Western Cape**Location**:Cape Town North**Suburb**:Parow (Parow)Position Description: **GRADUATE: SYSTEM ADMINISTRATOR** **Cape Town** **Permanent** **TFG is on the hunt for GRADUATE SYSTEM ADMINISTRATORS to...
-
Trainee Merchandiser
17 hours ago
Parow, South Africa The Foschini Group Full time**Job ID**:16572**Position Type**:Full-Time**Job Function**:Graduates / Trainees**Workplace Type**:Head Office**Division**:TFG Design Centre**Province**:Western Cape**Location**:Cape Town North**Suburb**:Parow (Parow)Position Description: An exciting position has arisen within the Design and Manufacturing Division, for a Trainee merchandiser for Sportscene....
-
Graduate Supply Chain Planner
1 day ago
Parow, South Africa The Foschini Group Full time**Job ID**:13521**Position Type**:Full-Time**Job Function**:Graduates / Trainees**Workplace Type**:Manufacturing Factory**Division**:Not Indicated**Province**:Western Cape**Location**:Cape Town North**Suburb**:Parow (Parow)Position Description: **GRADUATE: SUPPLY CHAIN PLANNERS** **Cape Town** **Permanent** **TFG is on the hunt for GRADUATE: SUPPLY CHAIN...
-
Graduate Buyer
7 months ago
Parow, South Africa The Foschini Group Full time**Job ID**:18579**Position Type**:Full-Time**Job Function**:Buying**Workplace Type**:Head Office**Division**:Not Indicated**Province**:Western Cape**Location**:Cape Town North**Suburb**:Parow (Parow)Position Description: TFG Wants You! Join our Squad as a Graduate Buyer within TFG Beauty. Are you a recent graduate ready to dive into the exciting world of...
-
Trainee Internal Audit
1 day ago
Parow, South Africa The Foschini Group Full time**Job ID**:10405 **Position Type**:Full-Time **Job Function**:Graduates / Trainees **Workplace Type**:Head Office **Division**:Not Indicated **Province**:Western Cape **Location**:Cape Town North **Suburb**:Parow (Parow) Position Description: - Obtaining a clear understanding of the area under audit and critically evaluating the internal controls in...
-
Merchandise Assistant Intern
17 hours ago
Parow, South Africa The Foschini Group Full time**Job ID**:17924**Position Type**:Full-Time**Job Function**:Graduates / Trainees**Workplace Type**:Head Office**Division**:Jet Division**Province**:Western Cape**Location**:Cape Town North**Suburb**:Parow (Parow)Position Description: **The opportunity**: Are you looking for an exciting career in retail? Would you like to be part of a leading fashion...
-
Talent Acquisition Specialist
17 hours ago
Parow, South Africa The Foschini Group Full time**Job ID**:16416**Position Type**:Full-Time**Job Function**:Human Resources & Training**Workplace Type**:Head Office**Division**:TFG Human Resources**Province**:Western Cape**Location**:Cape Town North**Suburb**:Parow (Parow)Position Description: **The opportunity**: The role of the **Talent Acquisition Specialist** is a key ambassador of the TFG employer...
-
Facilitator: Learning and Development
3 days ago
Parow, South Africa The Foschini Group Full time**Job ID**:13166**Position Type**:Full-Time**Job Function**:Financial Services / Analytics**Workplace Type**:Head Office**Division**:TFG Financial Services**Province**:Western Cape**Location**:Cape Town North**Suburb**:Parow (Parow)Position Description: **A challenging position exists within the Financial Services Credit Operations department for a...
-
Data Analyst
7 months ago
Parow, South Africa Peninsula Beverage Company Full timeIn this role you are responsible for the overseeing the development and support of the BI environment the Coca-Cola Peninsula Beverages as well as being a key project tea member who is assigned project tasks or change requests to be delivered on behalf of the business and providing specialised operational support to the business. To oversee the day-to-day...
-
Insurance Administrator: Intern
7 months ago
Parow, South Africa The Foschini Group Full time**Job ID**:17823**Position Type**:Full-Time**Job Function**:Graduates / Trainees**Workplace Type**:Head Office**Division**:TFG Financial Services**Province**:Western Cape**Location**:Cape Town North**Suburb**:Parow (Parow)Position Description: **INSURANCE ADMINISTRATOR: INTERN** **Job description** The role requires a driven individual with communication...
-
Operation Process Administrator: Intern
7 months ago
Parow, South Africa The Foschini Group Full time**Job ID**:17818**Position Type**:Full-Time**Job Function**:Graduates / Trainees**Workplace Type**:Head Office**Division**:The Fix**Province**:Western Cape**Location**:Cape Town North**Suburb**:Parow (Parow)Position Description: **Job description** The role requires a driven individual with analytical and communication (written and verbal) skills that will...
-
Learning and Development Business Partner
7 months ago
Parow, South Africa The Foschini Group Full time**Job ID**:17474**Position Type**:Full-Time**Job Function**:Human Resources & Training**Workplace Type**:Head Office**Division**:TFG Human Resources**Province**:Western Cape**Location**:Cape Town North**Suburb**:Parow (Parow)Position Description: **Learning and Development Business Partner** **The main purpose of this role is to act as a strategic training...
-
Data Analyst
7 months ago
Parow, South Africa The Foschini Group Full time**Job ID**:16867**Position Type**:Full-Time**Job Function**:Marketing & Communications**Workplace Type**: **Division**:TFG Customer Hub**Province**:Western Cape**Location**:Cape Town North**Suburb**:Parow (Parow)Position Description: **Data Analyst** **Parow, Cape Town** **P**ermanent** **A demanding and challenging opportunity has arisen within the...
-
Data Scientist
7 months ago
Parow, South Africa The Foschini Group Full time**Job ID**:16867**Position Type**:Full-Time**Job Function**:Marketing & Communications**Workplace Type**: **Division**:TFG Customer Hub**Province**:Western Cape**Location**:Cape Town North**Suburb**:Parow (Parow)Position Description: **Data Scientist (Analytics Specialist) - Customer and Loyalty** **Cape Town** **Permanent** **The opportunity**: A...
-
Energy Brand Activation Manager
7 months ago
Parow, South Africa Peninsula Beverage Company Full timeIn this role you will be involved in the development and execution of the annual Business Plan for Energy in CCPB. You will also be responsible for managing the relationship with the Monster Energy Company to localise plans and report on performance. In this role you will be responsible for managing the development and execution of Stills and CSD’s...
-
Pharmacist: Oncology
7 months ago
Parow, South Africa Medipost Pharmacy Full timeMedipost Pharmacy is recruiting for an experienced Pharmacist to fill the position of Oncology and Inventory Manager **Primary purpose of the job** - Forecasting and Planning of Oncology & Stock teams in accordance with predicted monthly and daily output and target requirements. - Management of Sub-Departments - **Procurement & Inventory** Ø Optimization...
