Data Engineering Lead Analyst

The Position

• The International Health Data Engineering team sits at the heart of the International Health Delivery Services organization and is responsible for Cigna's Data Integration Hub, which ingests data from multiple sources, including all the policy admin systems, and makes it available to numerous downstream consumers. The team is central to provisioning the data behind a range of key initiatives, including all the web portals and multiple integrations, both internal and external.
• 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.

Core Responsibilities

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

Essential Skills

• Minimum of 5 years' experience in developing and supporting SQL Server solutions.
• Expertise in T-SQL, including writing complex stored procedures, views and functions.
• Strong understanding of database concepts and experience with query optimization and performance tuning.
• Experience of developing ETL routines utilising SSIS.
• Knowledge and experience of OLAP and OLTP environments.
• Excellent problem-solving skills and a flair for reverse engineering complex code.
• Experience working with Agile development methodologies.

Highly Desirable

• Exposure to C# and Python.
• Familiarity with modern data engineering technologies, such as PySpark and Databricks.
• Basic experience with cloud technologies and services.
• Exposure to source control (e.g. Git) and CI/CD practices.
• Exposure to AI-assisted development tools such as GitHub Copilot, Cursor AI, or similar technologies.
• Experience working with health insurance or healthcare data.