Job Description

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.