Developer I
Listing reference: click_021191
Listing status: Under Review
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.
