Business Intelligence Engineer

Strategic Healthcare Programs (SHP) is a leading provider of analytics and performance management solutions for the post-acute healthcare market. We are an industry leader in helping Home Health, Hospice, and Skilled Nursing providers improve their financial and quality performance while complying with many regulatory requirements. Additionally, we connect the post-acute world to the broader provider markets to allow for optimal management across the continuum of care.

We are seeking a talented individual to join our company as a Business Intelligence Engineer. As part of our Business Intelligence team, you will develop embedded product solutions that transform healthcare data into actionable insights for over 10,000 Home Health, Hospice, and Skilled Nursing providers.

This is a remote or hybrid position within the United States. Employees living within 75 miles of the Santa Barbara office are required to work in-person in the office every Wednesday.

Duties and Responsibilities

Build and maintain robust and scalable BI tools using Microsoft Reporting Services, Web-based dashboarding tools

Develop infrastructure in both relational and multidimensional environments

Develop tune and troubleshoot queries against large data stored in SQL Server with a focus on performance and scalability

Collaborate with stakeholders and business analysts to understand requirements and formulate use cases

Coordinate with Software Test Engineers on unit, integration, and regression testing using SHP’s proprietary report testing framework

Explore ways to improve existing products to increase ease-of-use, actionable insights and overall customer value

Participate in a scrum team to scope, size, and execute stories in a collaborative fashion

The position is remote with optional travel to Santa Barbara, CA one to two times per year

Required Skills & Qualifications

5+ years of experience in the Microsoft Reporting Services

5+ years data wrangling and data analysis using SQL

5+ years using a source control management system such as Perforce, Git, TFS, SVN

Experience with a formal SDLC process

Microsoft SQL Server 2017 or later

Experience developing dashboards with products such as PowerBI or Tableau

Ability to perform analytics on structured and unstructured data

Ability to independently monitor, troubleshoot, and tune performance of SQL Server queries and SSRS report executions

Experience with large datasets (hundreds of millions of rows)

Understand Unit, Functional, Performance, and Regression testing

Excellent written and verbal communication skills

Excellent organizational skills

Bachelor’s degree in computer-related field

Healthcare experience is a plus

Pay

$100,000. - $140,000. annual, depending upon experience.

Benefits

We value work/life balance. We offer comprehensive health benefits, a 401(k) plan with a company match, an employee stock purchase plan, vacation time, sick time, and paid holidays.

This position is not eligible for immigration sponsorship.