Developer II | Institutional IT | Institutional Data Platform

Allan Gray Group; Cape Town; On-site; ZAR 700,000 - 950,000; Full time

Job summary

Allan Gray is seeking a Data Engineer to design, build and maintain scalable data pipelines and platforms that enable efficient data collection, processing and integration across the organization. The role focuses on Python, SQL, data orchestration, and cloud technologies to support analytics and reporting initiatives.

You will collaborate with data analysts and engineers to deliver robust, automated workflows, APIs, and ensure data quality, security, and observability throughout the data

Qualifications

• Proven experience as a Data Engineer.
• Proven SQL experience for querying, transforming and managing relational data, including performance tuning and logging.
• Hands-on experience with ETL/ELT processes and data pipeline orchestration tools.
• Experience with cloud platforms and services, ideally AWS.
• Knowledge of data modelling, database design and schema optimisation.
• Understanding of API design, development and integration.
• Proficiency in version control systems (e.g. Git, Flyway) and CI/CD workflows.
• Exposure to PostgreSQL would be an advantage.

Responsibilities

• Work as part of a larger IT team using the Scrum methodology.
• Interact with business users, Business Analysts and other developers to understand user requirements.
• Develop and optimise data pipelines and ETL processes.
• Integrate data from multiple sources into data platform.
• Monitor, troubleshoot and ensure data system reliability and integrity.
• Automate data workflows and support CI/CD pipelines.
• Design, develop and maintain robust APIs to enable secure, scalable and efficient access to data assets.

Skills

Python

SQL

APIs

Data orchestration

Cloud platforms

CI/CD

PostgreSQL

Version control

Education

Degree or diploma in information science

Tools

Git

Flyway

PostgreSQL

Job description

Career Opportunities: Developer II | Institutional IT | Institutional Data Platform (9127)

We are a 77-member team consisting of Domain Owners, Development Managers, Architects, Business Analysts, Full Stack Developers, Data Engineers, DevOps Engineers and IT Operations specialists. Our team is responsible for the systems that support Allan Gray’s asset management function, offering an exciting opportunity to grow within both the asset management industry and advanced technology solutions.We are seeking a skilled Data Engineer to design, build and maintain scalable data pipelines and platforms that enable efficient data collection, processing and integration across the organisation. The ideal candidate will have strong expertise in Python, SQL, data orchestration tools and cloud technologies with a passion for creating reliable, high-performance data solutions that support analytics, and reporting initiatives. You will collaborate closely with data analysts and engineers to deliver robust, automated workflows and API’s while ensuring data quality, security and observability throughout the data lifecycle.

Job Responsibilities

• Work as part of a larger IT team using the Scrum methodology.
• Interact with business users, Business Analysts and other developers to understand
• user requirements.
• Develop and optimise data pipelines and ETL processes.
• Integrate data from multiple sources into data platform.
• Monitor, troubleshoot and ensure data system reliability and integrity.
• Automate data workflows and support CI/CD pipelines.
• Design, develop and maintain robust API’s to enable secure, scalable and efficient access to data assets.

Requirements

• Proven experience as a Data Engineer.
• Proven SQL experience for querying, transforming and managing relational data
• including performance tuning and optimization, error handling and logging.
• Hands-on experience with ETL/ELT processes and data pipeline orchestration tools.
• Experience with cloud platforms and services, ideally AWS.
• Knowledge of data modelling, database design and schema optimisation.
• Understanding of API design, development and integration.
• Proficiency in version control systems (e.g. Git, Flyway) and CI/CD workflows.
• Exposure to PostgreSQL would be an advantage.

Skills and Competencies

• Keen attention to detail and commitment to delivering high-quality solutions.
• Strong analytical and problem-solving skills with the ability to troubleshoot data issues,
• optimise workflows and design effective technical solutions.
• A self-starter who proactively identifies tasks and opportunities, takes ownership and
• drives projects to completion.
• Demonstrated ability to manage priorities, meet tight deadlines and perform effectively
• under pressure.
• Good communication and collaboration skills to work effectively as part of a diverse
• team.
• 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.

Qualifications

• 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.