Data Analyst Intern (Ref: DA103) – Western Cape

Employer: Lesaka Technologies / Enterprise Analytics

Reference Code: DA103

Industry: Financial Technology, Business Intelligence, Data Science & Analytics

Location: Western Cape, South Africa (On-Site / Hybrid Office)

Position Type: Fixed-Term Internship Contract (< 6 Months)

Job Level: Junior / Graduate Entry

Target Candidates: Final-Year Diploma/Degree Students or Recent Graduates in IT, CS, or Data Science

Compensation: Market-Related Monthly Internship Stipend

Posted Date: 15 October 2026

Closing Date: 30 November 2026

About the Internship Role

A leading technology enterprise in the Western Cape is recruiting a motivated, detail-oriented Data Analyst Intern (Ref: DA103) for a fixed-term contract (under 6 months).

Working within a high-performance business intelligence team, the Data Analyst Intern will assist with SQL-based database queries, power BI and Tableau reporting dashboards, data quality reconciliations, ETL data extractions, and the documentation of analytics solutions supporting real-world business decisions.

Key Responsibilities & Analytics Workflows

The Data Analyst Intern will execute seven core technical deliverables:

1. Data Extraction, Validation & Reconciliations

• ETL Support: Assist with extracting data from relational databases and external data sources for business processing.
• Data Validation: Perform routine data quality checks, audit data integrity, and run financial/operational reconciliations.

2. Reporting & Dashboard Development

• BI Dashboards: Support the creation, enhancement, and maintenance of interactive dashboards using Power BI and Tableau.
• SQL Queries: Write and optimize basic SQL queries to retrieve datasets for reporting and ad hoc business analysis.

3. Data Warehouse & Analytics Projects

• Warehouse Testing: Participate in data warehousing, analytics projects, and user acceptance testing (UAT) for business intelligence tools.
• Documentation: Assist with documenting data dictionaries, BI reporting logic, and operational analytics procedures.

4. Business Insights & Ad Hoc Analysis

• Insight Generation: Prepare clear business insights, metric summaries, and ad hoc statistical reports as requested by business leads.

Candidate Profile & Minimum Entry Requirements

To qualify for consideration for Reference DA103, applicants must meet the following mandatory criteria:

• Educational Qualifications:
  • Currently a Final-Year Student OR Recent Graduate completing a Diploma or Degree in:
    • Computer Science
    • Information Technology / Information Systems
    • Data Science / Analytics
    • Statistics / Mathematics or similar quantitative fields (Mandatory).
• Technical Skills & Knowledge:
  • Basic practical knowledge of SQL (Structured Query Language) and relational database concepts (Mandatory).
  • Proficiency in Microsoft Excel (VLOOKUPs, Pivot Tables, basic formulas) (Mandatory).
  • Exposure or familiarity with Power BI or Tableau data visualization platforms.
• Core Competencies:
  • Strong analytical, numerical, and systematic problem-solving capabilities.
  • High attention to detail, accuracy in data entry, and willingness to learn in a team setting.

Position Benefits

• Practical BI Experience: Build your CV with real-world exposure to SQL, Power BI, Tableau, and enterprise data warehouses.
• Industry Mentorship: Direct coaching from experienced senior data analysts, BI architects, and database managers.
• Career Pathway: Opportunity to demonstrate skills and transition into junior analytics roles within the tech ecosystem.

Career Advice for Applicants

1. Highlight SQL & Excel Capabilities: Feature your SQL database queries and Excel formulas prominently on page 1 of your CV.
2. Include Capstone / Academic Projects: Detail any university or college projects involving Power BI dashboards, data cleaning, or database modeling.
3. Reference Code in Subject Line: Quote reference code DA103 clearly in your cover email or portal submission.

Sample Selection & Interview Questions

SQL & Data Visualization Logic

• Question (SQL Queries): “What SQL functions (e.g., GROUP BY, JOIN, HAVING) do you use to aggregate monthly transactional data across multiple related tables?”
• Question (Data Quality): “How do you approach identifying and cleaning duplicate or null records when preparing a raw dataset for a Power BI dashboard?”

How to Apply

Apply online directly via the official careers portal using Ref Code: DA103:

• Employer: Tech & Business Intelligence Division
• Reference Code: DA103
• Location: Western Cape, South Africa
• Position: Data Analyst Intern (< 6 Months Contract)

Apply here