Senior Data Integration Engineer

Job Description

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.

What we offer:

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

Senior Data Integration Engineer – Workforce Analytics

Role Summary

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.

Key Responsibilities

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

Develop deep expertise in Workday data structures and integration patterns

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 DevOps / GitHub

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

Required Qualifications

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)

Preferred Qualifications

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)

HIRING SALARY RANGE: $100,000-145,000 (Salary to be determined by the education, experience, knowledge, skills, and abilities of the applicant, internal equity, and alignment with market data.) This role offers a competitive Bonus plan that will take into account individual, group, and corporate performance. This position includes a competitive benefits package. The posted salary range reflects the target compensation for this role. However, we recognize that exceptional candidates may bring unique skills and experiences that exceed the typical profile. If you believe your background warrants consideration beyond the stated range, we encourage you to apply. To support an efficient and fair hiring process, we may use technology assisted tools, including artificial intelligence (AI), to help identify and evaluate candidates. All hiring decisions are ultimately made by human reviewers. For details, please visit the About Us tab on the Johnson Controls Careers site at https://jobs.johnsoncontrols.com/about-us