Business Analytics Lead Analyst - HIH - Evernorth

Business Analytics Lead Analyst The job profile for this position is Business Analytics Lead Analyst, which is a Band 3 Senior Contributor Career Track Role. The Client Analytics organization offers solutions that provide data, reporting, and actionable insights to internal/external business partners to improve customer experience, reduce cost, measure business performance, and inform business decisions. The Business Analytics Lead Analyst will be responsible for dashboard and report creation as well as the ability to pull data to meet adhoc measurement needs.  The individual will be able to create prototypes of reporting needs and support manual report/scorecard creation where needed when automated dashboards are not feasible.  The analytics lead analyst will be comfortable working directly with the Operations teams to learn about their process and where the data and reporting fits in.  Looking for candidates that can work directly with operations team members to understand requirements and do their own development and testing.

Required Experience & Education: 5 – 8 years of relevant analytics experience  5+ years of relevant analytics experience with focus on Proficiency with Structured Query Language (SQL) and Oracle. Experience with Business Intelligence Software (Tableau, PowerBI, Looker, etc.)

2+ years of experience with: scripting language Python.

Databricks, AWS

Responsibilities Include: Using SQL to write queries to answer questions and perform ETL tasks to create datasets.  Work with business and technical leadership to understand requirements.  Design to the requirements and document the designs Do data modeling as needed for the requirements. Design, develop, and maintain data pipelines using Python ensuring scalability, reliability, and performance. Develop and optimize data processing workflows using Databricks, ensuring efficient execution and resource utilization. Troubleshooting the issues, providing effective solutions and jobs monitoring in the production environment Participate in sprint planning sessions, refinement/story-grooming sessions, daily scrums, demos and retrospectives. Refactoring reporting to enhance performance, provide deeper insight, and answer questions. Updating project documents as well as status reports.

Desired Experience:    Strong development experience in Databricks, Python, Oracle Teradata, MS SQL. Strong experience in writing complex and effective SQLs (using Teradata SQL, Spark SQL) and Stored Procedures Databricks (Delta Lake, Notebooks, Pipelines, cluster management, Azure/AWS Strong development Tableau dashboard design, visualization, and reporting capabilities. Experience with Business Intelligence Software (Tableau, PowerBI, Looker, etc.) Strong Python skills are essential for supporting migration, automation, and process optimization initiatives. Hands-on experience in migration and automation projects is required to drive process efficiencies and system modernization initiatives

Additional Skills:   Experience in Jira and Confluence Excellent verbal, written and interpersonal communication skills a must. Problem-solving, consulting skills, teamwork, leadership, and creativity skills a must. Analytical mind with outstanding ability to collect and analyze data. Expertise in contact center or workforce planning operations is preferred. Proficiency in Agile practices (Jira) preferred. undefined

Equal Opportunity Statement Evernorth is an Equal Opportunity Employer actively encouraging and supporting organization-wide involvement of staff in diversity, equity, and inclusion efforts to educate, inform and advance both internal practices and external work with diverse client populations.

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.