Talent.com
Data Integration Engineer

Data Integration Engineer

United Dental CorporationNew York, NY, US
job_description.job_card.variable_hours_ago
serp_jobs.job_preview.job_type
  • serp_jobs.job_card.full_time
  • serp_jobs.filters_job_card.quick_apply
job_description.job_card.job_description

Data Integration Engineer

Location : New York City

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

  • Convert and transform existing data processes (download and manipulate in Excel) into automated, efficient reports for various KPIs.
  • Stand up and manage a reporting database (PostgreSQL or equivalent).
  • Eventually connect outputs to Power BI, Looker Studio, or Excel with automatic refresh cycles.

    • 3. API Expansion & Documentation

  • Map each vendor’s API surface, authentication method, and data schema.
  • Maintain clean documentation and version control.
  • Work with vendors to unlock additional endpoints or resolve integration gaps.

    • 4. Collaboration & Process

  • Reverse-engineer existing Excel logic and replace it with code.
  • Align metric definitions with broader team.
  • Produce code that others can trust and eventually build on : versioned, commented, and tested.

    • Requirements

    Required

  • 3–6 years in software / data engineering (Python, SQL, JSON, REST APIs).
  • Hands-on experience building automated ETL or API pipelines between SaaS platforms.
  • Comfort translating complex Excel logic into code.
  • Strong grasp of data modeling, authentication, and error handling.
  • Bias for speed, simplicity, and ownership.

    • Nice to Have

  • Familiarity with dental / healthcare PMS (CareStack, Dentrix, Eaglesoft).
  • Exposure to financial and HR systems (Sage Intacct, Bill.com, ADP / Kronos).
  • Experience with data warehousing (Snowflake, Redshift, BigQuery).
  • Experience deploying on AWS Lambda, Airflow, or similar schedulers.
  • Understanding of HubSpot CRM data structures.

    • Success Metrics

  • Manual report prep time cut by >

    • 80 % within 90 days.

  • API-driven refresh cycle stable across all core systems within 6 months.
  • Practice-level KPIs visible daily, no manual intervention.
  • All pipelines documented, versioned, and monitored.

    • 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

  • 401(k) and up to a 4% match
  • Medical, Dental, Vision, Unlimited Vacation plan, 7 paid holidays.
  • Employee Assistance Program - that connects team members and their families with complimentary, confidential, short-term counseling and advisory services
  • Voluntary benefits like pet insurance, Life Lock and entertainment discounts
  • Continuing education opportunities
    • serp_jobs.job_alerts.create_a_job

    Integration Engineer • New York, NY, US

    Job_description.internal_linking.related_jobs
    • serp_jobs.job_card.promoted
    Data Engineer

    Data Engineer

    VirtualVocationsYonkers, New York, United States
    serp_jobs.job_card.full_time
    A company is looking for a Data Engineer - Remote.Key Responsibilities Design, implement, and maintain scalable ETL / ELT pipelines for structured and unstructured data sources Collaborate with cr...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Senior Data Engineer

    Senior Data Engineer

    Capital OneNew York City, NY, US
    serp_jobs.job_card.full_time +1
    Do you love building and pioneering in the technology space? Do you enjoy solving complex business problems in a fast-paced, collaborative,. At Capital One, you'll be part of a big group of makers, ...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    Data and Analytics Engineer

    Data and Analytics Engineer

    ResonanceNew York, NY, US
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.quick_apply
    Resonance is transforming the fashion industry by building a more sustainable and valuable ecosystem for designers, brands, manufacturers, consumers, and the planet. Our AI-powered operating system,...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    Senior Data Engineer

    Senior Data Engineer

    Plum IncNew York, NY, US
    serp_jobs.filters.remote
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.quick_apply
    PLUM is a fintech company empowering financial institutions to grow their business through a cutting-edge suite of AI-driven software, purpose-built for lenders and their partners across the financ...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    BI Data Engineer

    BI Data Engineer

    United Nations Federal Credit UnionUSA, New York, New York
    serp_jobs.job_card.full_time
    Data Engineer with 6+ years of experience in building data intensive applications, tackling challenging architectural and scalability problems with some exposure to gathering insights from data by ...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Senior Data Engineer

    Senior Data Engineer

    VirtualVocationsPaterson, New Jersey, United States
    serp_jobs.job_card.full_time
    A company is looking for a Senior Data Engineer who specializes in building AI-first, cloud-native data platforms.Key Responsibilities Lead the design and creation of scalable data models to meet...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    Data Engineer II

    Data Engineer II

    OrangepeopleNY, United States
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.quick_apply
    Are you a forward-thinking data professional ready to take on complex challenges? We are looking for a Data Engineer III to design, evaluate, and maintain sophisticated data architectures that driv...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_1_day
    • serp_jobs.job_card.new
    Data Engineer II

    Data Engineer II

    Alpha NetNY, United States
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.quick_apply
    ToProof" data-ogsb="rgb(255, 255, 255)" data-ogsc="rgb(0, 0, 0)" style="text-align : left; text-indent : 0px; background-color : rgb(255, 255, 255) !important; margin : 0p...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_hours
    • serp_jobs.job_card.promoted
    Lead Data Engineer

    Lead Data Engineer

    Capital OneNew York City, NY, United States
    serp_jobs.job_card.full_time +1
    Lead Data Engineer Do you love building and pioneering in the technology space? Do you enjoy solving complex business problems in a fast-paced, collaborative, inclusive, and iterative delivery envi...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Data Engineer

    Data Engineer

    ArchNew York, NY, US
    serp_jobs.job_card.full_time
    Arch is a Series B financial technology company that automates the management of private investments, improving access, understanding, and the human experience of investing across asset classes.Pri...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_1_day
    Python Data Engineer at NY (Hybrid)

    Python Data Engineer at NY (Hybrid)

    PSRTEKNew York City, NY, United States
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.quick_apply
    Job Title : Python Data Engineer Location : New York- Hybrid role serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_1_day
    • serp_jobs.job_card.promoted
    Senior Data Engineer - Data & Analytics

    Senior Data Engineer - Data & Analytics

    PROGYNYNew York, NY, United States
    serp_jobs.job_card.full_time
    Thank you for considering Progyny!.Data is the lifeblood of healthcare, and Progyny as a company depends on the accurate, timely, and secure management of data to achieve our company mission at the...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Senior Integration Engineer

    Senior Integration Engineer

    VirtualVocationsJamaica, New York, United States
    serp_jobs.job_card.full_time
    A company is looking for a Senior Integration Engineer, US (Pacific Time).Key Responsibilities Own the technical design of partner integrations, ensuring scalability, security, and compliance Gu...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    C++ Market Data Engineer (USA)

    C++ Market Data Engineer (USA)

    Trexquant InvestmentStamford, CT, US
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.quick_apply
    Trexquant is a growing systematic fund at the forefront of quantitative finance, with a core team of highly accomplished researchers and engineers. To keep pace with our expanding global trading ope...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    • serp_jobs.job_card.new
    Data Engineer (AI / ML)

    Data Engineer (AI / ML)

    VirtualVocationsJamaica, New York, United States
    serp_jobs.job_card.full_time
    A company is looking for a Data Engineer (AI / ML) 2 to support the Generative AI for Forms SBIR project by designing and maintaining data infrastructure for AI applications.Key Responsibilities De...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_hours
    • serp_jobs.job_card.promoted
    Lead Data Engineer

    Lead Data Engineer

    VirtualVocationsJamaica, New York, United States
    serp_jobs.job_card.full_time
    A company is looking for a Lead Data Engineer to architect, scale, and optimize its data ecosystem.Key Responsibilities Design, build, and optimize scalable data pipelines and architectures in cl...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Data Engineer II

    Data Engineer II

    VirtualVocationsAstoria, New York, United States
    serp_jobs.job_card.full_time
    A company is looking for a Data Engineer II to work on data systems and services critical to the business.Key Responsibilities Design, build, test, scale, and maintain data pipelines from various...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Cloud Data Engineer

    Cloud Data Engineer

    VirtualVocationsFlushing, New York, United States
    serp_jobs.job_card.full_time
    A company is looking for a Cloud Data Engineer to build scalable infrastructure and support data processing tasks.Key Responsibilities Build scalable and high-performance infrastructure for batch...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30