Job Description

Listing reference:

021191

Listing status:

Online

Apply by:

3 September 2025

Position summary

Industry:

Wholesale & Retail Trade

Job category:

IT-Architecture

Location:

Cape Town

Contract:

Permanent

Remuneration:

Market Related

EE position:

Yes

Introduction

We are looking to recruit a Junior Developer to form part of the IT Data Management & Enterprise Architect Team in the Group IT department. The role will be based at Clicks Head Office in Cape Town and will report to the Technical Team Lead

Job description

Job Purpose:

To support the data analytics team by developing and maintaining Oracle SQL queries, procedures, and reports that enable data-driven decision-making across the organization. The role involves working closely with data analysts, data engineers, and business stakeholders to ensure data accuracy, accessibility, and performance.

Key Responsibilities:

Develop, test, and maintain Oracle SQL queries, views, and stored procedures. Assist in data extraction, transformation, and loading (ETL) processes. Support the creation of dashboards and reports using SQL-based data sources. Collaborate with data analysts to understand data requirements and deliver solutions. Ensure data integrity and optimize query performance. Document SQL code and maintain version control. Participate in code reviews and team knowledge-sharing sessions. Troubleshoot and resolve data-related issues.

Minimum requirements

Required Skills & Qualifications:

Bachelor's degree in Computer Science, Information Systems, or related. Good understanding of relational databases, Data Warehouse schemas (Kimbal/Star), and SQL fundamentals. Experience with Oracle SQL (PL/SQL is a plus). Familiarity with data warehousing concepts and ETL processes. Basic understanding of data visualization tools (e.g., Power BI, Tableau). Good analytical and problem-solving skills. Ability to work collaboratively in a team environment. Strong attention to detail and commitment to data quality.

Desirable Skills:

Exposure to cloud platforms (e.g., Snowflake, AWS Glue). Experience with version control systems (e.g., Git). Knowledge of Python or other scripting languages. Understanding of Agile and DevOps methodologies.

Career Development:

This role offers the opportunity to grow into a mid-level developer or data engineer role, with exposure to enterprise data architecture, advanced analytics, and cloud technologies.