-
Data Analyst PTF
-
San Pedro Garza Garcia-MX
- 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.
- 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
- 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.
- Bachelor’s degree in data science, Computer Science, Information Systems, Actuarial Science or 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 proven 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.
- 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.
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
seeking an Enterprise Plant to Fulfillment Data Analyst 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 / ECC and Oracle Fusion, as well as conducting data audits to ensure the accuracy and quality of existing data from prior implementations.
What will you do?
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.
How will you do it?
Key Responsibilities
What are we looking for?
What do we offer?
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.
