ERP PTF Data Analyst at Johnson Controls

, , Mexico -

Full Time

Start Date

Immediate

Expiry Date

08 Mar, 26

Salary

0.0

Posted On

08 Dec, 25

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Data Migration, Data Auditing, Data Analysis, Reporting, Collaboration, Issue Resolution, Tool Improvement, Process Improvement, Python, SQL, Microsoft Excel, Power BI, Supply Chain, ETL Processes, Data Governance, Analytical Skills

Industry

Industrial Machinery Manufacturing

Description

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 Johnson Controls: Enhancing the Intelligence of Buildings Your buildings have a purpose. They are places for people to live or work. Facilities for learning or healing. Venues for entertainment and shopping. Sites for the specialized storage of tangible goods or mission-critical data. Your buildings have a huge variety of functions; they are central to your mission. This is where Johnson Controls comes in, helping drive the outcomes that matter most. Through a full range of systems and digital solutions, we make your buildings smarter. A smarter building is safer, more comfortable, more efficient, and, ultimately, more sustainable. Most important, smarter buildings let you focus more intensely on your unique mission. Better for your people. Better for your bottom line. Better for the planet. At Johnson Controls, we’ve been making buildings smarter since 1885, and our capabilities, depth of innovation experience, and global reach have been growing ever since. Today, we offer the world’s largest portfolio of building products, technologies, software, and services; we put that portfolio to work to transform the environments where people live, work, learn and play.

How To Apply:

Incase you would like to apply to this job directly from the source, please click here

Responsibilities

The role involves coordinating and executing data migration from legacy ERP systems to SAP S/4HANA and Oracle Fusion, ensuring data integrity and quality. Additionally, the analyst will conduct data audits, analyze data using tools like Power BI, and collaborate with cross-functional teams to resolve data-related issues.