Vacancies at Cigna

About Cigna, Team and Role:

• 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 in charge of 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.
• That integration hub is modelled against the Common Data Model to enable delivery of a seamless Digital experience to all our stakeholders, clients, plan members, healthcare providers.
• As a Data Engineering team member, you will be analysing data models from other systems against this central data model, and you will determine mapping and transformation logic between them. 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.

Skills/Tasks

• Delivery of the commitments of the team you will work in, work with ecosystem, project managers, scrum masters and product owner to ensure that work is completed and that queries, issues, escalations are resolved.
• Owning individual mappings for inbound or outbound mapping, own updates to mapping documentation, monitor evolving scope & perform gap analysis, plan and lead workshops, follow-up on CRs to incorporate in plan, manage SMEs and allocate pre-work and research, provide metrics, action data QA feedback.
• Write SQL queries to check and validate the results from the mapping workshops.
• Validating change requests with full team, perform impact analysis, update and Cigna Data Model
• Troubleshooting and problem resolution for MS SQL Server related issues.
• Work closely with senior 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.
• Establishing and maintain strong business relationships with key stakeholders.

About you:

• Problem solver with excellent analytical skills and people skills
• Enthusiastic and possessing a “can do” attitude
• A real self-starter, happy to see a project or issue through to the end
• Passionate about technology and applying it to business solutions
• Strong communication and presentation skills with ability to organize and facilitate workshops with several stakeholders
• Resourceful, work well under pressure, and able to keep up in a fast-paced environment
• Extremely detail oriented, with excellent organization skills
• Ability to build strong working relationships across the organization
• Strong preference for Data Management ; able to bridge technical  and business/project teams
• Have a track record of getting things done whilst adhering to a governance framework
• A passion for all things data related

Ideally you will have experience with:

• Extensive experience of data analytics / business analytics experience strongly preferred
• Proven ability to manage stakeholder communications and facilitate workshops, demonstrating strong verbal and written skills
• Demonstrated knowledge of healthcare products, benefits, claims, and/or customer service or related experience
• 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
• Experience with standard tools such as MS Excel

Highly desirable:

• C#, VB.net or any other programming language
• Git or other source control expertise
• Experience working with cloud technologies, particularly AWS
• Experience using the Red-Gate toolset
• Experience of continuous integration/delivery
• Experience in SQL Server Reporting Services or other reporting tools
• Experience with Data Management tools such as Collibra, Erwin.
• Understanding of Healthcare Insurance industry

go to method of application »

What are your main responsibilities?

• You are responsible for the client communication for designated account relationships and Contracts.
• You are required to response to the client on timely manner providing full and accurate information in one go.

Main Duties / Responsibilities

• Handle calls and e-mails and respond to simple and complex inquiries regarding eligibility, cards status, envoy registration/navigation, policy benefits, issue certificates of insurance, claims status and other related information and provide solutions for customers and clients.
• Receives requests by mail, telephone, or in person regarding insurance claims/policies. Responds to inquiries from policy holders, clients, brokers and/or others.
• Performs research to respond to inquiries and interprets policy provisions to determine most effective response.
• Mails or routes claim forms and supporting documentation to various units for final processing.
• Excellent interpersonal skills, ability to understand and interpret policy provisions. Independently responds to inquiries, grievances, complaints, or appeals ranging from routine to moderate complexity.
• May seek assistance with complex customer services issues.

Qualifications

• Must have a diploma or bachelor’s degree certificate
• Excellent English written and oral communication skills
• Portuguese written and oral skill is a must
• Exceptional organizational and time-management focus
• Independently responds to inquiries, grievances, complaints or appeals ranging from routine to moderate complexity.
• 1+ years of customer service experience analyzing and solving customer problems required; call center experience a plus
• Ability to perform in a high volume, fast paced call center environment
• Proven ability to work independently as well as a productive member of a team
• Intermediate proficiency in Microsoft office suite; high level capacity to multitask independently and on a computer
• Knowledge of medical terminology a plus

Conditions/requirements

• Work in 24 x 7 rotation shifts.
• 5 days a week.
• In split shifts (some hours in the morning and remaining hours in the afternoon or evening) and public holidays