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?
#J-18808-Ljbffr
Sign in
To continue your applicationor continue with email
By continuing you agree to our Terms & Privacy Policy.
