Procurement Data Engineer Ii

hace 2 meses


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 different layers of data required to ensure a successful BI & Reporting for the PEC.

This role will work with multiple types of data, spreading across multiple functional areas of expertise, including Fleet, MRO & Energy, Travel, Professional Services, among others.

**How you will do it?**

Deploy data ingestion processes through Azure Data Factory to load data models as required into Azure Synapse. Build, design, and support ETL/ELT processes with Azure Data Factory (ADF) and/or Python, which once deployed, will require to be executed daily and weekly. Assemble data sets that meet functional / non-functional business requirements. Develop data models that enable DataViz, Reporting and Advanced Data Analytics, striving for optimal performance across all data models.

Maintain conceptual, logical, and physical data models along with corresponding metadata. Manages the DevOps pipeline deployment model, including automated testing procedures Performs the necessary data ingestion, cleansing, transformation, and coding of business rules to support annual Procurement bidding activities. Participate in compliance to system architecture, methods, standards and best practices.

Deploys data stewardship and data governance across our data warehouse, to cleanse and enhance our data, using knowledge bases and business rules. Support the deployment of a global data standard. Other Data Engineering duties as assigned.

**What are we looking for?**
- Bachelor’s degree in related field (Engineering, Computer Science, Data Science or similar)
- **2+ years of relevant experience **in BI Engineering, data modeling, data engineering, software engineering or other relevant roles.
- **SQL knowledge **and experience working with relational databases (SQL Server, Oracle, Azure SQL, etc.)
- Knowledge in DW/DL concepts, data marts, data modeling, **_ETL/ELT _**, data quality/stewardship, distributed systems, and metadata management.
- Knowledge on building and optimizing data pipelines, architectures, and data sets.
- Data manipulation with any programming language (Python + Pandas, SQL, C# etc.) and/or ETL/ELT development experience (2+ years, SSIS or ADF are preferred.)
- Ability to resolve ETL/ELT problems by proposing and implementing tactical/Strategic solutions.
- Project management and organizational skills.
- Experience with NoSQL databases is a plus.
- Excellent problem solving, critical thinking, and communication skills
- Experience with git repos (GitHub, GitLab, Azure DevOps) **is a plus**:

- Azure Data Engineering certification **is a plus **(DP-203)
- Due to the global nature of the role, proficiency in **English language is a must



  • Saltillo, México Johnson Controls A tiempo completo

    **Job Details** **What do you do?** Join us in the Procurement Execution Center as a **BI Engineer **. In this role, you will be responsible for implementing best-in-class Business Intelligence by deploying business analytics, data visualization, data modeling, data mining and infrastructure to help the organization make more data-driven decisions. **The...


  • 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 **BI Engineer **. In this role, you will be responsible for implementing best-in-class Business Intelligence by deploying business analytics, data visualization, data modeling, data mining and infrastructure to help the organization make more...


  • Saltillo, México Johnson Controls A tiempo completo

    **Job Details** **What do you do?** Join us in the Procurement Execution Center as a **BI Engineer **. In this role, you will be responsible for implementing best-in-class Business Intelligence by deploying business analytics, data visualization, data modeling, data mining and infrastructure to help the organization make more data-driven decisions. **The...


  • Saltillo, México Johnson Controls International A tiempo completo

    **What do you do?** Join us in the Procurement Execution Center as a BI Engineer III. In this role, you will be responsible for implementing best-in-class Business Intelligence by deploying business analytics, data visualization, data modeling, data mining and infrastructure to help the organization make more data-driven decisions. The BI Engineer is...


  • Saltillo, México Johnson Controls International A tiempo completo

    **What do you do?** Join us in the Procurement Execution Center as a BI Engineer III. In this role, you will be responsible for implementing best-in-class Business Intelligence by deploying business analytics, data visualization, data modeling, data mining and infrastructure to help the organization make more data-driven decisions. The BI Engineer is...


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


  • Saltillo, México Johnson Controls 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...


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


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


  • Saltillo, México Johnson Controls A tiempo completo

    **Job Details** **What you will do?** Join us in the Procurement Execution Center (PEC) as a **_Procurement Data Analytics Specialist _**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,...


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


  • Saltillo, México Johnson Controls A tiempo completo

    **What do you do?** Join us in the Procurement Execution Center as a **BI Engineer III **. In this role, you will be responsible for implementing best-in-class Business Intelligence by deploying business analytics, data visualization, data modeling, data mining and infrastructure to help the organization make more data-driven decisions. **The BI Engineer...


  • Saltillo, México Johnson Controls A tiempo completo

    **What do you do?** Join us in the Procurement Execution Center as a **BI Engineer I **. In this role, you will be responsible for implementing best-in-class Business Intelligence by deploying business analytics, data visualization, data modeling, data mining and infrastructure to help the organization make more data-driven decisions. **The BI Engineer...


  • Saltillo, México ABB A tiempo completo

    **Procurement and Planning Data Analyst**: **Take your next career step at ABB with a global team that is energizing the transformation of society and industry to achieve a more productive, sustainable future. At ABB, we have the clear goal of driving diversity and inclusion across all dimensions: gender, LGBTQ+, abilities, ethnicity and generations....


  • Saltillo, México Johnson Controls A tiempo completo

    **Job Details** **What you will do?** Join us in the Procurement Execution Center (PEC) as a **_Procurement Data Analytics Specialist _**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,...

  • Procurement Specialist

    hace 1 semana


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

  • Procurement Supervisor

    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 Supervisor - **Data Management **. In this role, you will be responsible for assisting the GP PEC Procurement Manager by project managing ERP/Data Management projects assignments for the PEC, together with supporting people processes and executing key...

  • Procurement Analyst I

    hace 3 semanas


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

  • Data Coordinator Ii

    hace 3 días


    Saltillo, México John Deere A tiempo completo

    **Title**: DATA COORDINATOR II - MONTERREY **Primary Location**: Mexico (MX) - Nuevo León **Function**: Administrative / Clerical**Main Responsibilities**: - Receipt of documents. - Audit management. - Customer records integration. - Warranty Administration. - Data upload. - Payment schedule. **What Skills You Need**: - Organization. - Administration. -...


  • Saltillo, México Johnson Controls A tiempo completo

    **Job Details** **Buyer **II** **What do you do?** Join us in the Procurement Execution Center as a Buyer II. This role works with the Category Management team in identifying, researching, evaluating, and selecting suppliers that meet the organization's standards of price, quality, timing, and reliability of supply. Sets and achieves day-to-day objectives...