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. We are looking for an Enterprise Data Specialist.
What will you do?
In this role, you will play a critical role driving the success of our digital transformation initiatives by supporting data migration projects from legacy ERP systems to SAP S4 HANA / ECC and Oracle Fusion, as well as conducting data audits to ensure the accuracy and quality of existing data from prior implementations.
The Data Analyst will be responsible for collecting, analyzing, and interpreting large datasets to provide actionable insights that support business decisions. This role involves working closely with cross-functional teams to identify trends, optimize processes, and ensure data accuracy and integrity.
In this role, you will:
Data Migration: Collaborate with teams to migrate large datasets from legacy ERP systems to SAP S/4HANA / ECC and Oracle Fusion, ensuring data accuracy and completeness.
Conduct data audits to verify the accuracy and quality of existing data from previous implementations.
Utilize Microsoft Excel and Power BI for data analysis and reporting.
Automate or optimize data workflows using Python or SQL (a strong plus).
Collaborate with cross-functional teams to identify gaps, document process improvements, and enhance decision-making capabilities through reliable data.
Demonstrated knowledge of Supply Chain Item Master data, Item Creation.
How will you do it?
Data Migration.
Coordinate and execute the migration of large datasets from legacy ERP systems to SAP S/4HANA / ECC and Oracle Fusion, ensuring data integrity throughout the process.
Ensure data quality, consistency, and completeness throughout the migration process.
Data Auditing.
Conduct comprehensive audits of existing data to identify discrepancies, errors, and outdated information.
Validate and correct data to ensure alignment with business requirements and adherence to data governance standards.
Data Analysis & Reporting.
Analyze complex datasets to identify patterns, trends, and correlations.
Use Microsoft Excel, Power BI, and other analytical tools to create dashboards, trend charts, and presentations.
Deliver actionable insights to stakeholders by identifying trends, anomalies, and opportunities for improvement
Develop dashboards, reports, and visualizations to communicate insights effectively.
Collaboration & Issue Resolution.
Collaborate with stakeholders to understand business requirements and translate them into data-driven solutions.
Organize and lead meetings with IT specialists, PTF process owners, and functional leads to address and resolve data-related issues.
Document findings, assign responsibilities, and monitor due dates to ensure timely resolution of outstanding items.
Tool & Process Improvement.
Utilize statistical methods and tools to improve decision-making processes.
When applicable, leverage Python or SQL to handle big data challenges, automate workflows, and optimize data processes.
Identify opportunities to enhance ERP data structures, governance strategies, and reporting capabilities.
Knowledge Transfer & Change Management.
What are we looking for?
Bachelor’s degree in data science, Computer Science, Information Systems, Actuarial Science or a related field (or equivalent work experience).
Proficiency in English (both written and spoken) is required to effectively communicate with global technical and non-technical audiences.
Proficiency in Microsoft Excel (pivot tables, VLOOKUP, XLOOKUP, macros, etc.) and solid experience with Power BI (data modeling, dashboards, DAX).
Experience working on ERP implementation or migration projects at scale.
Practical experience with ETL processes and familiarity with data governance frameworks is preferred
Strong analytical skills with a prove ability to manage and interpret large datasets effectively.
Familiarity with Python or SQL for data transformation and automation is highly advantageous.
Experience or exposure to SAP S4 HANA, ECC, Oracle Fusion, or other major ERP systems—particularly in the Supply Chain Environment significant plus.
Possess a problem-solving mindset with the ability to troubleshoot data-related issues in a demanding environment.
