Business Intelligence Developer

$83,595 - $133,744/Yr

EvergreenHealth - Kirkland, WA

Full-time - Mid Level

Kirkland, WA

Hospitals

About the position

As a Business Intelligence Developer at EvergreenHealth, you will play a crucial role in designing, developing, and maintaining business intelligence solutions that focus on data within the Epic ecosystem. This position requires a deep understanding of the data needs of clinical and operational stakeholders, as you will work closely with them to deliver actionable insights that drive decision-making and improve patient care. Your responsibilities will include developing and maintaining custom reports, dashboards, and data extracts using Epic's reporting tools such as SlicerDicer, Clarity, Caboodle, Radar, and Workbench. You will be involved in the entire report development life cycle, from requirements gathering to post-production support, ensuring that the solutions you create are effective and user-friendly. In this role, you will also provide training and support to end users on BI tools and reports, ensuring that they can effectively utilize the solutions you develop. Your expertise in building and maintaining custom data models, SlicerDicer filters, and SQL templates will be essential as you troubleshoot issues and optimize queries. You will be expected to have demonstrable advanced SQL skills, adept at creating and maintaining SQL stored procedures, views, and queries to extract and report on Clarity and Caboodle datasets. Additionally, you will join the Clinical Analytics team and collaborate with key clinical and business leaders to develop data analysis solutions and visualizations that optimize organizational performance. This includes configuring and testing Epic-released content, creating content to display Epic data, and maintaining the Analytics Catalog. You will also be responsible for building and maintaining data cubes, data extracts, and any third-party BI tools, while working with business stakeholders to define ongoing data and analytics requirements. Your ability to present solutions to multidisciplinary teams and communicate complex technical issues to a non-technical audience will be vital for success in this position.

Responsibilities

• 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.
• 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.
• 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.

Requirements

• 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.

Nice-to-haves

• 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.
• Understanding of Nova and Epic Upgrades, completing notes as needed.
• Experience working with Azure DevOps services and tools.

Benefits

• 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