Business Intelligence Developer

Wage Range: $83,595 - $133,744 per yearPosted 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, certificationsor degrees. Job offers are determined based on a candidate's years of relevant experience, level of education and internal equity.• **This position requires you live in the State of Washington***As a Business Intelligence Developer, you will be responsible for designing, developing, and maintaining business intelligence solutions, focusing on data within the Epic ecosystem. You will work closely with clinical and operational stakeholders to understand their data needs and deliver actionable insights that drive decision-making and improve patient care.Key Responsibilities:• Develop and maintain custom reports, dashboards, and data extracts using Epics 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, DMCs, 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 SMEs 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 SummaryJoins 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 organizations 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 SMEs 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 issuesDesired 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, DMCs, 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 familyAt 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 benefitsView a summary of our total rewards available to you as an EvergreenHealth team member by clicking on the link below.2024 Benefits GuidePlease see job descriptionPI244514536