Business Analytics Lead Analyst - HIH - Evernorth

Evernorth Health Services; Hyderabad; On-site; INR 12,00,000 - 18,00,000; Full time

Job summary

A health services company located in Hyderabad is seeking a Business Analytics Lead Analyst. The role involves designing and developing data pipelines, performing data analysis, and using SQL and Databricks to extract insights. The ideal candidate has 5-8 years of analytics experience and strong skills in ETL processes, SQL, and data modeling. Join in improving health outcomes through data-driven decisions.

Qualifications

• 5 to 8 years of relevant analytics experience.
• Strong SQL skills, including complex queries and stored procedures.
• Experience with Databricks and data lake implementations.

Responsibilities

• Write SQL queries to perform ETL tasks and create datasets.
• Develop and maintain data pipelines using Python.
• Troubleshoot issues and monitor jobs in production.

Skills

SQL

Databricks

Spark

Python

ETL

PowerBI

Education

5 - 8 years of relevant analytics experience

Tools

Teradata

MS SQL

Tableau

Job description

Business Analytics Lead Analyst - HIH - Evernorth

Join to apply for the Business Analytics Lead Analyst - HIH - Evernorth role at Evernorth Health Services

Business Analytics Lead Analyst - HIH - Evernorth

2 days ago Be among the first 25 applicants

Join to apply for the Business Analytics Lead Analyst - HIH - Evernorth role at Evernorth Health Services

Get AI-powered advice on this job and more exclusive features.

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.

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.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Business Development and Sales

• Industries

  Hospitals and Health Care

Referrals increase your chances of interviewing at Evernorth Health Services by 2x

Get notified about new Analytics Analyst jobs in Hyderabad, Telangana, India.

Datamart and Reporting Analytics (Tableau/PowerBI & SQL)- Analyst-Hyderabad

Associate Analyst Business Intelligence & Reporting

Marketing Insights and Transformation Analyst

Business Analyst - Enterprise Data Operations

Analyst - Financial reporting and analytics

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.