Software Engineering Lead Analyst - HIH - Evernorth

Software Engineering Lead Analyst Data Analyst

Position Summary:

Evernorth , a leading Health Services company, is seeking a talented Data Analyst to join our Data & Analytics organization. In this role, you will be responsible for implementing AtScale as a semantic layer and collaborating with various business units to build their semantic layers, empowering self-service analytics across different tools and data sources. Strong collaboration skills are essential, as you will work closely with cross-functional teams to ensure successful implementation and utilization of the semantic layer. This position requires fluency in critical technologies, a hunger to learn, and a strong sense of ownership and accountability

Job Description & Responsibilities :

• Collaborate with Business stakeholders to understand key metrics, KPIs, business definitions, translating them into a logical data model.
• Create and maintain dimensional models that represent business concepts in a structured , queryable format.
• Develop and Manage metadata to ensure consistent definitions of business terms, hierarchies and calculations across the organizations.
• Develop semantic models using Atscale to define reusable business logic, calculations and aggregations.
• Ensure semantic layer integrates seamlessly with BI tolls like Tableau, Power BI, ThoughtSpot for reporting, dashboards and self service analytics.
• Design intuitive data models and views that allow non-technical users to query data without needing to understand underlying complexities.
• Ensure semantic layer can handle growing data volumes and user concurrency.
• Implement role based access control and data security policies to restrict access based on user roles or sensitivity of data.
• Partner with business analysts, data scientists and executives to gather requirements and validate the semantic layers functionality.
• Create and maintain documentation for the semantic layer, including data models, business definitions and usage guides.
• Train business users on how to leverage the semantic layer for self-service analytics and reporting.
• Provide ongoing support for resolving issues related to data access, query performance or model accuracy.

Qualifications

Required Experience & Skills:

• 8 to 11 years of overall Engineering experience.
• 3-5 years of Experience with data platforms such as databricks, snowflake.
• 3-5 years of experience in Python/PySpark, SparkSQL.
• Proficiency in writing complex SQL queries to transform and aggregate data.
• Good Understanding of indexing, partitioning and query execution.
• Experience in building semantic layer using atscale, dbt, ucmetrics or similar.
• Familiar with BI tools like tableau, Power BI, Thoughspot to integrate semantic layer for end user consumption.
• Experience in Dimensional modelling and relational database concepts.

Preferred Experience & Skills:

• 2+ years being part of Agile teams Scrum or Kanban
• Experience with GitHub/Jenkins.
• Experience with cloud technologies like AWS.
• Troubleshooting skills
• Strong communication skills
• Fluent in BDD and TDD development methodologies
• Familiarity with AI/ML concepts and workflows.

Location & Hours of Work

• Full-time position, working 40 hours per week. Expected overlap with US hours as appropriate
• Primarily based in the Innovation Hub in Hyderabad, India in a hybrid working model (3 days WFO and 2 days WAH)

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