Enterprise Data Specialist

Job Description

Are you passionate about data and eager to make an impact in a global organization? Johnson Controls is seeking an Enterprise Data Specialist to join our dynamic team. In this role, you will play a critical part in driving the success of our digital transformation initiatives by supporting data migration projects from legacy ERP systems to SAP S4 HANA and Oracle Fusion, as well as conducting data audits to ensure the accuracy and quality of existing data from prior implementations.

This is an exciting opportunity to work on cutting-edge ERP solutions, collaborate with cross-functional teams, and leverage your expertise in data analysis to enhance operational efficiency.

In this role, you will:

• Data Migration: Collaborate with teams to migrate large datasets from legacy ERP systems to SAP S4 HANA and Oracle Fusion, ensuring data accuracy and completeness.
• Conduct data audits to ensure 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.

Key Responsibilities

Data Migration

• Coordinate and execute the transfer of large datasets from legacy ERP systems to SAP S4 HANA and Oracle Fusion.
• Ensure data quality, consistency, and completeness throughout the migration process.

Data Auditing

• Perform in-depth audits of existing data to identify discrepancies, errors, or outdated information.
• Validate and correct data, ensuring compliance with business requirements and data governance standards.

Data Analysis & Reporting

• Use Microsoft Excel, Power BI, and other analytical tools to create dashboards, trend charts, and presentations.
• Provide actionable insights to stakeholders, highlighting trends, anomalies, or improvement areas.

Collaboration & Issue Resolution

• Organize and lead meetings with IT specialists, OTC process owners, and functional leads to resolve data issues.
• Document findings, assign responsibilities, and follow up on due dates to ensure timely closure of open items.

Tool & Process Improvement

• 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

• Document key learnings to support training content for end users.
• Collaborate with the change management team to ensure proper communication and adoption of new data processes.

Skills and Qualifications

• 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.
• Hands-on experience with ETL processes or data governance frameworks.
• Strong analytical skills with a proven track record of handling and interpreting large datasets.
• Familiarity with Python or SQL for data transformation and automation is highly advantageous.
• Experience or exposure to SAP S4 HANA, Oracle Fusion, or other major ERP systems—particularly in the Order-to-Cash domain—is a significant plus.
• Problem-solving mindset with the ability to troubleshoot data-related issues in a fast-paced environment.