Junior Developer

Clicks Group Limited; Cape Town; On-site; ZAR 223,200 - 334,800; Full time

Job summary

A leading retail company in Cape Town is looking for a Junior Developer to join their IT Data Management Team. You will develop and maintain Oracle SQL queries and procedures to support data analytics, collaborating with analysts and engineers. This role offers growth into more advanced positions, providing exposure to enterprise data architecture and cloud technologies.

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, or related.
• Good understanding of relational databases and SQL fundamentals.
• Experience with Oracle SQL and familiarity with ETL processes.

Responsibilities

• Develop, test, and maintain Oracle SQL queries and procedures.
• Assist in data extraction, transformation, and loading (ETL) processes.
• Collaborate with data analysts to understand data requirements.

Skills

Oracle SQL

Problem-solving skills

Data analysis

Team collaboration

Attention to detail

Data visualization tools

Education

Bachelor’s degree in Computer Science

Tools

Power BI

Tableau

Git

Job description

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

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.
• 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.

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.

Do you require help with the registration process?