Software Developer

Job DescriptionBoxer 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 ResponsibilitiesDesign, 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 ServerApply 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 RequirementsMinimum 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.