Senior Data Engineer

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.

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.

Specialized Dental Partners, its affiliates, related companies and independently owned supported clinical practices are proud to be Equal Opportunity Employers. We celebrate diversity and are committed to creating an inclusive environment for all employees. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status. The salary range for this role is $120,000 - $140,000 per year. At Specialized Dental Partners, its affiliates, related companies and independently owned supported clinical practices, we are committed to ensuring fair and equitable pay for all employees. We adhere to all applicable federal, state, and local laws regarding pay equity and non-discrimination. Our compensation practices are designed to ensure that employees are paid fairly based on their role, experience, performance, and contributions to the company, without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status. We regularly review our compensation practices and conduct pay equity audits to identify and address any disparities. By fostering a culture of transparency and fairness, we aim to create an inclusive workplace where all employees feel valued and respected.