Senior Developer
Listing reference: click_021192
Listing status: Closed
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.