Job Description
ENVIRONMENT:
A dynamic Education Specialist seeks an ambitious Junior Data Analyst/Engineer to join its team. You will design and develop ETL/ELT processes using SQL Server Integration Services (SSIS), stored procedures, and scripts while building and maintaining data warehouses and data marts. The ideal candidate must have graduated with a suitable IT Degree and have experience 1-3 years suitable work experience including Data Analyis, modelling, surfacing, Data Cleaning/Integrity Checking, creating reports utilising Excel or equivalent and have proficiency with SQL, SSIS, QlikView, Power BI & Tableau.
DUTIES:
- Design and develop ETL/ELT processes using SQL Server Integration Services (SSIS), stored procedures, and scripts.
- Build and maintain data warehouses and data marts.
- Ensure data quality and accuracy across all systems.
- Perform complex data transformations and optimizations.
- Support reporting teams with high-performance queries.
- Monitor database performance and troubleshoot issues.
- Assist in database design, modeling, and tuning.
REQUIREMENTS:
Qualifications –
- Graduate
- Relevant IT Degree.
Experience/Skills
- 1-3 Years relevant experience.
- Data Analysis, modelling and surfacing.
- Data Cleaning / Integrity Checking.
- SQL, SSIS, database scripting (stored procedures, user defined functions, queries, triggers).
- Present information using data visualization techniques (such as QlikView, Power BI and Tableau).
- Experience of creating reports using Excel or equivalent.
How to Apply
Click the green “Go Apply” button below to apply directly online with the employer.
About Other IT/Computer Jobs in Western Cape
The Western Cape, situated on the south coast of South Africa, is home to a thriving IT industry that offers a diverse range of career opportunities for professionals with expertise in various fields.
The job market in the Western Cape is highly competitive, with many major companies and startups operating in the region. The province’s strategic location, combined with its well-developed infrastructure, makes it an attractive hub for businesses looking to establish themselves in Africa. As a result, there is a high demand for skilled IT professionals who can support the growth of these companies.
The average salary ranges for IT professionals in the Western Cape are as follows: software engineers and developers can expect to earn between R800 000 to R1 200 000 per annum; data scientists and analysts can range from R600 000 to R900 000; cybersecurity specialists can earn anywhere from R500 000 to R800 000; and IT project managers can command salaries ranging from R400 000 to R700 000. These figures are based on industry standards and may vary depending on factors such as experience, qualifications, and company size.
To succeed in an IT career in the Western Cape, professionals need to possess a range of key skills, including programming languages (Java, Python, C++), data structures and algorithms, software development methodologies, cloud computing (AWS, Azure, Google Cloud), cybersecurity principles, and excellent communication skills. Additionally, knowledge of industry-specific tools and technologies, such as SAP or Oracle, can be highly valued.
Several major companies and industries are actively hiring IT professionals in the Western Cape. For example, tech giants like IBM and Dell have a strong presence in the region, while financial institutions such as Standard Bank and First National Bank also have significant IT departments. The automotive industry is another major sector that employs IT professionals, with companies like Toyota and Volkswagen having operations in the province.
Career growth opportunities are plentiful for IT professionals in the Western Cape, with many companies offering training and development programs to help employees upskill and reskill. With experience, professionals can move into senior roles such as technical lead or manager, or transition into related fields like business analysis or consulting. The region’s entrepreneurial spirit also makes it an ideal location for startups, providing opportunities for IT professionals to launch their own businesses or join innovative companies that are shaping the future of technology.
This information provides general career guidance. Actual salaries and requirements vary by employer.
GO APPLY NOW
Safe & secure application process
Explore More Opportunities
Get Similar Job Alerts
Job Seeker Tip
Set up job alerts on major job boards to be notified of new opportunities quickly.
How to Apply
Click “GO APPLY NOW” to visit the company’s application page.
Follow their instructions carefully.
JVR Jobs connects you with employers – we don’t process applications directly.
Latest Job Opportunities
Johannesburg: ORT: Direct Entry Captain (DEC/PIC) ERJ 135/145 posted by Bubesi Solutions
Matric/Grade 12.Valid Airline Transport Pilots License (ATPL) with IF Rating.Multi-crew operations qualification.Valid Radio Telephone License and LPR4 or higher.A minimum…
View JobJohannesburg: ORT: First Officer (Co-Pilot) ERJ 135/145 posted by Bubesi Solutions
Matric/Grade 12.Valid Commercial Pilots License with IF Rating.Multi-crew operations qualification.Valid Radio Telephony License and LPR4 or higher.A minimum of 1000…
View JobKempton Park: Fitter & Turner posted by Wipcorp Project Management
Qualified Fitter & Turner. Knowledge of Pneumatics, Electrical & Mechanics essential. Able to work under pressure & within a team.…
View JobEastern Cape: Tax Administrator posted by Moore Jeffreys Bay
Are you ready to embark on a rewarding and challenging career? Are you eager to work on clients in a…
View JobGauteng: Senior Account (Fully Remote)
Role Overview We are seeking an experienced Senior Accountant to join our clients remote finance team, supporting a portfolio of…
View JobJohannesburg: Senior Accountant posted by MSP Staffing LTD
Are you a registered Professional Accountant who thrives in practice? Our client with a small-mid size firm is looking for…
View Job
Browse Employers
Job Alerts