Developer II | Retail IT | BI
- Location
- Cape Town, Western Cape
- Minimum qualification
- Diploma
- Closing date
First listed . Last checked at source .
In brief
**Overview** This role is for a Developer II at Allan Gray, joining the Retail IT Data Platform and Warehousing Development team. The team is dedicated to modernising and evolving both their Microsoft SQL Server-based data warehouse and Snowflake-based analytical platform. The position involves contributing to the development, support, and evolution of data products and operational processes across these environments, with a focus on establishing modern DataOps practices. **What you will do** * 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 (from the original advert)** * 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. * Degree or diploma in information science or related technical discipline. **Who should apply** The ideal candidate should demonstrate attention to detail and a high quality of work, with the ability to take initiative and responsibility. They should possess strong analytical and good communication skills, capable of providing accurate estimates and presenting solutions clearly. The role requires someone who can work well under pressure and meet deadlines without sacrificing quality. Knowledge of financial concepts and terms, along with an interest in attending courses to improve business knowledge, is expected. Financial Services industry experience is considered an advantage. **Deadline** 10th November, 2026 **Reference** Original posting: https://www.myjobmag.co.za/job/developer-ii-retail-it-bi-allan-gray-proprietary-limited Source: myjobmag
Summary drafted with AI assistance from the original advert. The advert itself is the authority — how we use AI.
At a glance
- At least 3 years of experience.
- Python
- SQL
- AWS
- Git
- Agile / Scrum
Extracted automatically from the advert; confirm requirements on the original listing.
Job description
Before you apply
- Confirm the requirements and closing date on the original listing (myjobmag). SPANi lists vacancies from other sites and may not reflect last-minute changes.
- Legitimate employers do not charge application, registration or training fees.
- Don't send your ID or bank details before you have confirmed the employer is real.
Also listed on: myjobmag, myjobmag, myjobmag.
Before you apply
- Read the full advert and confirm you meet the minimum requirements before applying.
- Tailor your CV headline and most recent experience to the job title and key skills.
- Note the closing date and reference number, and keep a copy of what you submit.
- Apply only through the employer or job board link — never pay to apply.