Location: Westville, KwaZulu-Natal
Job Type: Contract
Closing Date: 11 December 2025
Department: IT
Reference: BOX251111-1
About the Role
Boxer Superstores is expanding its IT capabilities and seeking 4 skilled Software Developers to join the data engineering and integration team. This role focuses on building and optimizing MySQL and SQL Server–based MPP database systems, developing FastAPI Python services, and supporting modern semantic layer technologies. You’ll be part of a small, innovative team driving the modernization of Boxer’s data infrastructure.
Minimum Requirements
- 5+ years software development experience (data warehousing & ETL focus).
- Degree/Diploma in IT, Computer Science, Information Systems, or related field.
- Strong experience with MySQL and Microsoft SQL Server (schema design, optimization, indexing).
- Expertise in ETL development using SSIS and Kestra.
- Strong understanding of Kimball star schema and relational theory.
- Proficient in Python, especially FastAPI for API and data integration.
- Advanced SQL skills: complex joins, stored procedures, indexing, optimization.
- Knowledge of data warehousing fundamentals (subject-oriented, integrated, time-variant, non-volatile).
- Experience with BI tools (Power BI, Tableau, Oracle BI).
- Experience with distributed systems (advantage).
- Bonus: Kubernetes, Docker, semantic layer modeling, js analytics experience.
- Self-motivated, innovative, and adaptable to fast-changing environments.
Key Responsibilities
- Design and maintain ETL pipelines for multiple data sources (CRM, ERP, Excel, web logs).
- Develop and optimize SQL code for tables, indexing, stored procedures, and performance tuning.
- Apply Kimball principles for analytical data modeling.
- Build and maintain FastAPI Python services for API data delivery and semantic layers.
- Develop and support ETL processes using SSIS and Kestra.
- Collaborate with BI teams for dashboard and reporting integration.
- Monitor system performance and implement optimizations.
- Stay current with emerging trends in ETL, database systems, and Python API engineering.
- Optional bonus contributions: Kubernetes/Docker deployment, semantic layer modeling, advanced analytics.