Procurement Data Analyst

hace 3 días

Saltillo, México Johnson Controls A tiempo completo

**Job Details**
**What do you do?**
Join us in the Procurement Execution Center as a Data Analyst. In this role, you will be responsible for maximizing our RFx value by analyzing cost across supplier bids, performing scenario analysis in pursuit of cost optimization, while accelerating our RFP cycle time by pursuing automation across the multiple RFP stages. This role will work closely with the Indirect Buyer and Category Managers to ensure value is maintained post-RFP and that behaviors are effectively changed within JCI to obtain the value projected as part of the RFx.

**Responsibilities**:

- This role will perform multiple tasks within the RFP process to ensure quality of bid submissions and streamlines the RFx process by standardizing bid sheets.
- Executes RFx Support in coordination with Indirect Buyer, including: data extraction, data normalization preparation, optimization analytics, savings analysis, negotiation factbooks, among others.
- Perform scenario analysis by doing multiple iterations of potential business allocations, in an effort to understand the multiple scenarios that JCI can pursue, in order to identify the best scenario from a value-generation perspective. Scenarios can include: sensitivity analysis, cherry picking, keep incumbents, among others.
- This role will support calculation of baseline and comparing new cost to estimate cost impact/cost savings as part of the RFP.
- Analyzes bid results for outliers, bid validity, among other criteria.
- Drives automation within the RFP by building comprehensive negotiation workbooks by supplier, to enable data-driven supplier negotiations.
- Post-RFP support including Compliance Reporting.
- Works on ensuring the required data for RFP is extracted from various databases and prepared in accordance to perform the analytical task.
- Performs Data Profiling and other Data Cleansing activities to measure data integrity and data quality issues.
- Development and creation of Knowledge Bases (KBS) for automated data cleansing (i.e. Geographical location, supplier/shipper information, etc) as part of RFP preparation.
- Perform Benchmarking Analytics to assess our performance against the market, by using external data and comparing to our internal data to assess opportunity for the businesses and plants.
- Other Procurement duties as assigned

**What we look for**:

- 2+ years of experience in Procurement Analytics, Business Analyst, Data Analysis or BI on related fields.
- Bachelor’s degree in related field (Engineering, Computer Science, Data Science) is preferred but not mandatory.
- Knowledge of statistics and experience using statistical or database packages.
- Demonstrate commitment to continuous improvement in a dynamic environment, striving to exceed expectations.
- Ability to understand business requirements and translate into technical requirements.
- Demonstrate ability to identify and implement change, drive results, provide value-added analysis to assist Procurement leaders make informed decisions.
- Comfort in operating within a dynamic, complex and matrixed organizational structure
- Ability to establish credibility throughout the organization in processes and people by demonstrating JCI Values
- Fluent English is required given the global nature of the role.

**Technical / Software**:

- Advanced MS Excel. Capability to code/develop simple macros in VBA, advanced is a plus. Power BI: M or DAX is a plus.
- Capability to perform Queries in SQL/HQL for data extraction.
- Knowledge of data governance and data quality concepts (data profiling, data health, data cleansing, knowledge base, etc).
- Knowledge of Python focused on data analysis is preferred. (pandas, numpy)
- Strong analytical and problem-solving skills with a proactive and solution-oriented approach toward business issues

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

Additional Information

