Software Developer
Reference Number: BOX251111-1
Closing Date: 11 December 2011
Location: Westville, KwaZulu-Natal
Boxer Superstores is committed to leveraging data to drive smarter business decisions. Boxer Superstore is 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 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 its data infrastructure.
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.
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.
Software Developer
CLICK HERE TO APPLY
Also Check:
FOLLOW US ON FACEBOOK FOR MORE JOB POSTS
Leave a Reply