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

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)

• No specific formal education required

• A genuine, keen interest in databases, data systems, and technology

• Basic understanding of SQL or relational database concepts is advantageous

• Familiarity with SQL Server, SSIS, or T-SQL is a strong advantage

• Strong written and verbal communication skills in English

• Ability to work independently with minimal supervision

• Proactive and self-motivated with strong personal initiative

• Detail-oriented with strong follow-through on assigned tasks

• Willingness to learn and adopt new tools and processes

• Comfortable completing structured, repetitive, and precise technical tasks