Business Intelligence Engineer (On-Site)

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

Competitive Compensation & Exceptional Benefits At CHAS Health

Join a workforce that values your expertise as much as your wellbeing! CHAS Health’s comprehensive compensation package includes:

• Annual milestone bonus for all eligible employees: $500 for every year worked, up to $5,000.
• Robust health coverage with employer‑offered medical, dental, vision, long‑term care, and life insurance.
• 401(k) with up to 6% employer match.
• More than six (6) weeks of paid time off for full‑time employees.
• Tuition assistance and student loan repayment.
• Up to $7,500 for childcare annually through reimbursement.
• CME and license fee reimbursement.
• Benefits eligibility dependent on employee criteria.

Compensation Range

$30.05 - $44.13 per hour

Purpose of Job

Improves the overall health of the communities we serve by providing superior customer service and advanced technical support to ensure quality patient care and user satisfaction.

Essential Duties And 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.

Qualifications

Education/Experience: Associate’s degree or commensurate experience in a technical field required. Prior experience in database development using Microsoft SQL Server, SSIS and SSAS preferred; understanding performance, deployment, configuration, security, migration, and troubleshooting, as well as proficiency in building and optimizing SQL queries preferred. Previous experience building and supporting business intelligence/data warehousing solutions and knowledge of healthcare data models preferred.

Skills: Excellent logical and problem‑solving abilities, verbal and written communication skills required. Ability to work independently in a self‑directed environment, contribute to a team, maintain a positive attitude, demonstrate very high attention to detail, and commitment to quality while working in a high‑availability environment is required. Commitment to supporting a safe and respectful environment is required. Valid driver’s license and insurance required.

Physical Demands

Required to stand, sit, and be mobile up to two‑thirds of the time. Required to read from text and computer screen over two‑thirds of the time. Climbing or balancing, stooping, kneeling, or crouching occurs less than one‑third of the time. Communicating occurs constantly throughout the day. Lifting occurs about half the time up to 10 lbs, and less than one‑third of the day from 25-40 lbs. Rarely is there a need to lift more than 41 lbs.

Core Values

• Social Responsibility
• Patient‑Centered
• Entrepreneurship
• Respect for Human Dignity
• Commitment to Continuous Quality Improvement
• Fun

Equal Employment Opportunity

In order to provide equal employment and advancement opportunities to all individuals, employment decisions at CHAS Health will be based on merit, qualifications, and abilities. CHAS Health does not discriminate in employment opportunities or practices on the basis of race, color, religion, gender, gender identity and expression, sexual orientation, national origin, age, disability, or any other characteristic protected by law.