ERP PTF Data Analyst - SAP S/4HANA and Oracle Fusion

Are you enthusiastic about data and eager to make an impact in a global organization? Johnson Controls is seeking an Enterprise Plant to Fulfillment Data Specialist to join our dynamic team. 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 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 S/4HANA 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, Bills of Materials (BOM), Routings, and Work Center databases is preferred.

Key Responsibilities

• Data Migration
  • Coordinate and execute the migration of large datasets from legacy ERP systems to SAP S/4HANA 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
  • 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
• Collaboration & Issue Resolution
  • 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
  • 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).
• +2 years of 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.

Johnson Controls does not request pregnancy or HIV testing as a requirement for admission, permanence or promotion