Epic Resolute Business Intelligence Developer (Clarity & Caboodle)


 Business Intelligence (BI) Developer



Position Summary

Reporting to the Manager of Business Intelligence and Data Analytics, this Business Intelligence Developer (BID) will primarily work with Epic’s Clarity and Caboodle data associated with the Resolute-Hospital Billing module of Epic.  Other Epic modules supported by this position are Home Health Billing, Coding and Abstracting, Health Information Management (HIM) and Grand Central systems.  Business Intelligence solutions include Crystal reports, SQL data extracts, data visualizations, KPIs, Slicer Dicer solutions and Epic-based Dashboards.  This resource will work closely with the organization’s business analysts as well as clinical and administrative staff to ensure that business intelligence solutions deliver actionable insights to SSHS staff.

Qualifications

Candidates with pre-existing Epic BID certifications strongly preferred.  Epic Certification required for applications supported by this position within 9-12 months of hire if candidate does not already possess the necessary certification.  This certification training may require travel to Verona, WI.

Bachelor's degree required. BS in Computer Science, Business Management or Healthcare–related field strongly preferred.  Two (2) to five (5) years of experience working with data extraction methodologies and reporting tools in a variety of healthcare information systems.
Epic report writing skills required.  Two (2) to five (5) years of experience working with T-SQL language including knowledge of principles of database design, data acquisition and data access. Knowledge of stored procedure writing, query optimization, and indexes required.  
Demonstrated proficiency working with Epic data structures, data analysis/interpretation and transforming raw Epic data into finished business intelligence products.
Possesses knowledge of multiple data analytic and reporting tools such as Crystal Reports, T-SQL, Cubes, SAP Web Intelligence, PowerBI, etc.  Knowledge of Qlik data visualization tools a plus.  Experience working with and/or supporting Epic’s data warehouse and data universes preferred.  Ability to interpret and write SQL queries.  Ability to develop and test SSIS packages preferred.  Familiarity with various types and sources of health care information including financial and patient-level data files.  Strong working knowledge of hospital operations and healthcare industry drivers.  Proficiency with MS Office Suite required.