Johnson Controls is a global leader in smart, healthy, and sustainable buildings. With operations in over 150 countries, we are committed to driving innovation and excellence in building technologies and integrated solutions. Our people are at the heart of our success, and we are passionate about attracting and developing top talent across the globe.
This position is a temporary 1 year contract
Role Overview
- As an ERP Data Management Engineer, you will support enterprise data initiatives by analyzing, extracting, transforming, validating, and troubleshooting data across ERP and related systems.
- This role combines ERP data knowledge with technical data engineering capabilities. You will work with SQL, data pipelines, ETL processes, scripts, and data models to understand how data moves between source and target systems.
- The ideal candidate is comfortable working across both technical and functional teams and can translate business data requirements into technical data analysis and solutions.
What will you do?
- Develop and analyze SQL queries to extract, validate, reconcile, and troubleshoot data across multiple systems.
- Analyze database structures, tables, schemas, relationships, and data models across ERP and enterprise applications.
- Understand and troubleshoot ETL/ELT processes and data pipelines, including extraction, transformation, and loading logic.
- Read and understand existing code, scripts, queries, stored procedures, and transformation logic.
- Trace data from source systems through transformations to target systems to identify data issues and root causes.
- Perform data profiling, reconciliation, and quality analysis across large datasets.
- Document data flows, mappings, transformation rules, dependencies, and technical logic.
What are we looking for?
- 5+ years of experience in data engineering, data integration, ERP data, or similar technical data roles.
- Bachelor's degree in Computer Science, Data Engineering, Information Systems, or related field.
- Strong SQL skills, including joins, CTEs, aggregations, subqueries, and complex data analysis.
- Strong understanding of relational databases, schemas, tables, keys, and data relationships.
- Experience with ETL/ELT processes and data pipelines.
- Ability to read, understand, and troubleshoot existing code and scripts.
- Experience analyzing and troubleshooting data across source and target systems.
- Experience with data extraction, transformation, reconciliation, and validation.
- Strong analytical and root-cause problem-solving skills.
- Ability to work across technical, functional, and business teams.
Nice to Have
- Experience with Python or another scripting language.
- Experience with data platforms and integration technologies such as Snowflake, OneStream or similar technologies.
- Experience working with ERP systems such as SAP, Oracle, JD Edwards, Lawson, MAPICS, or similar platforms.
What do we offer?
- Comprehensive benefits package.
- Opportunities for professional growth and development.
- Supportive and inclusive work environment.
- Commitment to work-life balance and employee well-being.
- Engagement in meaningful projects that make a difference.
This position is a temporary 1 year contract
Johnson Controls does not request pregnancy or HIV testing as a condition for hiring, continued employment, or promotion, in accordance with its commitment to labor equality and non-discrimination.
Skills Required
- 5+ years of experience in data engineering, data integration, ERP data, or similar technical data roles
- Bachelor's degree in Computer Science, Data Engineering, Information Systems, or a related field
- Strong SQL skills, including joins, CTEs, aggregations, subqueries, and complex data analysis
- Strong understanding of relational databases, schemas, tables, keys, and data relationships
- Experience with ETL/ELT processes and data pipelines
- Ability to read, understand, and troubleshoot existing code and scripts
- Experience analyzing and troubleshooting data across source and target systems
- Experience with data extraction, transformation, reconciliation, and validation
- Strong analytical and root-cause problem-solving skills
- Ability to work across technical, functional, and business teams
- Experience with Python or another scripting language
- Experience with Snowflake, OneStream, or similar data platforms and integration technologies
- Experience with ERP systems such as SAP, Oracle, JD Edwards, Lawson, MAPICS, or similar platforms
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®.
