Develop reporting solutions from the Epic Medical Record System (EMR) to meet the needs of clinical or business units, troubleshoot technical issues, and adhere to data governance efforts.
Requirements
- Developing complex SQL code and an understanding of various database models.
- Crystal Reports, Web Intelligence, Universes, implementing hardware/software configuration as needed
- Building database extractions using data access/programming tools (such as SQL, Python)
- Database design, problem analysis, and relational database concepts
- Familiarity with Epic or other integrated healthcare applications and database structure.
- 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.
Responsibilities
- 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.
- Modifies existing reports as necessary, creates design specifications for new reports and identifies and validates the appropriate technological solutions for various reporting needs.
Other
- Under minimal supervision, works with internal and external customers to understand and analyze requirements and develop reporting solutions.
- 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).
- Prior experience in healthcare including business and clinical aspects.
- Detail oriented with superior written and verbal skills.
