Analytics Engineer

About Specialized Dental Partners

Specialized Dental Partners is one of the nation’s leading dental support organizations for Endodontic, Periodontic, and Oral Surgery practices. With more than 250 practice locations and over 430 doctors across the United States, Specialized Dental Partners empowers specialists to focus on exceptional patient care while the organization delivers tailored business, operational, and strategic support.

Job Description:

The Analytics Engineer is the technical owner of Specialized Dental Partners’ Power BI reporting platform — responsible for building production-grade reports using industry-standard practices and for managing the entire reporting architecture end-to-end. This includes the Microsoft Fabric F64 capacity, OneLake and reporting domains, workspace structure, Power BI Gateway service, permission groups and row-level security, and the gold semantic model that powers every report.

Experience:

+4 years

Power BI Report Development
• Build production Power BI reports using industry-standard practices: clean visual design, performance DAX, optimized layouts, and consistent UX.
• Deliver persona-based reports and Apps for Practice Managers, Operations, Finance, RCM, Executive, and Board audiences.
• Apply SDP-branded themes, drill-throughs, mobile layouts, and accessibility standards.
• Tune report and model performance against target load SLAs.

Reporting Architecture
• Manage Fabric F64 capacity: monitor CU consumption, remediate noisy workloads, forecast growth.
• Govern workspace and domain structure (dev/test/prod, functional domains, app workspaces) and promotion pipelines.
• Administer Power BI Gateway service: install, cluster, patch, manage credentials, monitor connections.
• Own the security model: Entra groups, workspace roles, app audiences, RLS, and OLS under least-privilege.
• Manage Power BI tenant settings, sharing policies, and audit logging.

Semantic Model & Governance
• Maintain a centralized KPI dictionary as the single source of truth.
• Retire ad-hoc Excel and citizen-developer reports by replacing them with governed equivalents.
• Manage citizen-developer reporting initiatives to ensure they are maintainable and distributed properly
• Implement Git source control and CI/CD for semantic models and reports.
• Monitor Fabric Capacity Usage; retire low-value assets; improve adoption and performance continuously.

Requirements:
• 4+ years analytics engineering or senior BI development.
• Expert Power BI report development: advanced DAX, semantic modeling, Direct Lake/DirectQuery/Import, performance tuning.
• Power BI Service administration: workspaces, deployment pipelines, RLS/OLS, tenant settings.
• Power BI Gateway administration: installation, clustering, credential management.
• Fabric F-SKU capacity management.
• Strong SQL and dimensional modeling (star schemas).
• Medallion architecture (bronze/silver/gold) experience.
• Git, code review, and CI/CD for BI artifacts.

Preferred Qualifications:
• DSO, multi-site healthcare, or healthcare services experience.
• Dental or medical RCM data: payor mix, AR aging, reimbursement.
• Microsoft Fabric (OneLake, Direct Lake, domains, Git integration).
• Tabular Editor, DAX Studio, Best Practice Analyzer.
• Copilot for Power BI or Microsoft Data Agents.
• M&A diligence or board reporting packs.