> Markdown version of [/jobs/ext/263274-senior-data-engineer](https://www.wearedevelopers.com/jobs/ext/263274-senior-data-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). --- # Senior Data Engineer - **Company:** The Specialized - **Location:** Franklin, TN, United States (Remote available) - **Experience:** Expert - **Salary:** $120,000.0 - $140,000.0 - **Contract:** Permanent contract - **Skills:** Artificial Intelligence, Airflow, Data Analysis, Microsoft Azure, Continuous Integration, Information Engineering, Data Governance, Extract Transform Load (ETL), Data Transformation, Database Queries, Dentrix, Python (Programming Language), Key Management, Microsoft Data Access Components, Medical Practice Management Software, Microsoft SQL Server, SQL Azure, Performance Tuning, Runbook, SQL Databases, Cloud Platform System, Azure Data Factory, Git, Microsoft Fabric, Data Management, Software Version Control, Devsecops - **Published:** May 27, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=97619fb277569f5d ## About the Role Do you have experience in Version control systems?, * 5+ years of professional data engineering experience in enterprise environments. Including master data management, data quality frameworks, cross-system reconciliation, operating production pipelines with monitoring, alerting, incident response, and robust code management practices (Git, CI/CD) * 7+ years of experience using SQL (advanced query writing, performance tuning, and data modeling on SQL Server and/or Azure SQL). * 4+ years of experience using Python for ETL, data transformation, API integration, and automation. * 3+ years of experience working with healthcare related data, * Experience with Apache Airflow or similar orchestrators. * Working knowledge of Microsoft Fabric, Azure Data Factory, and the medallion architecture (bronze/silver/gold). * DSO, multi-site healthcare, or healthcare services experience. * Experience integrating dental or medical practice management systems (TDO, PBS Endo, Dentrix, WinOMS, Endovision, Sikka). * Power BI semantic models, Direct Lake, and DAX. * Microsoft Purview, Entra ID, Azure Key Vault, and HIPAA-aligned cloud architectures. * AI/ML enablement, vector data, or Copilot grounding. * Ability to operate independently as a senior individual contributor. ## Description The Senior Data Engineer architects, builds, and maintains the data ETL pipelines that power enterprise reporting, analytics, and AI across Specialized Dental Partners (SDP). Grounded in our current SQL and Python stack and forward-looking toward Microsoft Fabric, this role eliminates key-person dependencies, enables scalable practice onboarding, and ensures SDP's data foundation is governed, AI-ready, and secure. 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., * Design, build, and maintain production ETL pipelines involving Python, SQL Server, and Azure SQL. * Write performant, maintainable SQL for transformation, modeling, and reconciliation. * Build parameterized ingestion from 13 practice management systems plus enterprise source systems across all major departments (HR, Accounting, Finance, IT) * Maintain and ingest master data crosswalks for various source systems * Partner on incremental Microsoft Fabric integration, including bronze/silver layer design and migration of select workloads. * Implement data quality monitoring, reconciliation alerts, and incident response. * Apply DevSecOps to data: IaC, CI/CD, environment promotion, and Git-based version control. * Document lineage, schemas, transformations, and runbooks. * Support enterprise AI initiatives (Copilot, Microsoft Data Agents, ML) with governed, complete data. * Manage Azure and Fabric capacity utilization and cost optimization. ## Related Videos - [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) - [Technical Documentation - How Can I Write Them Better and Why Should I Care?](https://www.wearedevelopers.com/videos/681-technical-documentation-how-can-i-write-them-better-and-why-should-i-care) - [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) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [AI Model Management Life Circles: ML Ops For Generative AI Models From Research to Deployment](https://www.wearedevelopers.com/videos/1152-ai-model-management-life-circles-ml-ops-for-generative-ai-models-from-research-to-deployment) - [Bridging AI and Nomad: a Go-based MCP Server for Cluster Control](https://www.wearedevelopers.com/videos/2063-bridging-ai-and-nomad-a-go-based-mcp-server-for-cluster-control) ## Related Articles - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers)