InterviewStack.io LogoInterviewStack.io
Browse more Business Intelligence Analyst jobs

Senior SQL & Power BI Analyst

OrthoMed Anesthesia

ADDISON, TX 750014 months ago
84 views34 saves8 applies

Prepare for this role


Benefits

Health Insurance

Job Type

full time

Description

Location: Addison, TX (On-Site)

*No Agencies*

*Candidates must be eligible to work in the U.S. without employer sponsorship.*

Position Overview

We are seeking a hands-on data analyst with strong SQL and Power BI expertise to support healthcare operational and financial reporting. This role is responsible for building governed, reconciled, drillable reporting that leadership can rely on for decision-making.

This is not a dashboard-only role. The ideal candidate understands healthcare data structures, data validation discipline, and how to design models that produce accurate, defensible reporting.


Core Requirements (Must-Have)

1. Advanced SQL (Primary Skill)

  • Write complex SQL queries across multiple tables (joins, CTEs, aggregations, subqueries)
  • Validate and reconcile data against source systems
  • Optimize queries for performance
  • Ensure accuracy of financial and operational reporting outputs

2. Strong Power BI Development

  • Build semantic models and reports in Microsoft Power BI
  • Develop measures using DAX
  • Design well-structured data models (star schema preferred)
  • Enable drill-down and drill-through functionality for executive reporting
  • Create interactive reports supporting multi-level healthcare analysis

3. Healthcare Industry Experience

  • Experience working with healthcare data (clinical, operational, or financial)
  • Familiarity with healthcare systems such as EMR, practice management, or billing platforms
  • Understanding of healthcare reporting nuances and data sensitivity

4. Governance & Reconciliation Discipline

  • Reconcile report outputs to source systems
  • Validate totals before distribution
  • Document metric definitions and logic
  • Maintain reporting standards and controls

Additional Skills (Preferred)

  • Experience supporting finance or operations leadership
  • Familiarity with healthcare regulatory or compliance considerations
  • Exposure to ETL concepts or data pipeline workflows
  • Strong stakeholder communication skills

What Success Looks Like

  • Leadership can drill from summary metrics into transactional detail confidently
  • Reports consistently reconcile to source systems
  • Data models are structured, scalable, and maintainable
  • Reporting outputs are reliable and audit-defensible

This job is found at InterviewStack.io

Skills

sqlpower bietldata pipelinesfinancial reportingdata structures

About OrthoMed Anesthesia

OrthoMed Anesthesia was founded by a board certified Anesthesiologist to provide unrivaled anesthesia care and perioperative services. We are committed to providing excellent and efficient anesthesia care in any setting.

healthcare, medical servicesWebsite