Core responsibilities
Develop and maintain core ETL processes
Develop changes in T-SQL and SSIS for both “business as usual” and project work streams.
Troubleshooting and problem resolution for data related issues.
Work closely with scrum team members to document requirements, design technical solutions and attend project workshops and meetings.
Model and document data mapping solutions, working with business and other technical teams to decide on the best solution.
Assist with regular releases to live systems using CI/CD pipelines.
Proactively suggest improvements to code, tools and ways of working.
Essential Skills
Minimum of 5 years' experience in developing and supporting SQL Server ETL 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
Have 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
Python, C#, VB.net or any other programming language
Oracle and Postgres experience
Databricks, Basic Cloud Experience (AWS/Azure)
Git or other source control expertise
Experience working in an Agile team utilizing SAFe
Experience of continuous integration/delivery (CI/CD)
Experience with AI driven code generation tools
The person
A real self-starter, happy to see a project or issue through to the end
Passionate about technology and applying it to business solutions
Enthusiastic and possessing a “can do” attitude
Have a track record of getting things done whilst adhering to a governance framework
A passion for data engineering and all things data related
About The Cigna Group
Cigna Healthcare, a division of The Cigna Group, is an advocate for better health through every stage of life. We guide our customers through the health care system, empowering them with the information and insight they need to make the best choices for improving their health and vitality. Join us in driving growth and improving lives.
