BI Intern - 6 Month Contract

Cape Union Mart Group; Wes-Kaap; On-site; ZAR 67,000 - 100,000; Part time

Job summary

Cape Union Mart Group seeks a curious BI Intern to join the BI team in the Western Cape. You will assist data extraction, validation, reporting and dashboard work, turning retail data into practical insights for merchandise, stores, e-commerce and finance, under experienced BI Developers and Analysts.

The role emphasizes data preparation, quality checks and supporting daily BI tasks. You will learn Oracle Retail RI OAC data environments, build SQL and data modelling skills, and shadow senior

Qualifications

• A degree or diploma (completed or in progress) in IT, Data, Statistics, Commerce, Engineering or similar.
• No formal work experience required.
• Academic or personal data projects are a plus.
• Eager to learn, take initiative and ask questions.

Responsibilities

• Extract, clean and validate data from retail, merchandise and inventory systems.
• Run data quality checks and flag anomalies or missing data.
• Escalate data issues to the right team member.
• Document business rules, metric definitions and data sources.
• Help build, test and maintain reports and dashboards.
• Prepare ad hoc analyses for business users.
• Take part in UAT for new reports and enhancements.
• Keep report documentation up to date.

Skills

SQL

Excel

Power BI

Oracle Analytics Cloud

Microsoft 365

Python

R

Data warehousing

Analytical thinking

Attention to detail

Education

Degree or Diploma (completed or in progress)

Tools

Power BI

Oracle Analytics Cloud

Microsoft Excel

Job description

We are looking for a curious, detail-oriented BI Intern to join the BI team. You will support the team with data extraction, validation, reporting and dashboard work, helping turn retail data into practical insights for merchandise, stores, e-commerce and finance. You will get hands-on exposure to an enterprise BI environment, guided by experienced BI Developers, Analysts and the BI Team Lead.

Key Responsibilities:

Data Preparation & Quality

• Help extract, clean and validate data from retail, merchandise and inventory systems
• Run data quality checks and flag anomalies or missing data
• Escalate data issues to the right team member
• Document business rules, metric definitions and data sources

Reporting & Dashboards

• Help build, test and maintain reports and dashboards
• Prepare ad hoc analyses for business users
• Take part in UAT for new reports and enhancements
• Keep report documentation up to date

Operational Support

• Support daily BI checks and scheduled report monitoring
• Assist with user queries on BI platforms
• Log and track support requests on the team board
• Help prepare training material and user guides

Learning & Development

• Learn the Oracle Retail, RI and OAC data environments
• Build SQL and data modelling skills with the team
• Shadow senior team members on BI projects

Experience & Background:

• A degree or diploma (completed or in progress). Field of study is flexible: IT, Data, Statistics, Commerce, Engineering or similar
• No formal work experience required
• Academic or personal data projects are a plus
• Eager to learn, take initiative and ask questions
• Good written and verbal communication skills

Skills:

• SQL (basic to intermediate)
• Microsoft Excel
• Power BI or Oracle Analytics Cloud, Microsoft 365
• Python or R, Data warehousing concepts
• Interest in retail
• Analytical thinking
• Attention to detail

Please note: The Cape Union Mart Group is committed to transformation. Appointments and promotions will be made based on candidates who best meet the requirements for the position. Preference will be given to candidates who will enhance the diversity of the team, aligned to our Employment Equity plan.