Software Developer

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.