BI Intern - 6 Month Contract

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.