SQL Developer (cigna)
Job posting number: #157120 (Ref:24015956)
Job Description
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 Internal Markets Integration Team is located in the heart of the Global Health Benefits delivery group and is in charge of Cigna's ETL integration points between each policy administration and front-end system. The integration team is supporting a number of innovative projects, such as a brand-new ecosystem centred around various Salesforce and policy admin platforms.
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 Head of Integration and you will have the opportunity to engage with multiple teams across a number of different technological disciplines and geographical locations.
JOB IS FROM: italents.netVIEWCore responsibilities:
- Monitor and maintain core ETL processes.
- Troubleshooting and problem resolution for MS 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 SQL data mapping solutions, working with business and other technical teams to decide on the best solution.
- Assist with regular releases to live systems and monitor monthly 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 triggers
- 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:
- C#, VB.net or any other programming language
- Git or other source control expertise
- Experience of continuous integration/delivery
- Experience in SQL Server Reporting Services or other reporting tools
- Experience working in an Agile team utilizing SAFe
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 SQL Server and all things data related
About Cigna Healthcare
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.Qualified applicants will be considered without regard to race, color, age, disability, sex, childbirth (including pregnancy) or related medical conditions including but not limited to lactation, sexual orientation, gender identity or expression, veteran or military status, religion, national origin, ancestry, marital or familial status, genetic information, status with regard to public assistance, citizenship status or any other characteristic protected by applicable equal employment opportunity laws.
If you require reasonable accommodation in completing the online application process, please email: SeeYourselfEMEA@cigna.com for support. Do not email SeeYourselfEMEA@cigna.com for an update on your application or to provide your resume as you will not receive a response.