Data Engineering Senior Analyst

The job profile for this position is Application Development Senior Analyst, which is a Band 3 Senior Contributor Career Track Role. Excited to grow your career? We value our talented employees, and whenever possible strive to help one of our associates grow professionally before recruiting new talent to our open positions. If you think the open position you see is right for you, we encourage you to apply Our people make all the difference in our success. The position: Cigna is a multinational company and a leading global health services provider, dedicated to helping people improve their health, wellbeing and sense of security. We are going through an exciting period of expansion and seek to recruit into our Global Employer Segment which currently employs 8,000 people and has over 30 million customer relationships in more than 200 countries and jurisdictions. The International Health Data Engineering team is located in the heart of the Global Health Benefits delivery group and is responsible for Cigna's data integration hub which consumes data from multiple sources including all the policy admin systems, and makes it available to numerous downstream consumers. The data engineering team is central in provisioning the data that supports a number 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. The position reports to the Data Engineering Technical Lead and you will have the opportunity to engage with multiple teams across a number of different technological disciplines and geographical locations. 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 Please note that you must meet our posting guidelines to be eligible for consideration. Policy can be reviewed at this link.