Hello Group, a dynamic South African financial services and technology company, is looking for a detail-oriented and technically curious Data Warehouse Intern to join their IT team in Centurion, Gauteng.

This is a unique and highly technical internship opportunity for a self-driven individual who wants to build deep, hands-on experience in enterprise data warehousing, SQL Server Integration Services (SSIS), metadata documentation, and T-SQL stored procedure standardisation. You will work directly inside a live data warehouse environment — cataloguing, analysing, and standardising the metadata and code that powers the organisation's reporting and analytics infrastructure.

Unlike typical graduate internships, this role requires someone who is comfortable working independently on structured, detailed, and technical tasks with minimal supervision. You don't need a formal IT degree — what matters most is a genuine passion for databases and technology, strong attention to detail, and the discipline to see repetitive but mission-critical tasks through to completion.

If you are a self-starter who enjoys working methodically with data systems, SQL, and documentation — this role will give you real enterprise-level data engineering experience that stands out on any CV.

Key Responsibilities

Table Metadata Documentation — Extract Layer

Identify and document the SSIS Package Name for every table in the Extract layer
Where no SSIS package exists, identify the associated stored procedure and add it to the SSIS conversion priority list
Document the source system and original table name
Identify and record the frequency of table updates
Identify key columns used for updates (e.g. ID, Created_At, Updated_At) from sys tables
Document indexes using object IDs from sys indexes
Record the SSIS Solution and Project Name
Document the Post-SSIS Insert and Update procedure name
Identify any other procedures that reference the Extract.Schema.TableName

Table Metadata Documentation — Transform Layer

Document the stored procedure that generates each Transform layer table
Compile column lists including identification of all derived fields using sys table object IDs
Document indexes using object IDs from sys indexes
List all tables referenced to generate each Transform table
Identify any other procedures that reference the Transform.Schema.TableName

Standardisation

Review all assessed procedures for compliance with company coding standards including:
- Overall layout and PascalCase naming conventions
- Header configuration standards
- Procedure and error logging implementation
- Variable definition standards
- All standards as defined by the internal data engineering team

Performance Management

Self-manage daily workload and task prioritisation
Maintain strong time management across all assigned deliverables
Participate in regular feedback sessions with the team lead

Salary: R7,000 – R10,000 per month (Salary not specified by employer — estimated based on South African data warehouse / SQL internship market rates, 2025/2026)

Key Responsibilities

Table Metadata Documentation — Extract Layer

Identify and document the SSIS Package Name for every table in the Extract layer
Where no SSIS package exists, identify the associated stored procedure and add it to the SSIS conversion priority list
Document the source system and original table name
Identify and record the frequency of table updates
Identify key columns used for updates (e.g. ID, Created_At, Updated_At) from sys tables
Document indexes using object IDs from sys indexes
Record the SSIS Solution and Project Name
Document the Post-SSIS Insert and Update procedure name
Identify any other procedures that reference the Extract.Schema.TableName

Table Metadata Documentation — Transform Layer

Document the stored procedure that generates each Transform layer table
Compile column lists including identification of all derived fields using sys table object IDs
Document indexes using object IDs from sys indexes
List all tables referenced to generate each Transform table
Identify any other procedures that reference the Transform.Schema.TableName

Standardisation

Review all assessed procedures for compliance with company coding standards including:
- Overall layout and PascalCase naming conventions
- Header configuration standards
- Procedure and error logging implementation
- Variable definition standards
- All standards as defined by the internal data engineering team

Performance Management

Self-manage daily workload and task prioritisation
Maintain strong time management across all assigned deliverables
Participate in regular feedback sessions with the team lead

Salary: R7,000 – R10,000 per month (Salary not specified by employer — estimated based on South African data warehouse / SQL internship market rates, 2025/2026)

Data Warehouse Intern 2026 – Centurion, Gauteng | SQL & SSIS Data Engineering Internship

Job Description

Key Responsibilities

Requirements

Boost your chances

Data Warehouse Intern 2026 – Centurion, Gauteng | SQL & SSIS Data Engineering Internship

Job Description

Key Responsibilities

Requirements

Boost your chances