Job Description

Listing reference:

021192

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 Senior 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

To support and lead the data analytics team in developing and maintaining complex Oracle SQL queries, procedures, and data pipelines that enable data-driven decision-making across the organization. This role involves working closely with data analysts, engineers, and business stakeholders to ensure data accuracy, accessibility, and performance, while also mentoring junior developers and contributing to architectural decisions
Key Responsibilities

Design, develop, and maintain advanced Oracle SQL queries, views, and stored procedures. Lead and optimize data extraction, transformation, and loading (ETL) processes. Architect and implement scalable data solutions and pipelines. Collaborate with cross-functional teams to gather and translate data requirements. Ensure data integrity, security, and performance across systems. Document technical specifications and maintain version control. Mentor junior developers and conduct code reviews. Contribute to data governance and best practices initiatives.

Minimum requirements

Required Skills & Qualifications:

Bachelor's or Master's degree in Computer Science, Information Systems, or related field. Strong understanding of relational databases, Data Warehouse schemas (Kimball/Star), and SQL fundamentals. Extensive experience with Oracle SQL and PL/SQL or T-SQL. Proficiency in data warehousing concepts and ETL processes. Experience with data visualization tools (e.g., Power BI, Tableau). Strong analytical, problem-solving, and communication skills. Proven ability to lead projects and work collaboratively in a team environment. Commitment to data quality and continuous improvement.

Desirable Skills

Experience with cloud platforms (e.g., Snowflake, AWS Glue, Azure Data Factory). Proficiency with version control systems (e.g., Git). Experience with dbt, SSIS, SAP DS or similar Knowledge of Python, R or other scripting languages. Familiarity with Agile and DevOps methodologies.

Career Development:

This role offers the opportunity to grow into a Lead Data Engineer or Data Architect position, with increasing responsibility in enterprise data strategy, cloud architecture, and advanced analytics initiatives.