
Business Intelligence Engineer
Strategic Healthcare Programs (SHP)
full-time
Posted on:
Location Type: Hybrid
Location: Santa Barbara • California • United States
Visit company websiteExplore more
Salary
💰 $100,000 - $140,000 per year
Tech Stack
About the role
- 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
Requirements
- 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
Benefits
- comprehensive health benefits
- 401(k) plan with a company match
- employee stock purchase plan
- vacation time
- sick time
- paid holidays
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
Microsoft Reporting ServicesSQLdata wranglingdata analysisPowerBITableauSQL Server 2017performance tuningunit testingregression testing
Soft Skills
written communicationverbal communicationorganizational skillscollaborationstakeholder engagement