Reports Analyst

Location: Woburn, MA
Job ID: 155173-1A
Date Posted: May 20, 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

The Reports Analyst utilizes multiple EHR systems in building reports required by the organization. The Reports Analyst assists in the analysis, planning, design, creation, and maintenance of simple to complex reports/database projects.

Essential Functions including but not limited to:

  • Creates reports sourcing database observations from numerous tables (including but not limited to observations on documents, flowsheets, and patient demographics or visit information). Able to query clinical databases using SQL query logic and map out the dependencies and connections among hundreds of source tables and views using SQL Server Management Studio.
  • Analyzes clinical & financial data contained in the EHR database and  to identify data reporting issues with existing and proposed system tools; works with other CID colleagues to ensure data collection requirements meet the current build specifications
  • Documents detailed specifications for each report including both the technical specifications and a summary of the report.
  • Completes thorough unit testing of all build prior to handoff for functional and/or integrated testing. Also facilitates functional and integrated testing as requested as well as Creates and provides documentation as required to the testing and training team
  • Provides end user support pertaining to reporting during implementation; able to serve as a reporting expert to assist in application roll-out
  • Create and edit Stored Procedures, Views, Functions and Queries on SQL Server to pull require data for reporting purposes using SQL Server Management Studio.
  • Develops dynamic reports enabling the end users to define numerous parameters that allow users to filter and aggregate as required.  Also creates custom reports that allow end users to drill down for more detail.
  • Configure and create packages for report distribution using Microsoft SQL Server Business Intelligence Development Studio’s Integration Services.
  • reates SharePoint sites, lists, libraries, calendars, web part pages, dashboards, etc.
  • Creates Crystal Reports
  • Documents and reports system issues to EHR Analytics & Reporting Manager
  • Proactively identifies and communicates barriers to completing work requirements
  • Assists in the preparation of demo materials for workflow decisions or new system functionality
  • Participates in on-call coverage as assigned by department lead/manager
  • Maintains confidentiality with regard to the information being processed, stored or accessed by the system.
  • Achieves and maintains certification according to organizational standards
  • Applies proven communication, analytical and problem-solving skills to help identify, communicate and resolve system issues to maximize system potential

Education:

  • Bachelors Degree in a related field. In the absence of a Bachelors Degree has eight years of related experience in addition to the experience requirement shown below

Skills, Knowledge & Abilities:  

  • Capable of managing multiple priorities at once.
  • Self-starter and motivator.
  • Excellent communication and problem-solving skills.
  • Able to teach others and serve as a mentor to develop departmental colleagues.
  • Proficient in Microsoft Office suite programs; specifically Excel, Access and PowerPoint.
  • Baseline knowledge of SQL Server Business Intelligence.
  • Knowledge of current Stage 1-3 ARRA hospital and outpatient requirements.
  • Familiar with ETL (Extract, Transform, Load) processes.
  • Able to pull data from numerous sources and build reports that are both accurate and meaningful.
  • Knowledge of process redesign.

Experience:     

  • Two (2) years experience with data analysis and statistics related projects.
  • Experience managing small projects with defined duration and scope

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.