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
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.
Employment type in the employer’s posting: Full time
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.
Write and analyze SQL queries to extract, validate and reconcile data across systems
Troubleshoot ETL/ELT processes and data pipelines
Trace data from source to target systems to find root causes of issues
Profile and check data quality across large datasets
Document data flows, mappings, transformation rules and dependencies
From the employer’s posting
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.
Develop and analyze SQL queries to extract, validate, reconcile, and troubleshoot data across multiple systems.
Understand and troubleshoot ETL/ELT processes and data pipelines, including extraction, transformation, and loading 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.
Education & alternatives
- 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.
Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.
Python
SQL
Oracle
SAP
Snowflake
Where the posting names them
Nice to Have
- Experience with Python or another scripting language.
- Experience with data platforms and integration technologies such as Snowflake, OneStream or similar technologies.
- 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.
- 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 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?
- 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.
Complete your application on jci.wd5.myworkdayjobs.com. The employer’s form will show what is required.
Applying through Workday
You create an account with each employer before you can upload anything. Every Workday employer has its own account, so one sign-up doesn’t carry over.
“Autofill with Resume” comes right after sign-in, before the My Information and My Experience steps. Check every field it fills in those steps, since that’s what recruiters see.
Your application status lives in that employer’s Candidate Home, under the same sign-in.
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.
About Johnson Controls
People
About 75,000 in 2025, down 7% from the year before.Annual report (SEC Form 10-K)
Company
Listed as JCI.
H-1B visas
11 approved for new hires in fiscal 2025.US Citizenship and Immigration Services
Demand for Data Engineer roles
New Data Engineer postings at the employers we follow are up 13% over the last 6 weeks compared with the 6 before.
August 17Last week
Each bar is one week of new postings. The darkest bars are the last 6 weeks.
Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.
About the role
We file this job under Data Engineer, by the work the posting describes.
Data engineers build and run the pipelines that copy data out of apps and outside services into a warehouse or lake, and fix them when a source changes or a load fails.
Expect SQL, Python, a cloud platform, a scheduler such as Airflow, and often tools for large data such as Spark or Kafka.
An analytics engineer works one step later, turning the raw data a data engineer lands into clean tables people can query.
US government figures for database architects
Median yearly pay, May 2025
$139,500
Expected change, 2025 to 2035
9.4% more jobsagainst 3.5% for all jobs
The government has no code for data engineers, so these figures are for the closest group, database architects, which includes data integration and data warehousing specialists.