> Markdown version of [/jobs/ext/1236561-analytics-engineer](https://www.wearedevelopers.com/jobs/ext/1236561-analytics-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Analytics Engineer - **Company:** The Specialized - **Location:** Franklin, TN, United States (Remote available) - **Experience:** Experienced - **Contract:** Permanent contract - **Skills:** Microsoft Excel, Data Analysis, Audit Trail, Business Intelligence Development, Code Review, Continuous Integration, Dimensional Modeling, Microsoft Data Access Components, Performance Tuning, Power BI, Standard Sql, Delivery Pipeline, Git, Microsoft Fabric, Software Version Control - **Published:** July 11, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=5ae4c027bc292927 ## About the Role +4 years, * 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. ## 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., 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. ## Related Videos - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94) - [Resilient by Design: Building Robust Architectures in High-Stakes Financial Systems](https://www.wearedevelopers.com/videos/2106-resilient-by-design-building-robust-architectures-in-high-stakes-financial-systems) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) - [No Keys for the Robot: GitOps as the Control Plane for Autonomous Agents](https://www.wearedevelopers.com/videos/100095-no-keys-for-the-robot-gitops-as-the-control-plane-for-autonomous-agents) ## Related Articles - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)