What are the responsibilities and job description for the Senior SQL & Power BI Analyst position at OMS MEDICAL BILLING LLC?
Location: Addison, TX (On-Site)
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