Health Care Analyst

Location: Beverly, MA
Job ID: 152771-1A
Date Posted: Jan 10, 2019

Job Description

Welcome To

Lahey Health Shared Services is part of a vibrant and growing health care system, recognized as a trailblazer in medicine and a standard bearer in patient experience. It includes an award-winning academic medical center, a superb constellation of community hospitals, home care services, rehabilitation facilities and more.

We are committed to attracting, developing and retaining top talent in a market long recognized and revered as a global leader in health. With a team approach to care, we encourage learning and growth at all levels, and we offer competitive salaries and benefits. We adhere to the principles of a just and fair work environment for all colleagues, where respect is foundational and performance is rewarded.

About the Job

Under the general supervision of the Director, Data Performance and Analytics, the Healthcare Analyst is responsible for understanding the various data sources behind organization’s population and learns how to effectively and accurately use these sources to produce meaningful cost and utilization summaries.  Produces analyses that answer questions about most pressing healthcare needs and occasionally assists care management with the management of the riskiest patients within the populations.  Assures, by data testing, the quality and accuracy of LCPN’s claims and EMR data warehouse. Understands data complexity and requirements to produce analyses for various cross-departmental stakeholders from Lahey Health that answer questions to the most pressing healthcare needs.  Responsible for developing reports for upper-level management, and preparing monthly reporting packages.  May be asked to develop enhanced reports for the organization. May work under the supervision of the Senior Healthcare Analyst.


Compiles medical and pharmacy related information via the use of computer-based applications which is then used to understand the current trends and drivers in the health care system and to make well-informed decisions about performance improvements of the plan and care management of the patients.  Supports care managers in providing better care to the patients.  Participates in setting definitions and efficient ways to analyze various healthcare concepts, compares medical expenses to budgets, and assists in finding data related efficiencies. Handles the data with confidentiality especially around PHI and sensitive information.


This position is responsible for a full range of activities which ensure the analytical effectiveness and excellence of the LCPN team. 


Essential Duties & Responsibilities including but not limited to:

  • Gains access and learns the tools used to access population’s data.

  • Understands the medical and pharmacy claims adjudication circle terminology and general healthcare related concepts.

  • On regular basis, utilizes different data sources to produce meaningful cost and utilization reports, track the performance of various products and plans and provide meaningful information to care managers to assist them in providing better care to the patients.

  • On regular basis, from analytical perspective, tests healthcare concepts in LCPN’s data warehouse to assure accuracy and integrity of data.

  • Collaborates with other analysts to define appropriate mappings for healthcare terminologies to be displayed in the data warehouse.

  • Understands and utilizes back-end entry to data warehouse, knows SQL and apprehends complexities of data architecture.

  • Produces reports for variety of stakeholders using either the super pivots, running own SQL queries to drill through data or other computer-based applications.

  • Translates analytical findings into easy to follow recommendations and summaries.

  • Performs own quality checks on performed analyses and utilizes internal benchmarks to verify the results.

  • Incorporates CHIA cost relativity benchmarks into analyses when appropriate.

  • Documents performed processes and assures the correct documentation exists and is appended to the analyses.

  • Collaborates with the Medical Director(s) and business associates (e.g., healthcare plan, PBM, consultants) to define the best approaches to find areas for improvement and trend mitigations.

  • Collaborates with Care Managers to find efficient ways to include the patients in the disease management programs and improve the care of the patients.

  • Has knowledge of a medical and pharmacy claim cycle.

  • Analyzes cost and utilization trends at the network level.

  • Receives and reviews administrative payer’s newsletters and assesses the impact of changes on the network and data when necessary.

  • Understands the drivers of healthcare trends.

  • Understands the impact of benefit changes on the plan performance.

  • Serves as analytical resource and internal consultant for organization’s multidisciplinary quality and utilization improvement initiatives.

  • Upon discussions with other stakeholders, provides actionable data to constituencies within LCPN upon request.

  • Designs analyses that calculate cost savings opportunities for LCPN’s population.

  • Communicates effectively with cross-functional teams.

  • Provides clinical and administrative leaders with routine and timely updates on key clinical quality and utilization indicators at the network level.

  • Assist in reporting package preparation for the Board of Directors and other Senior Executives.

  • Assist in designing analyses that calculate cost savings opportunities for the network as well as individual accountable care units.

  • Collaborates with others to identify, understand and promote opportunities to analyze data more efficiently and accurately, and improve data integrity.

  • Assists Data and Performance Analytics Director with keeping internal PointShare site up to date.

  • Supports vendor pilot programs via assessing and distributing reports made available by the partners.

  • Uses visualization tools to display date for key customers.

  • Performs other related tasks as necessary.


  • Requires a minimum of a Bachelors’ degree.  Prior experience from the payers or other provider system a plus.  A Master’s degree in directly related program may be considered in lieu of some of the required work experience


  • A minimum of 1-3 years of healthcare work experience is necessary either through a prior Health System or a Payer experience.

  • Knowledge of programming language (e.g. SQL) is beneficial but not required. 

  • A Master’s degree in a directly related program may be considered in lieu of some of the required work experience.

Skills, Knowledge & Abilities:

  • Strong written and verbal communication skills, project management skills, computer skills, and database skills.

  • Strong problem solving abilities and analytical skills to ensure end-user needs are met.

  • Possesses good organizational skills and the ability to multitask and prioritize daily assignments to ensure smooth work flow.

  • Advanced Excel Skills, demonstrated ability in using query tools and relational data bases such as SQL or Microsoft Access.

  • Knowledge of claims based health care data, including medical terminology and standard coding systems (ICD9, ICD10, CPT, MS-DRG, etc.

About Us

The Lahey Model of Care—right care, right time, right place—is exactly what patients, providers and payers need and deserve. Identifying and delivering on this convergence of interests has positioned Lahey Health for further growth. Our model ensures care is highly coordinated and locally delivered, with lower costs and exceptional quality.

Lahey Health is a robust, regional system including a teaching hospital, community hospitals, primary care providers, specialists, behavioral and home health services, skilled nursing and rehabilitation facilities, and senior care resources throughout northeastern Massachusetts and southern New Hampshire. The system has a global presence with programs in Canada, Jordan and Bermuda.

Equal Opportunity Employer/Minorities/Females/Disabled/Veterans.