Job Description

Data Analyst PTF
San Pedro Garza Garcia

-

MX
Apply now

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?

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.

Key Responsibilities

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.

What are we looking for?

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.

What do we offer?

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 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.

First name
*

Last name
*

Email address
*

Location
*

Phone number
*

Import profile
*

Import LinkedIn profile

or

Upload file (doc, pdf)

By submitting this application you agree that we process this data for recruitment purposes only and we will keep it until this open role is filled. When that period is over, we will either delete your data or inform you that we will keep it in our database for future roles.

I have read and I accept the policy for processing personal data.

My Information

My Experience

Application Questions

Review

My Information

My Experience

Application Questions

Review

Upload Resume/CV (5MB max)
*

Upload Resume to use AI fields extractor

How did You hear about us? *

Country *

Contact Information

Email address *

Country / Territory Phone Code

Phone number *

Phone extension

I confirm that I am submitting this electronic application on my own behalf, and not on behalf of any other person, and that the information contained in this application is my own personal information. I hereby affirm that the information provided during the application process and any accompanying documents attached including my resume/CV or provided during any discussion or interviews, are true and complete to the best of my knowledge. To the extent permitted by applicable local law, I authorize Johnson Controls and its affiliates, subsidiaries and operating segments (collectively, the Company) to investigate all statements in this application and accompanying documents and to secure any necessary information from all my employers, references, and educational institutions.

I understand that should I receive an offer of employment with Johnson Controls, such offer is conditional on successful completion of all aspects of the application process including such background and reference checks as are applicable and permitted under local law. Submission of this electronic application by me does not constitute to me an offer of employment, an employment agreement or any other contractually binding commitment by Johnson Controls.

I understand and agree that the information submitted by me will be used, disclosed and stored in accordance with Johnson Control's Privacy Notice, which I have fully reviewed and accept. For individuals located in the United States, applicants are not required to provide any age related information and/or graduation date(s). We will transfer your personal information across borders in accordance with the Privacy Notice. To the extent permitted by applicable local law, by clicking the button below, you consent to the cross-border transfer of your personal information. For individuals located in China: please read the Addendum – Rules on Cross Border Transfer of personal information for China (HR Management). By clicking the button below, you consent to Johnson Controls collecting, processing and transferring your personal information (including sensitive personal data) in accordance with our Privacy Notice and the Addendum for China.

To provide you with the most effective recruiting process, Johnson Controls may use artificial intelligence (“AI”) to help us better understand how your candidate information matches the requirements of the role you have applied to. We may process your answers to the application and qualification questions, information in your resume, and, if applicable, information from your Johnson Controls personnel record, using tools that rely on AI. All hiring decisions will be made by the hiring team after considering your candidate profile in full. These tools help us to match the information provided by you with the job and preferred qualifications. All hiring decisions will be made by our hiring team after considering your candidate profile in full, and the use of AI insights is just one of the tools and one of numerous factors that we use to help us evaluate candidates and reach a decision.

Johnson Controls would also like to consider you for additional and future job openings, and we may use AI to help with this process. These AI tools help us understand how your candidate information matches the requirements of future job openings (using the same process as described above). Johnson Controls recruiters may use these insights to help them decide whether to reach out to you to regarding a future job opening. If you are located in the United Kingdom or European Union, the use of the AI insights is necessary for Johnson Controls’ legitimate interests to provide a streamlined and efficient recruitment process, and to consider you for future roles. Please note, the use of AI insights is just one of the tools and one of many factors our recruiters use to help evaluate candidates for upcoming roles.

DO NOT E-SIGN UNTIL YOU HAVE READ THE ABOVE STATEMENT.

I certify that I have read, fully understand and accept all terms of the above statement and that I consent (where applicable) to the Privacy Notice and the Addendum for China. *

Work Experience

Work Experience

Remove

Job title *

Company *

Location

I currently work here

From *

To *

Role description

+ Add work experience

Education

Education

Remove

School or University *

Degree *

Field of Study

Overall result (GPA)

From

To (Actual or Expected)

+ Add education

Skills

Please provide your relevant Skills Type to add Skills

Websites
Add any relevant websites (include https:// in URL)

Website

Remove

URL *

+ Add websites

Application Questions

Are you at least 18 years of age? (If not, your employment is subject to verification that you are of at least legal age and that you are able to supply any required work permit) *

Are you legally eligible to work in the country to which you are applying? *

Will you now or in the future require sponsorship for employment Visa status to be eligible to work in the country to which you are applying?
(e.g., H-1B Visa status/Work Visa/Work Permit) *

What is your annual salary expectation for the role to which you are applying?

Personal Information
Johnson Controls values a diverse and inclusive workplace. Providing this information will help us to ensure our recruitment practices promote equality of opportunity.
Your response to the self-identification questionnaire below is voluntary. It is however mandatory to answer the questions, even if you choose not to provide the information.
The information will be kept anonymous and your answer will be treated with the strictest confidence and protected from misuse. We assure you that your answers will be used only for the purposes of monitoring our equal opportunities policy and will not be used by us to make any unlawful decisions affecting you, whether in a recruitment exercise or during the course of any employment with us.

You are not obliged to provide this information and you will not suffer any penalty if you choose not to do so.

Please select your gender which most accurately describes how you identify yourself *

My Information

Edit Hide

My Experience

Edit Show

Application Questions

Edit Show

Previous step Next step

Apply now

CONNECT WITH us