Best Practices, Billing, Business Intelligence, Business Intelligence Software, Data Management, Data Modeling, Data Quality, Data Warehousing, Database Extract Transform and Load (ETL), Dimensional Modeling, Epic Clarity, Epic Radar, Epic Reporting, Epic Reporting Workbench, Epic Resolute (Patient Accounting), Healthcare, Mentoring, Microsoft SQL Server, Performance Metrics, Performance Tuning/Optimization, Power BI, Qlik, Reporting Dashboards, Revenue/Sales Reporting, SQL (Structured Query Language), SQL Server Integration Services (SSIS), Snowflake Schema, Star Schema, Stored Procedures, Tableau
Piper Companies is seeking a Sr. Business Intelligence Developer to join a leading healthcare organization with locations in Allentown, PA and Fort Washington, PA. This is a hybrid role requiring 2 days onsite per week.
Responsibilities of the Sr. Business Intelligence Developer:
- Serve as the SME for Epic Revenue Cycle reporting and Epic Clarity Data Models (HB or PB).
- Design, develop, and optimize high‑complexity BI solutions across enterprise healthcare environments.
- Develop and maintain advanced SQL queries, stored procedures, and data pipelines, including performance tuning.
- Build dashboards and visual analytics using Power BI (preferred) or comparable BI tools.
- Support the organizations migration from Tableau/Qlik to Power BI.
- Collaborate with Data Engineering on BI architecture, ETL workflows, and data warehousing alignment.
- Ensure data quality, governance, and the standardization of BI outputs.
- Partner with revenue cycle leaders, operations teams, and reporting stakeholders to deliver actionable insights.
- Develop and maintain Epic Radar dashboards where appropriate.
- Mentor junior BI developers and contribute to BI best practices, modeling standards, and enterprise reporting strategy.
Qualifications / Requirements for the Sr. Business Intelligence Developer:
- Bachelors degree in a related field.
- Epic Clarity Data Model Certification - Revenue Cycle (HB or PB) REQUIRED.
- 5+ years of BI development or analytics experience in a healthcare environment.
- Advanced SQL expertise (CTEs, complex joins, stored procedures, indexing, optimization).
- Experience with data warehousing methodologies (star/snowflake schema, dimensional modeling).
- Power BI experience strongly preferred; Tableau/Qlik experience accepted if willing to transition.
- Demonstrated experience supporting revenue cycle reporting (HB, PB, claims, billing, scheduling, etc.).
- Experience developing dashboards, visual analytics, and complex BI models.
Compensation for the Sr. Business Intelligence Developer:
- Full‑time role with hybrid flexibility (2 days onsite in Allentown or Fort Washington, PA).
- Comprehensive benefits including Medical, Dental, Vision.
- $125,000 Base Salary.
This job opens for applications on 3/23/2026 and will remain open for at least 30 days from the posting date.
Keywords:
Epic Clarity, Epic Revenue Cycle, HB, PB, Resolute HB, Resolute PB, Epic Radar Dashboards, Epic Reporting Workbench, SQL Developer, T‑SQL, SQL Server, Power BI, DAX, Tableau Migration, Qlik Migration, Healthcare Analytics, Revenue Cycle Reporting, Billing Analytics, Claims Analytics, Data Warehousing, Dimensional Modeling, Star Schema, Snowflake Schema, ETL Development, Data Pipelines, SSIS, BI Architecture, Dashboard Development, KPI Design, Data Governance, Healthcare BI Developer, BI Solutions, Healthcare Operations #LI-KG2 #LI-HYBRID