Data Engineer (Analyst) at Cigna

YOUR JOB:

• Cigna IM consolidates data into a Common Data Model and Integrated Data Store to enable delivery of a seamless Digital experience to all our stakeholders, clients, plan members and healthcare providers.
• The Data Mapping team within Cigna IM provides mapping services and expertise to any team or project within Cigna IM that needs consolidated data.
• Your role will be a hands-on role, responsible for delivering these mapping services to our stakeholders.
• You will collaborate with team members, data analysts, systems analysts, product and business partners to evaluate and validate requirements and do the most optimal data mapping against our common data model. You will also be participating in developing our Data Management Tooling platform.

MAIN REPONSIBILITIES:

• Delivery of the Data Mapping 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.
• Build SQL queries to check the results from the mapping workshops.
• Validating change requests with full team, perform impact analysis, update and Cigna Data Model
• Establishing and maintain strong business relationships with key stakeholders.

SKILLS AND KNOWLEDGE NEEDED:

• Problem solver with excellent analytical skills and people skills
• Strong communication and presentation skills with ability to organize and facilitate workshops with several stakeholders
• Should be 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 Data Engineering teams (Mapping, Build & Test data flows, Data Governance) and business/project teams.
• Capable of writing (T-)SQL code to check the results from the workshops. As we operate in an Agile environment, as a full-stack team member you might assist in building and maintaining SQL (and SSIS) code to ingest the mapped data into the Integrated Data Store.
• Understanding of Healthcare Insurance industry

IDEALLY YOU’LL HAVE EXPERIENCE WITH:

• Extensive experience of data analytics / business analytics experience strongly preferred
• Experience with standard tools such as MS Excel
• Experience with SQL and affinity with Relational Data Models
• 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 with Data Management tools such as Informatika, Collibra, Erwin is a plus

WHAT WE OFFER:

• Permanent contract.
• Private pension
• Multicultural working environment with Hybrid working.
• Enjoy working from the comfort of your home 3 days per week and 2 days from our Nairobi office.
• Social Benefits.
• Private Medical Insurance.
• Educational Development Program.