Senior Data Integration Engineer

Johnson Controls•Glendale, AZ

3d•$100,000 - $145,000

About The Position

We are seeking a Senior Data Integration Engineer to design, build, and operate scalable data ingestion pipelines that power Workforce Analytics. This role is responsible for acquiring and standardizing data from enterprise systems—especially Workday—into the data platform, using tools such as Fivetran, APIs, and file-based integrations. You will ensure that source data is ingested accurately, reliably, and efficiently to support downstream modeling, analytics, and secure consumption. You will work closely with Data Platform, Data Engineering, and HR systems teams to ensure data is timely, complete, and production-ready.

Requirements

5+ years of experience in data engineering or data integration engineering
Strong experience with Fivetran or similar ingestion tools
Experience integrating data via APIs and flat files
Hands-on experience working with Workday integrations or HR data systems
Strong SQL skills and understanding of data structures
Experience building reliable, production-grade data pipelines
Familiarity with cloud data ecosystems (Snowflake preferred)

Nice To Haves

Deep experience with Workday (HCM, Recruiting, etc.)
Experience handling effective-dated and hierarchical datasets
Exposure to Workforce / People Analytics domains
Familiarity with Azure ecosystem
Experience with data observability/monitoring tools
Understanding of downstream transformation frameworks (Coalesce/dbt)

Responsibilities

Design, build, and maintain scalable ingestion pipelines using Fivetran, REST/SOAP APIs, and Flat files (SFTP, batch ingestion, vendor extracts).
Integrate data from key enterprise systems, including Workday (core HCM, recruiting, etc.) and other HR, payroll, and workforce-related systems.
Ensure ingestion pipelines are robust, efficient, and fault-tolerant.
Develop deep expertise in Workday data structures and integration patterns.
Design ingestion strategies for worker data, job/position structures, organizational hierarchies, and recruiting and talent data.
Handle complexities such as effective-dated data, hierarchical relationships, and slowly changing attributes.
Implement monitoring, alerting, and observability for ingestion pipelines.
Ensure data completeness, timeliness, and accuracy.
Troubleshoot pipeline failures and data discrepancies at the source level.
Partner with upstream system owners to resolve data quality issues.
Configure and optimize Fivetran connectors, manage sync schedules, schema changes, and connector performance.
Ensure cost-efficient use of Fivetran and handle edge cases requiring custom ingestion.
Define best practices for API-based ingestion, file handling and validation, and incremental vs full-load strategies.
Establish standards for naming, metadata, and lineage at the ingestion layer.
Ensure raw data is structured for downstream transformation (Coalesce).
Implement version control and deployment practices using Azure DevOps / GitHub.
Enable repeatable, testable deployment of ingestion pipelines.
Document integration logic and configurations.
Partner with Data Platform Engineering, Data Engineers, and HRIS / Workday teams to ensure clean handoffs between ingestion, transformation, and consumption.