Healthcare BI Engineer - SQL Server, ETL & Data Warehousing

CHAS Health; Spokane (WA); On-site; USD 41,396 - 60,793; Full time

Benefits offered by this job

Annual bonus

Health insurance

401(k) match

Paid time off

Tuition assistance

Childcare reimbursement

CME & license reimbursement

Job summary

CHAS Health in Spokane, WA is seeking a Database/BI Engineer to design and optimize data solutions. You will develop ETL processes, OLAP cubes, and data warehouses using SQL Server, SSIS, and SSAS to support reporting and patient care.

The role requires an Associate’s degree or commensurate experience, strong problem-solving and communication skills, and the ability to work on multiple deadlines in a high-availability environment. Travel and license requirements as appropriate for the role.

Qualifications

• Associate’s degree or commensurate experience in a technical field required.
• Experience with Microsoft SQL Server, SSIS, and SSAS for BI/data warehousing.
• Ability to design data solutions and optimize queries in healthcare data models.
• Strong problem-solving and verbal/written communication skills.

Responsibilities

• Designs and implements databases, ETL routines (using SSIS), stored procedures, and OLAP solutions, providing support and enhancements to existing data solutions.
• Designs and builds normalized and denormalized database solutions using healthcare industry best practices for data warehousing for specific client requirements, using Microsoft SQL Server database programming.
• Works on multiple concurrent deadline-driven projects while ensuring data quality and meeting service level agreements.
• Builds and maintains cubes (internal and client-facing).
• Optimizes database schemas, queries, cubes, and reports, implementing complex logic requirements.
• Conducts tuning reviews/assessments (DB and SQL tuning), reporting, and query monitoring.
• Determines, enforces, and documents database policies, procedures, and standards.
• Performs other duties as assigned, including supporting the CHAS Health mission and core values.

Skills

SQL Server

SSIS

SSAS

ETL

Data warehousing

Problem solving

Communication

Education

Associate's degree or commensurate experience

Tools

SSIS

SSAS

SQL Server

Job description

CHAS Health in Spokane, WA is seeking a Database/BI Engineer to design and optimize data solutions. You will develop ETL processes, OLAP cubes, and data warehouses using SQL Server, SSIS, and SSAS to support reporting and patient care.

The role requires an Associate’s degree or commensurate experience, strong problem-solving and communication skills, and the ability to work on multiple deadlines in a high-availability environment. Travel and license requirements as appropriate for the role.