Senior Analytics Engineer – DSO / Dental Operations

Overview

Chord Specialty Dental Partners, a leading provider of pediatric and orthodontic dental care, is seeking an experienced Senior Data Analyst to join our team!

The Senior Data Analyst will own and steward the enterprise “gold” data model for the dental service organization (DSO). This role is responsible for turning that model into reliable data marts, views, and datasets that power Power BI reports, dashboards, and CSV extracts for the business.The ideal candidate combines deep dental / DSO domain knowledge with strong SQL Server, Azure, and Power BI skills to deliver timely reporting, actionable insights, root-cause analysis, and proactive recommendations for management, while enforcing strong data governance and data quality across the analytics environment.

Location: Monday - Thursday (On Site) Friday (Remote)

Responsibilities

Responsibilities:

Data Model Ownership & Engineering

• Own the gold data model (conformed dimensions, fact tables, business rules) across the DSO.
• Design, build, and maintain data marts, views, and stored procedures in SQL Server to support analytics and operations.
• Create and manage Power BI semantic models/datasets and reusable dataflows.
• Build and maintain CSV / flat-file outputs for downstream consumers and external partners.
• Ensure data quality, consistency, and lineage from source systems into the gold model.

Reporting, Analytics & Insight Generation

• Develop and maintain standard management reports and dashboards (clinical, operations, and financial KPIs: production, collections, AR, hygiene metrics, chair utilization, cancellations/no-shows, case acceptance, etc.).
• Perform deep-dive analyses and root-cause investigations (e.g., production variances, provider performance, clinic performance, payer mix changes).
• Translate business questions from executives and operators into clear analytical approaches and data products.
• Proactively identify trends, risks, and opportunities and recommend pragmatic actions.

Domain Expertise & Business Partnership

• Serve as a go-to analytics partner for Operations, Finance, Revenue Cycle, Clinical Leadership, and Marketing.
• Demonstrate strong understanding of how a DSO / dental clinic runs, including:
• Scheduling, provider productivity, and chair-time utilization.
• Insurance verification, claims, adjustments, write-offs, AR.
• Fee schedules, payer contracts, and patient responsibility.
• New patient flow, marketing funnels, and retention.
• Challenge and refine metric definitions to ensure consistent, business-relevant KPIs across the organization.
• Document business logic, metric definitions, and data assumptions in clear, accessible language.

Data Governance & Platform

• Help define and enforce data governance standards, including naming conventions, metric definitions, and access controls.
• Collaborate with Data Engineering / IT to ensure robust, auditable data pipelines from source systems into Azure/SQL Server.
• Monitor data refreshes, performance, and reliability; troubleshoot data issues end-to-end.
• Contribute to data documentation, catalogs, and metadata so that stakeholders can discover and trust available data assets.
• Help prioritize the analytics backlog and manage stakeholder expectations on delivery and enhancements.

Qualifications

Qualifications: 

• 5 years of experience as a Data Analyst, Senior Data Analyst, or similar role.
• Bachelors degree in an applicable quantitative field (e.g. analytics, comp sci, math, economics, finance, etc)
• Position requires ability to work in office in Nashville, TN
• Dental / DSO / healthcare provider experience with strong understanding of core business processes and metrics (able to communicate credibly with clinic, regional, and revenue cycle leaders).
• Strong SQL Server skills, including:
• Writing complex queries, CTEs, window functions.
• Building views, stored procedures, and optimized data marts.
• Performance tuning and query optimization basics.
• Hands-on experience with Power BI, including:
• Data modeling, DAX, measures, and calculated columns.
• Building interactive reports and dashboards for business users.
• Managing and publishing datasets / workspaces.
• Experience working in Azure-based data environments (e.g., Azure SQL Database, Azure Data Factory / pipelines, Azure Storage or similar).
• Proven ability to translate business questions into analytical solutions and communicate findings clearly to non-technical stakeholders.
• Strong attention to detail, ownership mindset, and comfort working with imperfect real-world data.

Preferred Qualifications:

• Experience in multi-site DSO or healthcare settings.
• Background in financial analytics (production vs. collections, AR, payer economics, profitability by clinic/provider).
• Experience with version control and DevOps practices for SQL / BI artifacts.
• Familiarity with other reporting / BI tools or Python/R for ad hoc analysis.

What We Offer

We believe that taking care of our employees and their families is paramount. That's why we offer a comprehensive benefits package designed to support you in every aspect of your life. Here’s what we provide:

• Medical and Vision Insurance: You're eligible starting the first month after you join.
• In-house Dental Coverage: Enjoy this benefit with $0 premium.
• 401(k) Plan with Company Match: We help you plan for your future with our matching program.
• Generous Paid Time Off and Holidays: Take the time you need to relax and recharge.
• Employee Referral Program: Earn rewards for bringing talented individuals to our team.
• Big savings, big perks: Enjoy exclusive discounts on everything from restaurants and travel to movies and more with our employee discount program.
• Pet Insurance: We understand the importance of furry family members too.
• Cutting-edge Technology and Training: We provide the tools and resources you need to excel in your role.
• Life and Disability Insurance Options: Protect yourself and your loved ones with our coverage options.

Who We Are

At Chord Specialty Dental Partners, our goal is for every employee to cultivate a fulfilling career. From serving patients in one of our many multi-specialty dental practices to serving our Home Office based out of Nashville, TN- we have something for everyone. We’re always looking for talented, driven individuals who have a desire to make an impact

#IND