Senior Epic Beaker EMR Report Developer

Summary

Join a dynamic team in the organization's Data and Analytics division to support the report development for the Epic Beaker implementation. Independently work with internal and external customers to understand and analyze requirements, develop reporting solutions, and lead technical expertise in design, development, testing, documentation, and maintenance of reporting solutions.

Requirements

• 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
• 5 years of progressively increasing responsible work experience with an emphasis in report development in clinical information applications and systems in health care
• 3 years of experience leading complex reporting initiatives
• 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
• 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

Responsibilities

• 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

Preferred Qualifications

• 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. -SlicerDicer