BI Analytics Intern — Dashboards, SQL & Data Modeling

Company : Foschini Group; Cape Town; On-site; ZAR 89,000 - 134,000; Full time

Job summary

The Foschini Group is seeking a driven Business Intelligence (Maths/Stats) YES Intern to join its IT team in Cape Town. You will gather and analyze data, document requirements, assist in data modeling, and create dashboards and reports to influence decisions.

Ideal candidates have a passion for data, exposure to SQL, and familiarity with PowerBI or Pyramid in a retail environment. This internship offers learning in data tools and methodologies within a dynamic team.

Qualifications

• Degree or Diploma in Computer Science or related fields.
• Theoretical experience in data extraction, harmonization, and structuring.
• Experience using data visualization tools (PowerBI preferred).
• Knowledge of SQL for data analysis.
• Advanced MS Office skills.
• Knowledge of Dimensional Modelling and Data Warehousing.

Responsibilities

• Gathering and documenting reporting requirements for business areas.
• Investigating data sources and querying using SQL.
• Documenting functional requirements and source-to-target mappings.
• Providing recommendations on data presentation.
• Supporting user training and data model testing.
• Creating test cases and test plans.
• Ensuring solutions meet business needs.
• Developing reports and dashboards.
• Building and maintaining stakeholder relationships.
• Keeping up with the latest data tools and methodologies.

Skills

SQL

Data analysis

Dimensional modelling

Advanced MS Office

Data extraction

Data harmonization

Education

Degree or Diploma in Computer Science

Tools

PowerBI

Pyramid

Job description

The Foschini Group is seeking a driven Business Intelligence (Maths/Stats) YES Intern to join its IT team in Cape Town. You will gather and analyze data, document requirements, assist in data modeling, and create dashboards and reports to influence decisions.

Ideal candidates have a passion for data, exposure to SQL, and familiarity with PowerBI or Pyramid in a retail environment. This internship offers learning in data tools and methodologies within a dynamic team.