Overtime Status: Exempt

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.

  • Sr. Procurement Business Intelligence Analyst

    hace 7 días

    Saltillo, México Johnson Controls A tiempo completo

    **Job Details** The Procurement Analyst is responsible for collecting, analyzing and managing data to provide key insights for actionable improvements to the Procurement organization. The Procurement Analyst will be a key contributor in providing analytical-level support to the Procurement Category teams. The role requires analytical rigor and technical...

  • Procurement Analyst

    hace 7 meses

    Saltillo, México Johnson Controls International A tiempo completo

    **What do you do?** Join us in the Procurement Execution Center as a Procurement Analyst. In this role, you will be responsible for enabling our Category Managers and PBU Buyers with effective execution of our Category Strategy, by streamlining our RFQs processes, driving automation and performing meaningful analyses, while learning the commodity and...

  • Procurement Analyst Ii

    hace 5 días

    Saltillo, México Johnson Controls A tiempo completo

    **Job Details** **What do you do?** Join us in the Procurement Execution Center as a Procurement Analyst II. In this role, you will be responsible for enabling our Category Managers and PBU Buyers with an effective execution of our Category Strategy, by streamlining our RFQs processes, driving automation and performing meaningful analyses, while learning...

  • Procurement Analyst I

    hace 3 días

    Saltillo, México Johnson Controls A tiempo completo

    **Job Details** **What do you do?** Join us in the Procurement Execution Center as a Procurement Analyst II. In this role, you will be responsible for enabling our Category Managers and PBU Buyers with an effective execution of our Category Strategy, by streamlining our RFQs processes, driving automation and performing meaningful analyses, while learning...

  • Procurement Analyst Iii

    hace 3 días

    Saltillo, México Johnson Controls A tiempo completo

    **Job Details** **What do you do?** Join us in the Procurement Execution Center as a Procurement Analyst II. In this role, you will be responsible for enabling our Category Managers and PBU Buyers with an effective execution of our Category Strategy, by streamlining our RFQs processes, driving automation and performing meaningful analyses, while learning...

  • Procurement Cost Analyst

    hace 3 semanas

    Saltillo, Coahuila de Zaragoza, México Johnson Controls International A tiempo completo

    Job DescriptionWe are seeking a skilled Procurement Cost Analyst to join our team at Johnson Controls International.About the RoleThis is a unique opportunity to work in a dynamic environment where you will be responsible for executing our Competitive Product Cost Analysis (CPC) playbook. You will collect and analyze data, interpret drawings, and identify...

  • Procurement Analyst Ii

    hace 5 días

    Saltillo, México Johnson Controls A tiempo completo

    **Job Details** **Job Description**: **What do you do?** Join us in the Procurement Execution Center as a Procurement Analyst II. In this role, you will be responsible for enabling our Category Managers and PBU Buyers with an effective execution of our Category Strategy, by streamlining our RFQs processes, driving automation and performing meaningful...

  • Procurement Analyst Iii

    hace 7 meses

    Saltillo, México Johnson Controls A tiempo completo

    **What do you do?** Join us in the Procurement Execution Center as a **Procurement Analyst III **. In this role, you will be responsible for enabling our Category Managers and PBU Buyers with an effective execution of our Category Strategy, by streamlining our RFQs processes, driving automation and performing meaningful analyses, while learning the...

  • Procurement Analyst Ii

    hace 7 meses

    Saltillo, México Johnson Controls A tiempo completo

    **What do you do?** Join us in the Procurement Execution Center as a **Procurement Analyst II **. In this role, you will be responsible for enabling our Category Managers and PBU Buyers with an effective execution of our Category Strategy, by streamlining our RFQs processes, driving automation and performing meaningful analyses, while learning the...

  • Procurement Cost Analyst

    hace 3 semanas

    Saltillo, Coahuila de Zaragoza, México Johnson Controls International A tiempo completo

    **About the Role**We are seeking a highly skilled Procurement Cost Analyst to join our team at Johnson Controls International. This is a unique opportunity to utilize your analytical expertise in statistical analysis, data interpretation, and cost optimization to drive business growth.**Key Responsibilities:**Analyze competitive product costs and identify...

  • Procurement Analyst I

    hace 3 días

    Saltillo, México Johnson Controls A tiempo completo

    **Job Details** **What do you do?** Join us in the Procurement Execution Center as a Procurement Analyst I. If you are recent graduate or undergraduate about to finalize college, this is a great opportunity for you to join a great Procurement organization! In this role, you will be responsible for enabling our Category Managers and PBU Buyers with an...

  • Procurement Data Engineer Ii

    hace 5 días

    Saltillo, México Johnson Controls A tiempo completo

    **Job Details** **What you will do?** Join us in the Procurement Execution Center (PEC) as a Data Engineer as part of a is a diverse team of data and procurement individuals. In this role, you will be responsible for deploying supporting the E2E management of our data, including: ETL/ELT, DW/DL, data staging, data governance, and manage the different...

  • Procurement Data Engineer Associate

    hace 7 meses

    Saltillo, México Johnson Controls International A tiempo completo

    **What you will do?** Join us in the Procurement Execution Center (PEC) as a **Data Engineer Associate** as part of a is a diverse team of data and procurement individuals. In this role, you will be responsible for supporting the End-to-End (E2E) management of our data, including: ETL/ELT, DW/DL, data staging, data governance, and manage the different...

  • Procurement Data Engineer Iii

    hace 3 días

    Saltillo, México Johnson Controls A tiempo completo

    **Job Details** **What you will do?** Join us in the Procurement Execution Center (PEC) as a **_Data Engineer III _**as part of a is a diverse team of data and procurement individuals. In this role, you will be responsible for deploying supporting the E2E management of our data, including: ETL/ELT, DW/DL, data staging, data governance, and manage the...

  • Procurement Data Engineer Ii

    hace 5 días

    Saltillo, México Johnson Controls A tiempo completo

    **Job Details** **What you will do?** Join us in the Procurement Execution Center (PEC) as a **_Data Engineer II _**as part of a is a diverse team of data and procurement individuals. In this role, you will be responsible for deploying supporting the E2E management of our data, including: ETL/ELT, DW/DL, data staging, data governance, and manage the...

  • Procurement Data Analytics Specialist

    hace 1 día

    Saltillo, México Johnson Controls A tiempo completo

    **Job Details** **What you will do?** Join us in the Procurement Execution Center (PEC) as a **_Data Engineer _**as part of a is a diverse team of data and procurement individuals. In this role, you will be responsible for deploying supporting the E2E management of our data, including: ETL/ELT, DW/DL, data staging, data governance, and manage the...

  • Procurement Specialist

    hace 7 meses

    Saltillo, México Johnson Controls International A tiempo completo

    **What do you do?** Join us in the Procurement Execution Center as a Procurement Analyst II. In this role, you will be responsible for enabling our Category Managers and PBU Buyers with an effective execution of our Category Strategy, by streamlining our RFQs processes, driving automation and performing meaningful analyses, while learning the commodity and...

  • Sr Procurement Analyst

    hace 7 días

    Saltillo, México Johnson Controls A tiempo completo

    **Job Details** **The Sr Procurement Analyst **is responsible for oversight and management of the Procurement-PTP project. A broad understanding of procurement processes is a key component of the role as well as outreach to key stakeholders and cross functional work with procurement, accounts payable, field operations and suppliers. Will develop and own...

  • Procurement Operations Specialist

    hace 2 meses

    Saltillo, Coahuila de Zaragoza, México Johnson Controls A tiempo completo

    About Johnson ControlsJohnson Controls is a leading global provider of building technology and solutions. We are seeking a highly skilled Procurement Analyst to join our team in the Procurement Execution Center.

  • Data Engineering Specialist

    hace 3 semanas

    Saltillo, Coahuila de Zaragoza, México Johnson Controls A tiempo completo

    We are seeking a highly skilled Data Engineering Specialist to join our Procurement Execution Center (PEC) team. As a key member of this diverse group of data and procurement professionals, you will be responsible for supporting the end-to-end management of our data, including ETL/ELT, DW/DL, data staging, data governance, and managing various data layers...