Business Analytics Lead Analyst

Job Summary:

The Business Intelligence/Analytics is responsible for Design, Development and Testing of Operations Analytics. Demonstrates ability to interpret and refine customer requirements and effectively fulfills information needs using available business intelligence and analytical tools and techniques or through development of ad hoc queries and or macros.

Role Responsibilities:

• Delivering BI/ analytics small solutions in a pro-active and timely manner based on assigned priorities and uncompromising quality with effective testing practices applied.
• Manage and take end-to-end ownership the Cignas SLA driven client performance reporting. There are 100+ clients with 80+ unique metrics which needs to be delivered to brokers, client management and advocacy team on a pre-agreed timeline every quarter. The entire process is SLA driven and needs extensive collaboration between data & analytics, operations, client management & finance
• Communicate progress on assigned initiatives to management and customers of the initiatives.
• Create and establish and modify current processes working with different company stakeholders.
• Visualization needed to be able to provide actionable insights.
• Able to balance tactical day-to-day delivery of MIS with new MIS/BI builds.
• Able to understand code & process for technologies like Qlik, oracle or SQL that will be useful in overall support of SLA performance reporting & monitoring.
• Review of SLA client contracts placed a central repository as needed & approve and maintain change requests for seamless delivery of performance reporting in timely manner.

Solution Capability:

• Design and devise solution for small to complex BI delivery projects, including identifying static (e. g. Excel/Access) and dynamic (e. g. SQL, Oracle) data sources, alignment to business requirements, gaps in available processes and data, best path forward to delivery BI/ analytics/ insights to business leveraging existing tools/ capabilities with sustainable solutions.
• Comfortable building sustainable yet tactical solutions in spite of lack of enterprise solutions with offline and online data sources while working with technology for end state solutions
• Proactively identify efficiency opportunities in existing business as usual reporting/ ad hoc reporting and implement automated solutions demonstrating time and productivity gains.
• Understand KPIs used in SLA Client Reporting, technology and source system behind each KPI and able to debug independently if any issues in these metrics used in SLA client reporting

Business:

• Knowledge/ prior experience of Operations, Health Insurance strongly preferred with demonstrated experience in driving operational metric reporting/MIS and improvements while working directly with internal and external customers
• Ability to interpret data to understand key drivers for results and principal factors leading to the numbers and impact of a metric on other functions.

Cross Functional:

• Knowledge/ prior experience of Operations, Health Insurance.
• Senior leadership communication skills.
• Adaptability, multitasking without impacting quality, ability to handle pressure, changing priorities.

Qualifications:

• Bachelor s degree in Computer Information Systems, Business Administration, or equivalent is preferred
• 5+ years of Programming experience.
• Must have strong Qlikview, Tableau, SQL, Excel, and Microsoft Access experience.
• Must possess strong organizational, problem solving and analytical skills.
• Strong, clear and concise written and oral communication skills.
• Ability to work and help promote change within the department and across networks effectively.
• AWS (Amazon Web services) experience is a PLUS.
• Microsoft SharePoint skills and experience are PLUS.
• SAS experience is a PLUS.
• Excel Power Query & Power BI experience is a PLUS

About The Cigna Group