Data & BI Engineer

About Us

We are Health Catalyst , a leading provider of data and analytics technology and services to healthcare organizations. Our mission is to be the catalyst for massive, measurable, data-informed healthcare improvement. We partner with health systems, hospitals, and other healthcare entities to help them use data to make smarter decisions, improve clinical outcomes, reduce costs, and enhance patient experience. Joining Health Catalyst means becoming part of a team dedicated to transforming healthcare through innovation, collaboration, and a relentless focus on value.

Be part of a world class team responsible for:

The Data & BI Engineer designs and maintains scalable data solutions and delivers actionable insights through BI and AI‑augmented analytics. This role combines data engineering expertise with visualization and reporting skills to ensure reliable, governed data flows into descriptive, predictive, and prescriptive insights. Working closely with stakeholders, the engineer bridges business needs with technical solutions to drive measurable healthcare improvements. This role at BSWH will primarily use Health Catalyst’s Ignite (Databricks) platform and Power BI to support the Acute Clinical analytics team.

What you'll own in this role:

• Acquire, integrate, and validate data from multiple sources for accuracy and consistency.
• Design and maintain data marts, semantic models, and ETL/ELT pipelines for analytics and reporting.
• Build and optimize BI dashboards and AI‑driven visualizations, ensuring explainability and governance compliance.
• Collaborate with stakeholders to translate goals into technical specs, define metrics, and align outputs with business value.
• Monitor data quality and detect anomalies using AI‑augmented techniques.
• Optimize SQL and troubleshoot complex data issues to maintain performance and stability.
• Ensure compliance with security, privacy, and ethical AI standards (e.g., HIPAA).

The acute clinical focus:

Metrics like the following enable acute clinical analytics teams to monitor performance, optimize operations, support clinician workflows, and improve patient outcomes, with growing emphasis on AI-enabled detection and prediction. These metrics are real-world examples but not an exhaustive list.

Clinical Quality & Patient Outcomes

• Readmission Rate – % of patients returning within 30 days post-discharge.
• Mortality Rate – risk-adjusted in-hospital mortality.
• Average Length of Stay (ALOS) – efficiency and care pathway optimization.
• Hospital-Acquired Infection & Safety Events – infection rates and safety incidents.

Operational Efficiency

• ED Wait Time / Door-to-Treatment – time from arrival to clinician.
• Bed Occupancy & Turnover Rate – inpatient capacity utilization.
• Time-to-Result Metrics – turnaround for labs or diagnostics.

Workflow & Clinician Behavior

• Clinical Decision Support (CDS) Usage – adherence to guidelines.
• Variation in Care Practices – identify outliers in treatment paths.

Utilization & Resource Management

• Procedure Volumes & Cost per Procedure – track service volumes and cost-efficiency.

Patient Experience

• Patient Satisfaction / NPS – perception of care and operational touchpoints.

Emerging AI-Driven Focus

• Predictive Alerts for High-Risk Events – readmission, deterioration, sepsis.
• Anomaly Detection – identify abnormal care patterns early.

What you bring to the role:

• Proficiency in SQL and relational database principles.
• Experience with ETL, data integration, and troubleshooting.
• Strong analytical and problem‑solving skills.
• Familiarity with cloud platforms (Azure preferred).
• Ability to communicate effectively with technical and non‑technical stakeholders.
• Experience with BI tools (Power BI, Tableau), semantic modeling, and DAX optimization.
• Understanding of AI‑augmented analytics and explainability in healthcare contexts.

You may also bring:

• Experience with T‑SQL, SSIS, or Azure Data Factory.
• Knowledge of HL7, CCD, and EDI X12 claims processing.
• Familiarity with Agile/Scrum methodologies.
• Exposure to Databricks, Generative AI, and conversational analytics.
• Git and version control proficiency.

Preferred Experience & Education:

• Bachelor’s degree in Data Science, Computer Science, Information Technology, Statistics, or related field.
• 2+ years in data engineering and BI roles, ideally in the acute clinical healthcare domain.

Information Security and Compliance:

• Maintain compliance with organizational security policies and HIPAA regulations.
• Follow data governance and ethical AI guardrails, including proper handling of PHI/PII.

Equal Employment Opportunity:

• Equal Employment Opportunity has been, and will continue to be, a fundamental principle at Health Catalyst, where employment is based upon personal capabilities and qualification without discrimination or harassment on the basis of race, color, national origin, religion, sex, sexual orientation, gender identity, age, disability, citizenship status, marital status, creed, genetic predisposition or carrier status, sexual orientation or any other characteristic protected by law. Health Catalyst is committed to a work environment where all individuals are treated with respect and dignity.