Exciting new contract opportunity with an established firm. This is a hybrid role with 2-3 days work/week on site in San Francisco, CA or Oakland, CA.
Senior Epic BI Developer
Job Description:
As a Senior Epic System Analyst - Reporting and Analytics, you will play a key role in designing, developing, and optimizing reporting and analytics solutions within the Epic EHR environment. The ideal candidate will bring a deep understanding of Epic reporting tools, data structures, and analytics to enhance decision-making processes and support our organization's commitment to data-driven healthcare.
Responsibilities
Driving the analytics implementation to meet organizational goals and initiatives
Measuring ongoing success of analytics after go live and making necessary adjustments
Reviewing upgrade documentation related to analytics tools and content and determining how to implement, disseminate, and train the changes
Assisting the Business Intelligence Developers in identifying the right solution for each request
Configuring and testing Epic released and Foundation System content for all applications, including Reporting Workbench, Slicer Dicer, Radar, Cogito SQL
Creating content to display Epic data from Chronicles, Clarity, and Caboodle
Writing SQL and configuring Radar settings for custom SQL metrics
Creating new reports and Modifying existing reports, as necessary
Distributing analytics content to data consumers
Reviewing peer reports for validity
Working with subject matter experts to understand the needs of data consumers
Maintaining the Analytics Catalog and associated metadata records
Testing analytics build in a specified testing environment and volume testing in live environments
Reviewing upgrade documentation related to Cogito features and determining how to implement the changes BIDs might also be responsible for building and maintaining:
Cubes Extracts
Slicer Dicer custom filters
Third party BI tools
Epic data in Caboodle
Analyzing non Caboodle datasets to identify required data elements to be moved into Caboodle
Mapping non Epic datasets to existing database structures within Caboodle
Designing and developing custom database structures within Caboodle as needed
Coordinating the implementation and long term support activities related to aggregating claims from the external payer sources into Caboodle.
Skills/Experience: Required skills
3+ years of Epic Data Architecture and Integration experience
10+ years focused technical work within a data and ETL
Expert knowledge of Epic modules, terminology, data stores (Chronicles, Clarity, Caboodle) and Hyperspace self-service reporting tools including Reporting Workbench, Slicer Dicer models and Radar Dashboards.
Strong working knowledge of healthcare interoperability standards (HL7, FHIR, CCDs etc.)
Experience performing data discovery, analysis, and profiling
Experience creating logical source-to-target mappings which data can use
Experience designing and building solutions that ingest data via APIs
Very strong SQL query language skills
Business and technical requirements elicitation, analysis, and elaboration experience
Excellent verbal and written communication skills
Strong consulting, problem-solving, and customer relationship skills
Ability to navigate HL7, CDA, and flat file formatted data
Required Skills:
Leading, coordinating, and facilitating effective meetings
Strong communication skills
User focused design and data visualization skills
Proficiency with SQL and relational database concepts
Proficiency and demonstrated experience with analytics tools
Familiarity with Epic applications and database structure, through training that occurs early in the implementation
Ability to gain an in depth understanding of the data model through data model classes geared toward content areas
Ability to understand data structures that could benefit the entire data environment
For financial reporting: Prior experience working with an AR system is desirable, but not required
For clinical reporting: Prior experience working with an EMR system is desirable, but not required
Understanding of system build, end user workflows, and patterns of use
Desired Skills:
Certifications
Access Data Model Certification
Clinical Data Model Certification
Revenue Data Model Certification
Cogito Fundamentals Certification
Cogito Tools Administration
Badges for Radar SQL Metrics, Slicer Dicer Custom Build, and Cogito SQL