Senior Data Integration Engineer

Johnson Controls, a global leader in thermal management, mission-critical building systems, energy efficiency, and decarbonization, helps customers use energy more productively, reduce carbon emissions, and operate with the precision and resilience required in rapidly expanding industries such as data centers, healthcare, pharmaceuticals, advanced manufacturing, and higher education. For more than 140 years, Johnson Controls has delivered performance where it really matters.

Backed by advanced technology, lifecycle services and an industry-leading field organization, we elevate customer performance, turn goals into real-world results and help move society forward.

• Competitive salary
• Paid vacation/holidays/sick time
• Comprehensive benefits package including 401K, medical, dental, and vision care
• On the job/cross training opportunities
• Encouraging and collaborative team environment
• Dedication to safety through our Zero Harm policy

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.

• Data Ingestion & Integration Engineering (Core Focus)

  Design, build, and maintain scalable ingestion pipelines using:
  Fivetran (primary tool) REST/SOAP APIs Flat files (SFTP, batch ingestion, vendor extracts)

  Integrate data from key enterprise systems, including:
  Workday (core HCM, recruiting, etc.) Other HR, payroll, and workforce-related systems

  Ensure ingestion pipelines are robust, efficient, and fault-tolerant.

• Workday & HR Domain Expertise

  Design ingestion strategies for:
  Worker data Job/position structures Organizational hierarchies Recruiting and talent data

  Handle complexities such as:
  Effective-dated data Hierarchical relationships Slowly changing attributes

• Data Reliability & Monitoring

  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

• Fivetran Optimization & Management

  Configure and optimize Fivetran connectors

  Manage sync schedules, schema changes, and connector performance

  Ensure cost-efficient use of Fivetran

  Handle edge cases where custom ingestion is required beyond Fivetran

• Integration Design & Standards

  Define best practices for: API-based ingestion File handling and validation Incremental vs full-load strategies

  Establish standards for naming, metadata, and lineage at ingestion layer

  Ensure raw data is structured for downstream transformation (Coalesce)

• CI/CD & Version Control

  Implement version control and deployment practices using Azure Dev Ops / Git Hub

  Enable repeatable, testable deployment of ingestion pipelines

  Document integration logic and configurations

• Cross-Team Collaboration

  Partner with:
  Data Platform Engineering (Snowflake readiness, access patterns) Data Engineers (downstream modeling in Coalesce) HRIS / Workday teams (source system alignment)

  Ensure clean handoffs between ingestion → transformation → consumption

• 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)

• Deep experience with Workday (HCM, Recruiting, etc.)
• Expe…