Mid-Level Data Engineer

Company Description

Kaelo provides essential healthcare solutions ensuring the physical and psychosocial wellbeing of all South Africans towards lasting social change. Kaelo meets the Healthcare needs of Corporate and Retail clients across South Africa – products offerings include Medical Insurance, Medical Aid, Gap Insurance, Kaelo Money and employee assistance programmes.

Job Description

Seeking a talented and results-oriented Mid-Level Data Engineer to join our growing team. In this pivotal role, you will play a key role in designing, developing, and maintaining our data infrastructure, ensuring the efficient and reliable flow of data to support critical business needs. You will collaborate with data analysts, data scientists, and other stakeholders to translate business requirements into robust data solutions, ultimately driving data-driven decision making across the organization.

Job requirements:

• Design, implement and manage scalable data pipelines ensuring optimal performance using best practices and industry-standard tools and technologies.
• Manage and maintain the ELT/ETL processes.
• Develop, manage and maintain the data warehouse, its architecture, integrations, schemas, scripts and automations
• Automate data processing tasks to improve efficiency and reduce manual work.
• Develop and implement data quality checks, proactive monitoring processes and maintenance activities on the data warehouse to ensure data integrity and accuracy.
• Develop, manage and maintain the Data infrastructure which includes the test, pre-production and production environments for the data warehouse.
• Implement a secure data framework that meets business needs
• Storing of Data in a secure and efficient manner and ensuring tight controls on access to data
• Work closely with data analysts and scientists to understand data requirements and translate them into technical specifications.
• Troubleshoot data-related issues and identify root causes to ensure consistent data delivery.
• Create documentation and processes for clear communication and knowledge transfer.
• Develop and maintain the data architecture and validations as part of the enterprise architecture project to ensure backend systems to ensure compliance.
• Deliver on projects and adopt a project-based delivery model.
• Stay up-to-date on emerging data technologies and trends and continuously seek opportunities to improve the organization's data infrastructure.
• Perform any other duties and responsibilities as assigned to support the team's objectives and the organisation's data needs.

Location and Work Model

This is a primarily office-based role; however, a hybrid work model for limited days can be explored based on performance.

Qualifications

Qualification:

• Bachelor's degree in Statistics, Mathematics, Computer Science, or a related field.

Knowledge/Experience:

• Minimum of 3 years of experience as a Data Engineer or similar role.
• Proven experience in designing, developing, and deploying data pipelines.
• Three or more years of experience with Python, SQL, PostgreSQL and data visualization/exploration tools such as Power BI or Looker
• Experience with data warehousing and data modelling concepts.
• Excellent problem-solving and analytical skills with a data-driven approach.
• Ability to work on a dynamic, analytical-oriented team that can work on concurrent projects.

Additional Information

Personal Attributes

• Excellent problem-solving skills backed by solid technical knowledge.
• Excellent customer service and communication skills, with the ability to explain technical concepts to non-technical users.
• Excellent organisational and time-management skills, with the ability to manage multiple priorities in a fast-paced environment.
• A versatile and service-oriented mind-set.
• Good communication skills.
• Understands the importance of documentation.
• Open to learn, but also willing to teach.