Epic EMR Developer (Must know Epic OpTime)

Epic EMR Developer (must know Epic OpTime)
Remote position

General Summary
Under minimal supervision, works with internal and external customers to understand and analyze requirements and develop reporting solutions. The EMR Report Developer will use third party report writing tools to create, design, develop, and maintain reports/ extracts generated from the Epic Medical Record System (EMR) from initial request through delivery. This position assists with and supports technical troubleshooting and issue resolution and general technical support. The Report Developer will 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, reports.

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:

• Develop and troubleshoot medium to complex SQL scripts, Crystal reporting, Caboodle, RW SQL and other reporting technologies from database resources to deliver custom reporting that meets the needs of the clinical or business unit.
• Build Universes/Cubes, Extracts, SlicerDicer, or third-party tools as needed.
• Completes thorough testing and validation of all reports prior to handoff for functional and/or end user testing.
• Documents and reports system issues through internal chain of command; communicates with vendor where appropriate.
• Gains an in-depth understanding of the Epic data model and determines data structures that benefits the entire reporting environment.
• Collects information regarding potential report enhancements and functionality needs. Prepares details of specifications as needed.
• Applies proven communication, analytical and problem-solving skills to help identify, communicate and resolve report issues to maximize system potential.
• Prioritizes and implements requested reports and changes and analyzes new functionality in releases to determine how it should be used.
• Maintains regular communication with Epic representatives, organization's Application teams and works with the Epic representatives and the organization's end user community/Clinical Informatics to ensure that the reports meet the organization???s needs.
• Provides application support and guidance to end-users and provides technical guidance to less experienced personnel and support staff. Provides end user support during implementation or upgrades. Serves as a point of contact for resolution of complex application problems.
• Follows team standards, report 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 tasks within the ticket queue.
• Serves as a member of cross-functional teams to achieve goals of BI (and broader Data & Analytics) projects, including work plans, system design, and testing of solutions.
• Assists project sponsors/end users in the interpretation and use of the results; ensures that the data is understood by users.
• Prepares supporting documentation, reports, and presentation materials.
• Creates ad-hoc queries and reports as requested and provides ongoing analytical support for these requests.
• Develops healthcare subject matter expertise related to specific products, data elements, business processes, data marts, and applications.
• Conducts and/or participates in in-service and various educational programs for professional development. Orients, and transfers knowledge to peers.
• Modifies existing reports as necessary, creates design specifications for new reports and identifies and validates the appropriate technological solutions for various reporting needs.
• Conducts report build testing in a specified testing environment and volume testing in live environments.
• Reviews upgrade documentation related to reporting features and content, determines how to implement changes.
• Completes other duties and assumes additional project roles as assigned.

Qualifications

Required

• Bachelor's Degree in computer related field or 4 years in a computer related field.
• Epic Certification in a Clarity Data Model (Clinical, Access, or Revenue) or completion of Epic Certification within 3 months of training completion).
• 2+ years of experience:
  1. complex SQL code and an understanding of various database models.
  2. Reports, Web Intelligence, Universes, implementing hardware/software configuration as needed
  3. database extractions using data access/programming tools (such as SQL, Python)

• 1. design, problem analysis, and relational database concepts
• Must be proficient with technical assessment delivered by D&A team

Preferred

• Prior 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

• Basic exploratory analysis, demonstrating ability to make sense of the data, offer insights and critical analysis; determine the appropriate ensuing questions to ask, how to frame them, and how to approach them
• Critical thinking and decision making required.
• Familiarity with Epic or other integrated healthcare applications and database structure.
• Detail oriented with superior 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 work independently and in collaboration with other staff members.
• 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.
• Skilled in common data manipulation tasks such as reading CSV files, filtering contents, and producing output files in different formats.
• Create automation tasks to run and distribute data exports/reports on set schedules to hospital end-users.
• Understands and adheres to system security and control procedures in accordance with departmental and vendor standards as well as regulatory bodies 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.

Please send resumes to