Data Engineering Lead Analyst

Cigna Healthcare Africa is part of the International Health Delivery Services organization, responsible for Cigna’s Data Integration Hub. They operate in the Healthcare & Pharmaceuticals and Insurance sectors.

As a member of this team, you will contribute to the development and maintenance of our existing systems, as well as establishing how our data-driven solutions are developed and coded. You will be encouraged to contribute your own ideas and expertise, as well as to keep your skills up to date through training and learning. You will have the opportunity to engage with multiple teams across a number of different technological disciplines and geographical locations.

1. Support the design, development, testing, and maintenance of ETL processes and data integration solutions.
2. Troubleshoot and help resolve SQL Server-related issues.
3. Work closely with senior database developers to document requirements, design technical solutions, and attend project workshops and meetings.
4. Develop changes in T-SQL and SSIS for both “business as usual” and project work streams.
5. Model and document data mapping solutions, working with business and technical teams to decide on the best approach.
6. Assist with regular releases and monitor scheduled data processing batches.
7. Proactively suggest improvements to code, tools, and ways of working.

1. Minimum of 5 years’ experience in developing and supporting SQL Server solutions.
2. Expertise in T-SQL, including writing complex stored procedures, views and functions.
3. Strong understanding of database concepts and experience with query optimization and performance tuning.
4. Experience of developing ETL routines utilising SSIS.
5. Knowledge and experience of OLAP and OLTP environments.
6. Excellent problem-solving skills and a flair for reverse engineering complex code.
7. Experience working with Agile development methodologies.
8. Exposure to C# and Python.
9. Familiarity with modern data engineering technologies, such as PySpark and Databricks.
10. Basic experience with cloud technologies and services.
11. Exposure to source control (e.g. Git) and CI/CD practices.
12. Exposure to AI-assisted development tools such as GitHub Copilot, Cursor AI, or similar technologies.
13. Experience working with health insurance or healthcare data.