Data Integration Engineer

Data Integration Engineer

Location : New York City (Hybrid 2-5 days / week in office)

Reports to : CEO

Department : Platform Intelligence

Overview

United Dental Corporation (UDC) is a data-driven DSO scaling from 20+ practices toward $100M+ in revenue.  If you like building systems that remove manual steps, collapse time, and make decision-making instantaneous then keep reading.

This developer will partner directly with the CEO to design and automate the backbone that powers financial, clinical, and operational reporting across the company. Your code will be the system.

Current Environment

Today, most workflows are manual. Data is pulled from CareStack, Dentira, HR / payroll, Sage Intacct, and HubSpot as CSV or Excel files, merged with formulas (INDEX-MATCH, XLOOKUP, arrays) to create reports.  These work but do not scale.

Your mission : turn that into clean, automated, API-driven infrastructure.

You’ll use ETL frameworks and Python scripts for ingestion, JSON and REST APIs for live connections, and SMTP / SFTP / file-drop automations where APIs don’t exist. The end state is an auditable, always-current data layer feeding dashboards and metrics without human intervention.

Core Responsibilities

1. Data Integration & Automation

• Build and maintain ETL pipelines between CareStack, Dentira, Sage Intacct, Bill.com, Prestige / Kronos, HubSpot, and future systems.
• Eliminate Excel bottlenecks by scripting repeatable workflows for extraction, transformation, and load.
• Normalize practice and provider identifiers for clean cross-system joins.
• Add monitoring and alerting for failed jobs or stale data.

2. Reporting Infrastructure

3. API Expansion & Documentation

4. Collaboration & Process

Requirements

Required

Nice to Have

Success Metrics

80 % within 90 days.

Compensation

Compensation commensurate with experience and will include performance incentives tied to automation and data reliability milestones.

Mindset Fit

You build systems that replace people’s manual work. You document what you build so no one ever rebuilds it. You hate doing the same thing twice. You like showing results before anyone asks.

Benefits