Chord Specialty Dental Partners is seeking a Senior Data Analyst to own and steward the enterprise 'gold' data model for the dental service organization (DSO) and turn it into reliable data marts, views, and datasets that power Power BI reports, dashboards, and CSV extracts for the business.
Requirements
- Strong SQL Server skills, including writing complex queries, CTEs, window functions.
- Hands-on experience with Power BI, including data modeling, DAX, measures, and calculated columns.
- 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.
- Experience with version control and DevOps practices for SQL / BI artifacts.
- Familiarity with other reporting / BI tools or Python/R for ad hoc analysis
Responsibilities
- 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.
- 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)
Other
- 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
- Ability to communicate credibly with clinic, regional, and revenue cycle leaders
