Epic Data and Reports Analyst - SQL

Location: Burlington, MA
Job ID: 167624-1A
Date Posted: May 27, 2021
Category: Information Services

Save Job Job Saved

Job Description

Welcome To

Welcome to Shared Services, our team uses a coordinated approach to delivering administrative and operational services across Lahey. Our Shared Services colleagues leverage resources across the organization to ensure we provide high-quality, high-value care to the communities we proudly serve.  The Shared Services team includes colleagues who focus on business and network development, legal services, facilities and real estate, human resources, information technology, finance, philanthropy and marketing and communications.

 

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:

 

 

  1. 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.

  2. 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

  3. Documents detailed specifications for each report including both the technical specifications and a summary of the report.

  1. 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

  1. Provides end user support pertaining to reporting during implementation; able to serve as a reporting expert to assist in application roll-out

  1. Create and edit Stored Procedures, Views, Functions and Queries on SQL Server to pull require data for reporting purposes using SQL Server Management Studio.

  2. 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.

  3. Configure and create packages for report distribution using Microsoft SQL Server Business Intelligence Development Studio’s Integration Services.

  4. Creates SharePoint sites, lists, libraries, calendars, web part pages, dashboards, etc.

  5. Creates Crystal Reports

  1. Documents and reports system issues to EHR Analytics & Reporting Manager 

  2. Proactively identifies and communicates barriers to completing work requirements

  3. Assists in the preparation of demo materials for workflow decisions or new system functionality

  4. Participates in on-call coverage as assigned by department lead/manager 

  5. Maintains confidentiality with regard to the information being processed, stored or accessed by the system.

  6. Achieves and maintains certification according to organizational standards 

  7. Applies proven communication, analytical and problem-solving skills to help identify, communicate and resolve system issues to maximize system potential

  8. Incorporates Lahey Clinic Guiding Principles , Mission Statement and Goals  into daily activities.  

  1. Complies with all Lahey Clinic Policies. 

  1. Complies with behavioral expectations of the department and Lahey Clinic.

  1. Maintains courteous and effective interactions with colleagues and patients.

  1. Demonstrates an understanding of the job description, performance expectations, and competency assessment.

  1. Demonstrates a commitment toward meeting and exceeding the needs of our customers and consistently adheres to Customer Service standards.

  1. Participates in departmental and/or interdepartmental quality improvement activities.

  1. Participates in and successfully completes Mandatory Education.

  1. Performs all other duties as needed or directed to meet the needs of the department.

 

 

 




 

Minimum Qualifications:

 

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.

 

Licensure, Certification, Registration:   None Required

 

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 

Experience with Crystal Reporting

About Us

Beth Israel Lahey Health is dedicated to improving health and wellness and making a difference in the lives of our patients, their families and all members of the communities we serve.  Formed in March 2019, Beth Israel Lahey Health is a patient-centered, integrated care delivery system providing a continuum of services spanning academic, tertiary and community hospitals, dedicated orthopedic and psychiatric hospitals, primary and specialty care, community acute care, ambulatory care, behavioral services and home health.  Beth Israel Lahey Health Performance Network is a unified joint contracting and population health management organization, jointly governed by participating physicians and hospitals.

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