Business Analytics Lead Analyst -Express Scripts - Hybrid

Cigna Healthcare • St. Louis, MO

2d • Hybrid

About The Position

The Business Analytics Lead Analyst will work directly with Econdisc management and analytics teams to support the data analysis, reporting, and maintenance of our wholesaler and supplier sales data. Additionally, the Lead Analyst will support financial modeling, pricing evaluations and other ad hoc analysis as required by the business. As a Business Analytics Lead Analyst, you will collaborate with the team to load daily/weekly sales files and review the data to identify variances and determine cause/resolution. The Lead Analyst will need to be able to write or modify SQL queries using Microsoft SQL Server to obtain necessary data for analysis. Responsibilities: Provides advanced professional input to complex Business Analytics assignments/projects. Works in collaboration with business partners to provide analyses and reports to aide decision making based on data, facts, and analytical findings across different parts of the organization. Analyzes and interprets collected data, spots trends, writes reports and recommendations and completes data modeling. Supports and provides direction to more junior professionals. Works autonomously, only requiring “expert” level technical support from others. Exercises judgment in the evaluation, selection, and adaptation of both standard and complex techniques and procedures Utilizes in-depth professional knowledge and acumen to develop models and procedures, and monitor trends, within Business Analytics. Qualifications: 3+ years relevant professional work experience preferred Advanced analytical and strategic thinking skills, highly organized, and self-motivated Analytical and detail-oriented in all work activities. Able to handle and prioritize multiple projects or tasks at a time. Able to solve complex problems, communicate professionally, both verbally and in writing. Advanced knowledge of Microsoft Excel is required. Knowledge of one or more query design tools (such as Microsoft SQL Server Management Studio, Teradata SQL Assistant, Oracle SQL Developer, etc.) is required. Ability to write, develop, tune, and maintain SQL statements is a plus. Knowledge of one or more ETL (Extract-Transform-Load) tools (such as Microsoft SQL Server Integration Services, Informatica, Ab Initio, Talend, SSIS, Alteryx, etc.) a plus. Demonstrated knowledge of reporting tools (Business Objects, Tableau, Power BI, etc.) is a plus. If you will be working at home occasionally or permanently, the internet connection must be obtained through a cable broadband or fiber optic internet service provider with speeds of at least 10Mbps download/5Mbps upload. About Evernorth Health Services Evernorth Health Services, a division of The Cigna Group, creates pharmacy, care and benefit solutions to improve health and increase vitality. We relentlessly innovate to make the prediction, prevention and treatment of illness and disease more accessible to millions of people. 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: [email protected] for support. Do not email [email protected] for an update on your application or to provide your resume as you will not receive a response. The Cigna Group has a tobacco-free policy and reserves the right not to hire tobacco/nicotine users in states where that is legally permissible. Candidates in such states who use tobacco/nicotine will not be considered for employment unless they enter a qualifying smoking cessation program prior to the start of their employment. These states include: Alabama, Alaska, Arizona, Arkansas, Delaware, Florida, Georgia, Hawaii, Idaho, Iowa, Kansas, Maryland, Massachusetts, Michigan, Nebraska, Ohio, Pennsylvania, Texas, Utah, Vermont, and Washington State. Qualified applicants with criminal histories will be considered for employment in a manner consistent with all federal, state and local ordinances. Doing something meaningful starts with a simple decision, a commitment to changing lives. At The Cigna Group, we’re dedicated to improving the health and vitality of those we serve. Through our divisions Cigna Healthcare and Evernorth Health Services, we are committed to enhancing the lives of our clients, customers and patients. Join us in driving growth and improving lives.

Requirements

• 3+ years relevant professional work experience preferred
• Advanced analytical and strategic thinking skills, highly organized, and self-motivated
• Analytical and detail-oriented in all work activities.
• Able to handle and prioritize multiple projects or tasks at a time.
• Able to solve complex problems, communicate professionally, both verbally and in writing.
• Advanced knowledge of Microsoft Excel is required.
• Knowledge of one or more query design tools (such as Microsoft SQL Server Management Studio, Teradata SQL Assistant, Oracle SQL Developer, etc.) is required.
• If you will be working at home occasionally or permanently, the internet connection must be obtained through a cable broadband or fiber optic internet service provider with speeds of at least 10Mbps download/5Mbps upload.

Nice To Haves

• Ability to write, develop, tune, and maintain SQL statements is a plus.
• Knowledge of one or more ETL (Extract-Transform-Load) tools (such as Microsoft SQL Server Integration Services, Informatica, Ab Initio, Talend, SSIS, Alteryx, etc.) a plus.
• Demonstrated knowledge of reporting tools (Business Objects, Tableau, Power BI, etc.) is a plus.

Responsibilities

• Provides advanced professional input to complex Business Analytics assignments/projects.
• Works in collaboration with business partners to provide analyses and reports to aide decision making based on data, facts, and analytical findings across different parts of the organization.
• Analyzes and interprets collected data, spots trends, writes reports and recommendations and completes data modeling.
• Supports and provides direction to more junior professionals.
• Works autonomously, only requiring “expert” level technical support from others.
• Exercises judgment in the evaluation, selection, and adaptation of both standard and complex techniques and procedures
• Utilizes in-depth professional knowledge and acumen to develop models and procedures, and monitor trends, within Business Analytics.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed