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 Customer Experience & Operations Enablement 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.
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
- Ability to write product-grade performant code for data extraction, transformations and loading using Spark, Py-Spark
- Do data modeling as needed for the requirements.
- Design, develop, and maintain data pipelines using Python ensuring scalability, reliability, and performance.
- Design and develop data pipeline architectures using Spark and related AWS Services.
- 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.
Required Experience & Education:
- 5 - 8 years of relevant analytics experience
Desired Experience:
- 4+ years of Experience in Databricks
- Strong development experience in Databricks, Spark, Py-Spark, Shell scripting, Teradata, MS SQL.
- Strong experience in writing complex and effective SQLs (using Teradata SQL, Hive SQL and Spark SQL) and Stored Procedures
- Excellent work experience on Databricks as Data Lake implementations
- Databricks (Delta Lake, Notebooks, Pipelines, cluster management, Azure/AWS
- Experience with Business Intelligence Software (Tableau, PowerBI, Looker, etc.)
- scripting language (Python, Powershell, VBA).
- Knowledge on Alteryx.
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 preferred.
- Proficiency in Agile practices (Jira) preferred.
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.
