Data Measurement & Reporting Analyst

ABOUT EVERNORTH: Evernorth exists to elevate health for all, because we believe health is the starting point for human potential and progress. As champions for affordable, predictable and simple health care, we solve the problems others dont, wont or cant. Our innovation hub in India will allow us to work with the right talent, expand our global footprint, improve our competitive stance, and better deliver on our promises to stakeholders. We are passionate about making healthcare better by delivering world-class solutions that make a real difference. We are always looking upward. And that starts with finding the right talent to help us get there. Role Title: Data Measurement & Reporting Analyst Position Summary: The job profile for this position is Data Measurement & Reporting Analyst, a Band 2 Senior Contributor Career Track Role. The Data Measurement & Reporting Analyst will play a technical support role on a team of 5 to 10 advisors and analysts. The team is responsible for the rapid development, quality review, and completion of 50 to 100 ad hoc reporting requests per week from business operations (claim, provider, call, client, legal, and compliance matrix partners). The output of the reports contains business intelligence including claim details, call details, client level information, etc. The work environment is fast paced and embedded within the business operation, affording the Data Measurement & Reporting Analyst and team to work directly with numerous business owners who serve our customers, clients, and providers. Establishes mutual levels of respect and trust with manager and teammates. This role supports day to day inventory management across the team, including managing ones own work- load independently. The incumbent requires basic to intermediate technical skills in SQL, SSIS, SAS, and Microsoft Access, to complete basic and moderately complex and/or time sensitive requests. Gathering business requirements, communicating through phone calls, Webex meetings, and written correspondence through Web Messenger and Outlook are essential to successful performance. Job Description & Responsibilities: Develop and deliver ad hoc reports daily, using basic to intermediate technical skills, to ensure reporting SLAs are met. This includes working with Data Measurement & Reporting Manager and teammates to manage ones own assignments based on capacity, complexity, and business partner escalations. Manage the quality review of ad hoc reporting output, critical to ensure reports are delivered accurately, the first time, as perceived by our requesting matrix partner. Protect confidentiality of data by ensuring reports are delivered in the appropriate medium, to the appropriate internal audience. Support the automation of reports produced manually, using SSIS, Python, and/or Tableau, depending on the best visualization fit to meet our matrix partner needs. Experience Required: SQL (Structured Query Language): Ability to write queries, using joins, subqueries, aggregation functions, views, indexing, pivoting, numeric calculations, stored procedures, and/or other basic to intermediate techniques. Ability to work across one or more DBMS (Oracle, SQL, etc). Relevant SQL certificates, training programs, and projects demonstrating SQL proficiency. SSIS (SQL Server Integration Services): Knows how to build or support ETL (extract, transform, and load) processes in code. Ability to efficiently load, copy, and download large files. SAS programming Basic skills for data access and generation of large size files. Microsoft Access - Ability to effectively manipulate queries and databases to create output. Python and/or Tableau basic to intermediate level to automate manually produced reports as well as create dashboards to visualize metrics trends for our matrix partners. Experience working with health insurance operations (claim, call, client, provider) is required. Experience Desired Education & Training: Bachelors degree or equivalent, with 1-3 years of proven experience in basic to intermediate SQL, SSIS, SAS, Tableau, Python, Microsoft Office, and other related software, is required. Additional Skills or Competencies: Success working with a team in a fast-paced demand and delivery environment is required. Ability to acquire systems domain and business knowledge, to translate business requirements into whats needed, why, how to query for data needed, and how to visualize the reporting output, is required. Ability to draw upon subject matter expertise with team members and business customers is required. Excellent verbal, written and interpersonal communication skills is required.

Location: Hyderabad, IN

Posted Date: 6/21/2024