Business Intelligence Developer - EPIC

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