Business Intelligence Developer

Wage Range: $83,595 - $133,744 per year

Posted wage ranges represent the entire range from minimum to maximum. For jobs with more than one level, the posted range reflects the minimum of the lowest level and the maximum of the highest level. Some positions also offer additional premiums based on shift, certifications or degrees. Job offers are determined based on a candidate's years of relevant experience, level of education and internal equity.

• Develop and maintain custom reports, dashboards, and data extracts using Epic’s reporting tools (SlicerDicer, Clarity, Caboodle, Radar, Workbench, etc.).
• Familiar with the entire report development life cycle, from requirements gathering to post-production support.
• Great communication skills are a must, in support of transparent dialogue with operational partners, regardless of technical acumen.
• Provide training and support to end users on BI tools and reports.
• Experience building and maintaining custom data models, SlicerDicer filters, Cogito SQL templates and custom SQL metrics.
• Excel at building, maintaining, and troubleshooting Reporting Workbench templates and reports, creating dynamic filtering, utilizing extensions and rules to drive reporting and dashboard content.
• Familiarity with Dimensional Data Models, DMC’s, star schema, and data modeling. Experience troubleshooting missing data, Caboodle warnings and error logs, understanding backfill/resets, and investigating data lineage.
• Understanding of Nova and Epic Upgrades, completing notes as needed.
• Partner with teammates to complete peer reviews, optimize queries, act as data stewards and SME’s for one another and the organization, and encourages cross team collaboration in support of all operational goals.
• Demonstratable advanced SQL skills-adept at creating and maintaining SQL stored procedures, views, and queries to extract and report on Clarity and Caboodle datasets.

Job Summary

Joins the Clinical Analytics team at EvergreenHealth and works collaboratively with key clinical and business leaders to develop data analysis solutions and visualizations to optimize organizational performance and to support strategic initiatives and planning.  Works closely with business stakeholders to gather requirements for and develop innovative and complex analytical solutions to support data-driven decision-making across the organization.

Primary Duties:

• Configures and tests Epic-released and Foundation System content for all applications, including:
• Reporting Workbench
• SlicerDicer data models
• Radar dashboards
• Cogito SQL    
• Creates content to display Epic data from Chronicles, Clarity, and Caboodle.
• Writes SQL and configuring Radar settings for custom SQL metrics.
• Modifies existing reports, as necessary.
• Distributes analytics content to data consumers.
• Reviews peer reports for validity.
• Works with subject matter experts to understand the needs of data consumers.
• Maintains the Analytics Catalog and associated metadata records.
• Tests analytics build in a specified testing environment and volume testing in live environments.
• Reviews upgrade documentation related to Clarity and Caboodle features and determines how to implement the changes.
• Responsible for building and maintaining data cubes, data extracts, SlicerDicer custom filters, and any third-party BI tools.
• Works with business stakeholders across the organization to define ad-hoc and ongoing data and analytics requirements.
• Designs, develops, and maintains scalable, automated, user-friendly data solutions (views, queries, reports, visualizations, dashboards) to support the organization’s analytical and business needs.
• Develops and troubleshoots complex code for data retrieval and automated/scheduled data flows and processes.
• Use analytical and statistical knowledge and skills to solve c