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
- 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
Johnson Controls International plc. is an equal employment opportunity and affirmative action employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, age, protected veteran status, genetic information, sexual orientation, gender identity, status as a qualified individual with a disability or any other characteristic protected by law. To view more information about your equal opportunity and non-discrimination rights as a candidate, visit EEO is the Law. If you are an individual with a disability and you require an accommodation during the application process, please visit here.
Skills Required
- 5+ years of experience in data engineering or data integration engineering
- Strong experience with Fivetran or similar ingestion tools
- Experience integrating data via REST/SOAP APIs and flat files (SFTP, batch ingestion)
- 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.)
- 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)
Johnson Controls Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Johnson Controls and has not been reviewed or approved by Johnson Controls.
-
Retirement Support — Retirement support is positioned as a meaningful part of the package through employer 401(k) matching, repeatedly framed as a strong pillar of the overall rewards mix. The matching contribution is described with specific match levels in multiple places, reinforcing perceived value for long-term saving.
-
Leave & Time Off Breadth — Time off is presented as comparatively robust, with multiple paid holiday categories, vacation time, and sick time described as generous or “amazing” in places. Paid time off breadth appears to be a consistent contributor to total rewards attractiveness beyond base pay.
-
Flexible Benefits — Benefits are described as broad and customizable, spanning standard medical/dental/vision plus optional add-ons like pet insurance, identity protection, and legal support. Tuition reimbursement is repeatedly highlighted as a high-value option supporting professional development.
Johnson Controls Insights
What We Do
At Johnson Controls, we transform the environments where people live, work, learn and play. From optimizing building performance to improving safety and enhancing comfort, we drive the outcomes that matter most. Dedicated to protecting the environment, we deliver our promise in industries such as healthcare, education, data centers and manufacturing. With a global team of 100,000 experts in more than 150 countries and over 130 years of innovation, we are the power behind our customers’ mission. Our leading portfolio of building technology and solutions includes some of the most trusted names in the industry, such as Tyco®, York®, Metasys®, Ruskin®, Titus®, Frick®, Penn®, Sabroe®, Simplex®, Ansul® and Grinnell®.
