Data Warehouse Intern 2026 β Centurion, Gauteng | SQL & SSIS Data Engineering Internship
Job Description
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)
Requirements
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
Boost your chances
Don't have a CV yet? Create a professional one in minutes or learn why your current one might be getting rejected.