Graduate Trainee: BI Developer

5 days ago

Parow, South Africa Peninsula Beverage Company Full time

**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

    3 weeks 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

    2 weeks 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

    2 weeks 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 days 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

    3 weeks 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...

  • Graduate Internal Audit

    3 days ago

    Parow, South Africa The Foschini Group Full time

    **Job ID**:14175**Position Type**:Full-Time**Job Function**:Graduates / Trainees**Workplace Type**:Head Office**Division**:Head Office**Province**:Western Cape**Location**:Cape Town North**Suburb**:Parow (Parow)Position Description: **GRADUATE: INTERNAL AUDITOR** **Cape Town** **Permanent** **TFG is on the hunt for a **GRADUATE INTERNAL AUDITOR** to join...

  • Administrative Trainee Opportunity

    4 days ago

    Parow, Western Cape, South Africa PPECB Full time

    Job DescriptionWe are seeking a highly motivated and detail-oriented individual to join our team as an Administrative Trainee. This is an excellent opportunity for recent graduates or those looking to gain experience in human resources.Key Responsibilities:To provide administrative support to the HR team.To assist with recruitment processes, including...

  • Software Development Graduate

    5 days ago

    Parow, South Africa The Foschini Group Full time

    **Job ID**:18491**Position Type**:Full-Time**Job Function**:Information Technology**Workplace Type**:Head Office**Division**:TFG Infotec**Province**:Western Cape**Location**:Cape Town North**Suburb**:Parow (Parow)Position Description: **Software Development Enthusiast Wanted!** Are you a recent graduate with a passion for software development? Are you ready...

  • Trainee Assistant Store Manager

    1 week ago

    Parow, South Africa New Highway ta Lewis stores Full time

    One of South Africa’s leading furniture and appliance retailers, have the following vacancy in: TRAINEE /ASSISTANT STORE MANAGER Parow Purpose of the role the Trainee Assistant store Manager is a Trainee role, the Trainee must be willing to assist as relieving manager for Parow,Bellville, Paarl,Atlantis The trainee must also be willing to spend a month...

  • Sales Trainee

    2 weeks ago

    Parow, South Africa Peninsula Beverage Company Full time

    This is a trainee position, which involves learning about the Sales Department as a whole.Stand-in for Reps and Account Developers. Assist with the coordination of promotions & events. Assist Sales department and learn about the business with the view to developing into a Sales Rep position - Perform applicable Sales function/ Repping - Market Development...

  • Sales Trainee

    3 weeks ago

    Parow, South Africa Peninsula Beverage Company Full time

    This is a trainee position, which involves learning about the Sales Department as a whole.Stand-in for Reps and Account Developers. Assist with the coordination of promotions & events. Assist Sales department and learn about the business with the view to developing into a Sales Rep position - Perform applicable Sales function/ Repping - Market Development...

  • Sales Trainee

    4 days ago

    Parow, South Africa Peninsula Beverage Company Full time

    This is a trainee position, which involves learning about the Sales Department as a whole.Stand-in for Reps and Account Developers. Assist with the coordination of promotions & events. Assist Sales department and learn about the business with the view to developing into a Sales Rep position Perform applicable Sales function/ Repping Market Development and...

  • Intern

    5 days ago

    Parow, South Africa The Foschini Group Full time

    **Job ID**:15696**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: **The incumbent’s roles and responsibilities will include, but not be limited to**: - Engage factory Planning Managers...

  • Sales Trainee On Con

    2 weeks ago

    Parow, South Africa Peninsula Beverage Company Full time

    This is a trainee position, which involves learning about the Sales Department as a whole. Stand-in for Sales Representatives and Account Developers.Assist with the coordination of promotions & events (only applicable to Touch Channel). Assist Sales department and learn about the business with the view to developing into a Sales Representative position. -...

  • Debtors Admin Intern

    6 days ago

    Parow, South Africa The Foschini Group Full time

    **Job ID**:16681**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: WEEG INTERNSHIP

  • Buyers Assistant Intern

    1 week ago

    Parow, South Africa The Foschini Group Full time

    **Job ID**:13221**Position Type**:Full-Time**Job Function**:Graduates / Trainees**Workplace Type**:Head Office**Division**:TFG Sports Division**Province**:Western Cape**Location**:Cape Town North**Suburb**:Parow (Parow)Position Description:

  • IT Graduate

    5 days ago

    Parow, South Africa The Foschini Group Full time

    **Job ID**:18488**Position Type**:Full-Time**Job Function**:Information Technology**Workplace Type**:Head Office**Division**:TFG Infotec**Province**:Western Cape**Location**:Cape Town North**Suburb**:Parow (Parow)Position Description: Are you a tech enthusiast with a passion for both Project Management and Business Analysis? If you're ready to launch your IT...

  • BI Analyst Intern

    2 weeks ago

    Parow, South Africa The Foschini Group Full time

    **Job ID**:17054**Position Type**:Full-Time**Job Function**:Information Technology**Workplace Type**: **Division**:TFG Infotec**Province**:Western Cape**Location**:Cape Town North**Suburb**:Parow (Parow)Position Description: An exciting BI Analyst Internship opportunity has become available within TFG. Imagine having the chance to develop and expand your...

  • Marketing Trainee

    4 days ago

    Parow, Western Cape, South Africa GRACE LA MARGNA ST MORITZ Full time

    We are seeking a talented and ambitious individual to join our team as a Marketing Trainee. As a pioneer for the first hotel opening in 100 years in St. Moritz, you will have the opportunity to shape the future of our luxury hospitality brand.This role is perfect for someone who is eager to learn and grow with our company. You will be responsible for...

  • Intern X2

    2 weeks ago

    Parow, South Africa The Foschini Group Full time

    **Job ID**:17585**Position Type**:Contract**Job Function**:Graduates / Trainees**Workplace Type**:Head Office**Division**:Head Office**Province**:Western Cape**Location**:Cape Town North**Suburb**:Parow (Parow)Position Description: **The opportunity**: Are you looking for an exciting career OPPORTNITY? Would you like to be part of a leading fashion lifestyle...