Developer II | Retail IT | BI

Job Summary

Join the Retail IT Data Platform and Warehousing Development team in modernising and evolving both our Microsoft SQL Server-based data warehouse and Snowflake-based analytical platform. The role contributes to the development, support, and evolution of data products and operational processes across both environments, while helping establish modern DataOps practices.

Job Responsibilities

 Design, develop, and maintain data pipelines and data products using Snowflake, Microsoft SQL Server and MSSQL Data tools (SSIS, SSRS, SSAS), Python, and Dagster.

 Develop and optimize ELT workloads, stored procedures, data models, and transformation logic to support analytical and operational reporting requirements.

 Build and maintain Dagster assets, schedules, sensors, and orchestration workflows to ensure reliable and observable data processing.

 Design and implement data models for both operational and analytical use cases, applying appropriate warehousing and dimensional modelling techniques.

 Troubleshoot and resolve data quality, pipeline, orchestration, and platform issues across Snowflake and SQL Server environments.

 Analyze and optimize query performance, pipeline execution, warehouse utilization, and storage strategies.

 Develop automated testing, reconciliation, and data validation mechanisms to improve platform reliability and data quality.

 Contribute to CI/CD pipelines, deployment automation, source control standards, and engineering best practices.

 Implement monitoring, alerting, observability, and operational controls to improve platform availability and supportability.

 Collaborate with architects and senior engineers to modernize legacy ETL processes and evolve the team's data platform architecture.

 Conduct code reviews and contribute to technical design discussions, ensuring solutions align with team standards, security requirements, and architectural principles.

 Create and maintain technical documentation, platform runbooks, operational procedures, and support artefacts.

 Investigate emerging technologies and contribute to technical spikes and proof-of-concepts that improve platform capabilities.

 Provide production support for critical data platforms, participating in incident diagnosis, root-cause analysis, and resolution activities

Requirements

 3-5 years' experience in data engineering, data warehousing, BI development, or a related field.

 Strong SQL skills with experience developing and troubleshooting complex queries.

 Experience building and supporting ETL/ELT pipelines.

 Understanding of dimensional modelling and data warehousing concepts.

 Experience working with large datasets and data integration processes.

 Exposure to cloud platforms such as AWS or Snowflake.

 Experience with Git-based source control and development workflows.

 Understanding of CI/CD concepts and deployment automation.

 Familiarity with Infrastructure-as-Code concepts.

 Experience supporting production data platforms and resolving operational issues.

 Understanding of monitoring, logging, and observability principles.

 Exposure to automated testing and data quality practices.

 Strong troubleshooting and analytical skills.

 Experience with Python, SQL, MSSQL or similar data engineering technologies.

 Understanding of software development lifecycle practices.

 Familiarity with Agile delivery methodologies.

Skills and Competencies

 Attention to detail and quality of work.

 Ability to take initiative and responsibility.

 Strong analytical skills.

 Good communication

 Provide accurate estimates

 Present solutions clearly

 Ability to work well under pressure and meet deadlines without sacrificing quality.

Education

 Degree or diploma in information science or related technical discipline

 Knowledge of financial concepts and terms and interested in attending courses to improve business knowledge

 Financial Services industry experience would be an advantage

Location and Closing date

Cape Town

10 November 2026