Data Engineer

Company Overview

Join SALT Dental Partners and be part of a dynamic team dedicated to revolutionizing the dental industry through innovative marketing strategies and exceptional patient experiences. Since our doors opened in 2019, our mission has been to help specialty dental providers grow their practices. SALT is creating a vast network of like-minded dental specialists throughout the country.

At SALT, we provide comprehensive support services, allowing dental specialists to focus on delivering exceptional care.

Job Summary

The Data Engineer is responsible for designing, developing, securing, and optimizing the enterprise data platform that powers analytics, reporting, automation, artificial intelligence, and business decision-making across SALT Dental Partners.

This role builds scalable data pipelines, integrations, and data structures that enable trusted, high-quality information to move efficiently from source systems into enterprise analytical platforms.

This role partners closely with the Manager of Data Analytics, BI Developers, application teams, Information Technology, business stakeholders, and external vendors to ensure data assets are reliable, governed, secure, and accessible for approved use cases. The ideal candidate brings strong expertise in SQL, ETL/ELT, cloud data platforms, integration patterns, data quality, and modern data architecture. Essential Functions

Data Platform Engineering* Design, develop, test, deploy, and maintain enterprise data pipelines and integration frameworks.

• Build scalable ETL/ELT processes that ingest, transform, and deliver data for analytical and operational workloads.
• Develop ingestion patterns for cloud applications, on-premises systems, files, databases, and approved external sources.
• Support the architecture and ongoing development of the enterprise data warehouse, lakehouse, and related data platform services.

Systems Integration* Develop and maintain integrations across practice management, revenue cycle, patient engagement, finance, human resources, operational, and third-party systems.

• Design and support API-based, database-based, and file-based integrations using secure and maintainable patterns.
• Partner with vendors and internal technical teams to resolve data availability, connectivity, transformation, and integration issues.
• Document interfaces, dependencies, mappings, schedules, error handling, and support procedures.

Data Architecture & Modeling* Design scalable data storage structures and transformation layers aligned with enterprise analytics requirements.

• Support dimensional modeling, common data definitions, and analytical data design.
• Establish and follow standards for data movement, transformation, retention, lifecycle management, naming, and documentation.
• Collaborate with BI Developers to improve model usability, query performance, refresh reliability, and downstream reporting.

Data Quality, Governance & Security* Implement automated validation, monitoring, reconciliation, testing, and alerting for critical data pipelines and assets.

• Identify data quality issues, perform root cause analysis, and coordinate sustainable remediation.
• Support data governance, metadata, lineage, stewardship, classification, and documentation initiatives.
• Ensure data solutions adhere to HIPAA, privacy regulations, least-privilege principles, and organizational security standards.
• Partner with Security and Compliance teams on audits, risk assessments, access controls, and incident response.

Cloud & Platform Operations* Administer, monitor, and optimize cloud-based data services and supporting infrastructure within assigned responsibilities.

• Monitor platform health, pipeline execution, system performance, capacity, and resource utilization.
• Implement resilient, scalable, and supportable solutions that accommodate enterprise growth and acquisition integration.
• Contribute to backup, disaster recovery, business continuity, observability, and data resiliency planning.

Innovation & Advanced Analytics Enablement* Enable approved AI, machine learning, predictive analytics, automation, and advanced reporting use cases through reliable data products.

• Evaluate emerging data engineering technologies and recommend practical improvements to the enterprise data ecosystem.
• Participate in proofs of concept and platform enhancements with clear security, supportability, governance, and value considerations.

Vendor & Project Management* Manage assigned relationships and technical activities with data platform vendors, software providers, and implementation partners.

• Provide technical direction based on prioritized initiatives, architecture standards, and project requirements.
• Communicate project status, dependencies, risks, issues, and decisions to technical and business stakeholders.

Required Education, Skills, & Experience* Bachelor’s degree in Computer Science, Information Systems, Data Engineering, Software Engineering, or a related field; equivalent professional experience may be considered.

• 4+ years of data engineering, integration engineering, database development, or data platform experience.
• Strong SQL development, data transformation, and database performance optimization skills.
• Hands-on experience building and supporting enterprise ETL/ELT pipelines and orchestration workflows.
• Experience with cloud data platforms, data warehouses, lakehouse architectures, and modern analytics ecosystems.
• Knowledge of REST APIs, secure integration patterns, structured and semi-structured data, and source control practices.
• Experience with Python or another relevant scripting language.
• Experience with Microsoft Fabric, Azure Data Factory, Azure SQL, Azure Synapse Analytics, Databricks, Snowflake, or related platforms is preferred.
• Experience integrating data from multiple SaaS, practice management, financial, clinical, or operational systems is preferred.
• Demonstrated knowledge of data quality, metadata, lineage, governance, monitoring, and operational support practices.
• Experience in healthcare, dentistry, a DSO, multi-site operations, or another regulated industry is preferred.
• Strong knowledge of HIPAA, privacy, security, least privilege, and responsible data-handling practices.
• Strong troubleshooting, root cause analysis, documentation, and technical communication skills.
• Detail oriented and comfortable working in a fast-paced environment.
• Excellent oral and written communication and strong interpersonal skills.
• Desire and ability to learn new skills and be a team player.
• Ability to act with integrity, professionalism, and confidentiality.

Physical Requirements* The following physical demands would apply to this job up to 40% of the time: Ability to lift, carry, or pull or push 25 lbs.

Benefits* Competitive salary

• Comprehensive benefits package (medical, dental, vision)
• Retirement Plan (401k with Company Match, IRA)
• Life Insurance (Basic, Voluntary & AD&D)
• Paid Time Off (Vacation, Sick & Public Holidays)
• Opportunities for professional development and growth
• Flexible remote work environment

Salt Dental Partners is an Equal Opportunity Employer. This job description is intended to describe the general nature and level of work being performed and is not an exhaustive list of all responsibilities and duties.