Senior Data Integration Engineer

About the role

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.

We are seeking a Senior Data Integration Engineer to design, build, and operate scalable data ingestion pipelines that power Workforce Analytics.

Responsibilities

• Design, build, and maintain scalable ingestion pipelines using Fivetran, APIs, and file-based integrations
• Integrate data from key enterprise systems, including Workday 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
• Implement monitoring, alerting, and observability for ingestion pipelines
• 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
• Define best practices for API-based ingestion, file handling, and validation
• Establish standards for naming, metadata, and lineage at ingestion layer
• Implement version control and deployment practices using Azure DevOps / GitHub
• Partner with Data Platform Engineering, Data Engineers, and HRIS / Workday teams

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)

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)

Benefits

• 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
• Competitive Bonus plan

Pay

Hiring salary range: $100,000-145,000, determined by education, experience, knowledge, skills, and abilities of the applicant, internal equity, and alignment with market data.