Data Integration Engineer
About The Position
The Data Integration Engineer will own and scale our data ingestion layer using Fivetran / CData or similar tools / CData and Databricks / MS Fabric or similar technologies.This role focuses on integrating legacy enterprise applications, SaaS enterprise applications, databases, APIs, and file-based sources into a cloud-native analytics platform. You will ensure data is reliable, complete, secure, and delivered on time to support analytics, reporting, and downstream data products. This role sits at the intersection of source systems, data engineering, and platform operations . This role is integral to driving the company's data strategy and ensuring that data initiatives align with business objectives.
Requirements
- 5+ years of experience in data integration, ETL/ELT, or data engineering integrating various enterprise applications including ERPs (Financials, Supply Chain, Warehouse Management, Transportation Management) both on-prem and cloud.
- Hands-on experience with Fivetran / CData or similar tools (including connector configuration and monitoring)
- Experience with Databricks and Delta Lake
- Strong SQL skills; working knowledge of PySpark or Python
- Experience integrating APIs (REST/JSON), relational databases, and SaaS tools
- Familiarity with CDC concepts (log-based replication, timestamps, soft deletes)
- Git-based development and documentation practices
- Strong troubleshooting and root-cause analysis skills
- Ability to work with application owners and non-data teams
- Comfortable operating production data pipelines with SLAs
- Bachelor's degree in Computer Science, Engineering, or equivalent experience.
Responsibilities
- Data Ingestion & Integrations Design, implement, and maintain data integrations using Fivetran / CData or similar tools (managed and custom connectors)
- Integrate data from ERP platforms (Financials, Supply Chain, Warehouse Management, Transportation Management) both on-prem and Cloud, SaaS platforms, operational databases, APIs, and flat files
- Build and maintain Fivetran / CData or similar tools / custom connectors where off-the-shelf connectors do not meet requirements
- Partner with application owners to understand source system schemas, SLAs, and change patterns
- Land raw data into Databricks Delta Lake (Bronze layer) with appropriate partitioning and metadata
- Validate source data completeness, freshness, and schema consistency
- Support incremental loads, CDC, and historical backfills
- Build lightweight Databricks jobs for ingestion validation and reconciliation
- Monitor Fivetran / CData or similar tools: syncs, alerts, and failures; troubleshoot root causes
- Implement ingestion-level data quality checks and reconciliation logic
- Manage schema drift, breaking changes, and connector upgrades
- Document data sources, refresh schedules, and known limitations
- Configure secure connectivity (networking, secrets, service accounts)
- Apply least-privilege access controls to source systems and landing tables
- Support PII handling, retention, and regulatory requirements
- Partner with security and platform teams on audits and reviews
Benefits
- An amazing company culture
- Medical/Dental/Vision on the first of the month following hire
- ESOP (Profit Sharing) and 401(k)
- Paid vacations, paid holidays
- Coverage under State Sick Leave
- 100% Prepaid College Tuition for employees and their dependents
- Employee assistance program (EAP)
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
