Business Intelligence Developer - Analytics Kirkland, Washington | Department: Clinical Informatics | Job Type: Full-Time |

Description

Wage Range: $89,565 - $143,270 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.

Join EvergreenHealth's Analytics team and help transform data into meaningful insights that support patient care, operations, and strategic decision-making. In this role, you'll partner closely with clinical and business leaders to design and deliver innovative analytics solutions, leveraging Epic tools (Reporting Workbench, SlicerDicer, Radar, Cogito) and non-Epic along with SQL and enterprise BI platforms.

You'll build and optimize reports, dashboards, and data solutions; ensure data accuracy and reliability; and contribute to a growing analytics environment focused on collaboration, continuous improvement, and strong data stewardship.

This is a great opportunity for someone with strong SQL and BI experience who enjoys solving complex problems, working across teams, and delivering insights that make a real impact.

If this sounds like you-please apply! This is an amazing opportunity to help turn data into trusted insights that support better decisions that support patient care and operations.

Key Responsibilities:

• At least 5 years Epic Cogito Caboodle custom development experience.
• Certifications in Epic Cogito, Caboodle, Cogito Tools Admin highly desired, with verifiable build experience.
• Demonstratable expert level SQL skills including windows functions in SQL. Adept at creating and maintaining SQL stored procedures, views, and queries to extract and report on Clarity and Caboodle datasets.
• Experience with query tuning and optimization.
• 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 Cognitive Computing Models and Predictive Analytics Models that are part of Epic's suite of tools.
• Experience troubleshooting missing data, Caboodle warnings and error logs, understanding backfill/resets, and investigating data lineage.
• Develop custom Data Models, DMC's, and Radar content using both Cogito SQL Templates and SQL based content.
• Familiarity with Epic's main application workflows (Ambulatory, Acute, OpTime, etc.).
• Understanding of Nova and Epic Upgrades, completing notes as needed.
• Conduct peer reviews and provide coaching on coding best practices.
• 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.
• Partner with teammates to optimize queries, act as data stewards and SME's for one another and the organization, and encourage cross team collaboration in support of all operational goals.

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 complex problems and drive business decisions
• Create and maintain a positive and collaborative working environment
• 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.
• Provide training and support to end users on BI tools and reports
• Performs other duties as assigned.

Required for this Position:

• Associate Degree in Computer Science, Business Systems, Health Information Management, or other related field, or equivalent education/experience.
• 4 years of related experience. Education/training can be substituted.
• Epic certification in area of support or certification within 3 months of hire
• Advanced knowledge of relational database design and analysis.
• Experience working with and developing queries using SQL (or equivalent languages).
• Experience building and supporting Business Intelligence solutions, including ETL development and data discovery.
• Experience with data visualization tools like Tableau, Power BI, or similar BI tools and dashboard/scorecard development.
• Ability to understand data structures that could benefit the entire data model.
• Ability to present solutions to multidisciplinary teams and organizational leadership groups.
• Well-developed written and verbal communication skills, including ability to communicate complex technical issues to a non-technical audience.
• Strong quantitative and analytic skills.
• Proven attention to detail and ability to think creatively and work collaboratively in a rapidly-changing environment.
• Ability to independently research and perform analysis to resolve complex issues

Desired for this position:

• Bachelor's Degree in Computer Science, Business Systems, Statistics, Health Information Management, or other related field, or equivalent education/experience.
• Experience working with healthcare and financial data utilizing forecasting, predictive modeling, and/or machine learning applications.
• Experience incorporating statistical methods into outcomes reporting.
• Experience working with and incorporating multiple sources of data to answer complex financial and clinical questions.
• Familiar with the entire report development life cycle, from requirements gathering to post-production support.
• 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.
• Demonstratable advanced SQL skills-adept at creating and maintaining SQL stored procedures, views, and queries to extract and report on Clarity and Caboodle datasets.
• Experience working with Azure DevOps services and tools.

Benefit Information:

Choices that care for you and your family

At EvergreenHealth, we appreciate our employees' commitment and contribution to our success. We are proud to offer a suite of quality benefits and resources that are comprehensive, flexible, and competitive to help our staff and their loved ones maintain and improve health and financial well-being.

• Medical, vision and dental insurance
• On-demand virtual health care
• Health Savings Account
• Flexible Spending Account
• Life and disability insurance
• Retirement plans (457(b) and 401(a) with employer contribution)
• Tuition assistance for undergraduate and graduate degrees
• Federal Public Service Loan Forgiveness program
• Paid Time Off/Vacation
• Extended Illness Bank/Sick Leave
• Paid holidays
• Voluntary hospital indemnity insurance
• Voluntary identity theft protection
• Voluntary legal insurance
• Pay in lieu of benefits premium program
• Free parking
• Commuter benefits

View a summary of our total rewards available to you as an EvergreenHealth team member by clicking on the link below.

EvergreenHealth Benefits Guide