Senior Epic Beaker EMR Report Developer-Remote - University of Maryland Medical System

The University of Maryland Medical System (UMMS) is an academic private health system, focused on delivering compassionate, high quality care and putting discovery and innovation into practice at the bedside. Partnering with the University of Maryland School of Medicine, University of Maryland School of Nursing and University of Maryland, Baltimore who educate the state's future health care professionals, UMMS is an integrated network of care, delivering 25 percent of all hospital care in urban, suburban and rural communities across the state of Maryland. UMMS puts academic medicine within reach through primary and specialty care delivered at 11 hospitals, including the flagship University of Maryland Medical Center, the System's anchor institution in downtown Baltimore, as well as through a network of University of Maryland Urgent Care centers and more than 150 other locations in 13 counties. For more information, visit www.umms.org.

General Summary

The primary focus of this job will be to support the report develop for the Epic Beaker implementation.   Independently work with internal and external customers to understand and analyze requirements and develop reporting solutions using underlying technologies and will lead, and provide technical expertise in the design, development, testing, documentation and maintenance of reporting solutions for the University of Maryland Medical System. Use third party report writing tools to create, design, develop, and maintain reports/extracts generated from the Epic Electronic Medical Record (EMR) from initial request through delivery. This will include preliminary conversations with end users for requirements gathering, data extractions from relevant databases, testing and validation, documentation, presentation. Decipher how best to engage in priorities by soliciting and leveraging the entire breadth of expertise of the Enterprise Data and Analytics team, including understanding how the team can best contribute to the engagement. Demonstrate a high level of critical thinking and analytical skills and excellent oral and written communication skills. Facilitate design and technical meetings. Contribute and adhere to data governance efforts including definitions, implementation, and organization. The appropriate organizational resources will be utilized to analyze and interpret any and all clinical, financial, market, and quality data including but not limited to inpatient, outpatient, service line, operational, revenue, billing, receivable, and statistical reports. This is an opportunity for highly motivated individual to mentor and provide leadership and technical expertise to a dynamic team in the organization’s Data and Analytics division in support of the organization’s imperative to become a data-driven and outcomes-oriented organization.

Principal Responsibilities and Tasks

The following statements are intended to describe the general nature and level of work being performed by people assigned to this classification. These are not to be construed as an exhaustive list of all job duties performed by personnel so classified:

· Demonstrate expert level knowledge and ability to develop unique reporting solutions for the Epic Beaker product 

· Act as a liaison to site executives, UDCs, and other committees to ensure thorough understanding of organizational strategic and operational objectives.

· Develop health care subject matter expertise related to specific products, data elements, business processes, data marts, and reporting applications.

· Mentor report developers to improve technical skills and provides technical guidance to less experienced personnel. Acts as a resource for Epic data model, SQL and/or Crystal.

· Lead the development and validate test plans for solutions, applications and/or operating systems.

· Triages and prioritizes data requests and seeks understanding of technical requirements.

· Troubleshoot highly complex SQL scripts using Crystal reports, RW SQL or other reporting technologies from database resources to deliver custom reporting that meets the needs of the clinical or business operations.

· Build complex Universes, Extracts or third-party tools as needed.

· Complete thorough testing and validation of all reports prior to handoff for functional and/or end user testing using best practices.

· Document and report system issues through internal chain of command; communicates with vendor where appropriate.

· Gain an in-depth understanding and demonstrate expertise in multiple Epic data models, with ability to determines data structures that benefits the entire reporting environment. Technical development of complex reports, applications and ability to drive unique solutions.

· Apply proven communication, analytical and problem-solving skills to help identify, communicate and resolve report issues to maximize system potential.

· Demonstrate a high level of critical thinking and analytical skills with as expert level understanding of relational database/BI environments and related technologies.

· Prioritize and implement requested reports and changes and analyzes new functionality in releases to determine how it should be used and access value and plan for implementation.

· Maintain regular communication with Epic representatives, UMMS Application teams and works with the Epic representatives and UMMS' end user community/Clinical Informatics to ensure that the reports meet the organization’s needs.

· Lead support during implementation or upgrades; able to serve as a report expert to assist in application roll-out.

· Follow and promote team standards, development methodology and processes for specification, implementation, testing, change management, distribution, and documentation of reports. Updates ticket tracking system with routine status updates and manages ticket queue.

· Leads cross-functional teams to achieve goals of BI (and broader Data & Analytics) projects, including work plans, system design, and testing of solutions.

· Conduct and/or participates in in-service and various educational programs for professional development. Orients, and transfers knowledge to peers.

· Completes other duties and assumes additional project roles as assigned.

Qualifications

Required

· Bachelor's Degree in computer related field or 8+ years working in a computer related field

· At least 7 (seven) years of report development experience:

o 5 years of progressively increasing responsible work experience with an emphasis in report development in clinical information applications and systems in health care

o 3 years of experience leading complex reporting initiatives

o At least 7 (seven) years of reporting experience in a working environment developing medium to complex reports using SQL in reporting applications such as Crystal, Web Intelligence, Universes, implementing hardware/software configuration as needed

o At least 7 (seven) years building database extractions using data access/programming tools (such as SQL, Python).

· Epic Certification in a Clarity Data Model (Epic Beaker or Clinical Data model) or must be obtained Certification within 3 months of training completion.

· Ability to generate highly complex optimized SQL code and an understanding of various database models.

· Proven knowledge of database design, problem analysis, and relational database concepts in a working environment.

· Must be proficient with technical assessment delivered by D&A team

Preferred

· Master’s Degree with experience in healthcare including business and clinical aspects.

· Prior experience with one or more of the following EMR systems: Epic, Cerner, Meditech, etc.

Knowledge, Skills and Abilities

· Advanced critical thinking and decision making required.

· Proven ability as a lead or project manager.

· Ability to facilitate meetings with clear objectives and gain consensus across a variety of stakeholders.

· Able to write advanced, optimized SQL queries and develop highly complex reports using a variety of reporting tools

· Knowledgeable with Epic or other integrated healthcare applications and database structure.

· Detail oriented with excellent written and verbal skills. Reads and interprets written information, listens and receives clarification, and demonstrates group presentation skills.

· Highly analytical and motivated with demonstrated creativity and organizational skills. Able to analyze, compare, contrast, and validate work with keen attention to detail.

· Ability to lead and collaborate with other staff members

· Proven ability to assess user needs, perform data discovery, exploration, and interpretation to determine appropriate system applications or requirements. Serves as a resource to others in the resolution of complex problems and issues.

· Capable of artful storytelling and clearly presenting finding in oral and written format and through graphics.

· Understands and promotes adherence to system security and control procedures in accordance with departmental and vendor standards as well as regulatory bodies. Supervises, teaches, and monitors compliance.

· Assesses own strengths and weaknesses; pursues training and development opportunities. Strives to continuously build knowledge and skills; shares expertise with others.

· Exhibits impeccable customer service skills; manages difficult situations and responds promptly to customer needs. Solicits customer feedback to improve service.

.