Developer II (Data Developer/Engineer)

Introduction

• We are looking to recruit a Developer II (Data Developer/Engineer) to form part of the Data Management 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 develop and support data analytics solutions, including 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 supporting the team leads throughout the development process.

Key Responsibilities:

• Design, develop, and maintain advanced Oracle SQL queries, views, and stored procedures.
• Lead and optimize data extraction, transformation, and loading (ETL) processes.
• 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.
• Contribute to data governance and best practices initiatives.

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.

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 Senior Data Engineer, with increasing responsibility in solution delivery in advanced analytics and data warehouse design and implementation.
• This progression would also see an increase in responsibility for mentoring and supporting resources withing the s.