Senior Data Integration Engineer

Johnson Controls; Milwaukee (WI); On-site; USD 100,000 - 145,000; Full time

Benefits offered by this job

Competitive salary

Paid vacation/holidays/sick time

Comprehensive benefits (401K, medical,

Job summary

Johnson Controls is seeking a Senior Data Integration Engineer for Workforce Analytics to design and operate scalable data ingestion pipelines. You will ingest data from Workday and other HR systems, ensuring accuracy and timeliness for analytics and modeling.

You will partner with Data Platform, HRIS, and HR teams to standardize data structures, implement observability, and optimize Fivetran connectors. A strong background in SQL, APIs, and cloud data ecosystems is required, with a focus on

Qualifications

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

Responsibilities

• Design, build, and maintain scalable ingestion pipelines (Fivetran primary).
• Integrate data from Workday and other HR systems using APIs and flat files.
• Implement monitoring, alerting, and data quality checks for ingestion pipelines.
• Configure and optimize Fivetran connectors and manage schedules.
• Define ingestion standards including API-based and file-based workflows.
• Support CI/CD deployment of ingestion pipelines using Azure DevOps / GitHub.
• Collaborate with Data Platform, HRIS/Workday teams and downstream modelers.

Skills

Fivetran

APIs

SQL

Workday data

Cloud data (Snowflake)

Data pipelines

Azure DevOps

Tools

Snowflake

Azure DevOps

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
• Design ingestion strategies for: Worker data
• Design ingestion strategies for: Job/position structures
• Design ingestion strategies for: 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