Software Developer

Boxer Superstores; Durban; On-site; ZAR 600 000 - 800 000; Full time

Job summary

A retail company in Durban seeks a highly motivated Software Developer to focus on developing and optimizing MySQL- and SQL Server-based database systems. The ideal candidate will have over 5 years of experience with data warehousing, ETL processes, and strong Python development skills, particularly in FastAPI. Responsibilities include designing ETL pipelines and collaborating with BI teams. Competitive salary and growth opportunities available.

Qualifications

• Minimum 5 years of experience in software development focused on data warehousing and ETL.
• Strong hands-on experience with MySQL and MS SQL Server including schema design and performance tuning.
• Proven ability to implement and manage ETL pipelines with expertise in SSIS and Kestra.

Responsibilities

• Design, implement, and maintain ETL pipelines.
• Develop, optimize, and maintain SQL code for database performance.
• Build and maintain Python-based web and API services using FastAPI.

Skills

Data warehousing

ETL processes

Python API development

SQL optimization

FastAPI

SSIS

Kubernetes

Docker

Analytical modeling

Education

Degree or Diploma in IT

Tools

MySQL

Microsoft SQL Server

Power BI

Tableau

Job description

Job Description

Boxer Superstores is committed to leveraging data to drive smarter business decisions. We are looking for a highly motivated Software Developer with experience in data warehousing, ETL processes, database systems, and Python API development. This role will focus on developing and optimizing our MySQL- and SQL Server-based MPP database systems, integrating them with FastAPI-driven Python services for semantic layer technologies. The successful candidate will be part of a small, innovative team driving modernization of our data infrastructure.

Duties And Responsibilities

• Design, implement, and maintain ETL pipelines to extract, transform, and load data from multiple sources (CRM, ERP, Excel, web logs) into the data warehouse.
• Develop, optimize, and maintain SQL code for table creation, indexing, stored procedures, and query performance across MySQL and SQL Server
• Apply Kimbal star schema design principles to ensure efficient and scalable relational modeling.
• Build and maintain Python-based web and API services using FastAPI for data delivery and semantic modeling.
• Develop and maintain ETL processes using SSIS and Kestra (kestra.io).
• Collaborate with BI and analytics teams to ensure smooth integration with dashboards, reporting, and semantic layer models.
• Monitor system performance and identify opportunities for optimization and scalability.
• Stay up-to-date with emerging trends in data warehousing, ETL frameworks, database technologies, and API development.
• Experience with Kubernetes (K8s) and/or Docker for containerization and deployment (Bonus).
• js experience for analytics and data modeling.
• Experience building and supporting semantic layer models in Python.

Minimum Requirements

• Minimum 5 years of experience in software development, with a strong focus on data warehousing and ETL.
• Degree or Diploma in IT, Computer Science, Information Systems, or related field.
• Strong hands-on experience with MySQL and Microsoft SQL Server, including schema design, performance tuning, and query optimization.
• Proven ability to implement and manage ETL pipelines, with expertise in SSIS and Kestra.
• Solid understanding of Kimbal star schema and relational theory for analytical modeling.
• Demonstrable Python development experience, specifically in FastAPI for web/API development and data integration.
• Proficient in SQL, including complex queries, joins, indexing, and stored procedures.
• Understanding of data warehousing principles (subject-oriented, integrated, time-variant, non-volatile).
• Familiarity with distributed systems and parallelized processing is a plus.
• Experience working with BI tools (Power BI, Tableau, Oracle BI) for reporting and dashboard integration.
• Self‑motivated, innovative, and comfortable in a fast‑evolving technical environment.