Procurement Data Engineer Iii

hace 2 meses


San Pedro Garza García N L, México Johnson Controls International A tiempo completo

**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 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?**
- ** Serve as the main technical resource for any data-related requirement**
- ** Demonstrate an ability to communicate technical knowledge through project management and contributions to product strategy**
- Deploy data ingestion processes through Azure Data Factory to load data models as required into Azure Synapse.
- Build and design **complex** ETL/ELT processes with Azure Data Factory (ADF) and/or Python, which once deployed, will require to be executed daily and weekly.
- Assemble large, complex data sets that meet functional / non-functional business requirements.
- Build the infrastructure required for optimal ETL/ELT of data from a wide variety of data sources using Azure SQL and ADF.
- 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
- Deploys data stewardship and data governance across our data warehouse, to cleanse and enhance our data, using knowledge bases and business rules.
- ** Ensure compliance to system architecture, methods, standards, practices and participate in their creation**
- ** Clearly articulate and effectively influence both business and technical teams**
- Performs the necessary data ingestion, cleansing, transformation, and coding of business rules to support annual Procurement bidding activities.
- ** Support the deployment of a global data standard for Logistics.**
- Create data tools for analytics and data scientist team members that assist them in building and optimizing our product into an innovative industry leader.
- ** Support Rate Repository management as required (including Rate Card uploads to our DW).**
- Other Procurement duties as assigned.

**What are we looking for?**
- Bachelor’s degree in related field (Engineering, Computer Science, Data Science or similar)
- 4+ years of relevant experience in BI Engineering, data modeling, data engineering, software engineering or other relevant roles.
- Advanced working SQL knowledge and experience working with relational databases.
- Knowledge in DW/DL concepts, data marts, data modeling, ETL/ELT, data quality/stewardship, distributed systems and metadata management.
- Experience building and optimizing data pipelines, architectures, and data sets.
- Azure Data Engineering certification preferred (DP-203)
- ETL/ELT development experience (3+ years). SSIS or ADF are preferred.
- Ability to resolve ETL/ELT problems by proposing and implementing tactical/Strategic solutions.
- Strong project management and organizational skills.
- Experience with object-oriented function scripting languages: Python, Scala, C#, etc.
- Experience with NoSQL databases is a plus to support the transition from On-Prem to Cloud.
- Excellent problem solving, critical thinking, and communication skills
- Relevant experience with Azure DevOps (CI/CD, git/repo management)
- Due to the global nature of the role, proficiency in English language is a must.

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



  • San Pedro Garza García, Nuevo León, México Johnson Controls A tiempo completo

    Job SummaryJohnson Controls is seeking a highly skilled Data Engineer to join our Procurement Execution Center. As a key member of our team, you will be responsible for designing, developing, and maintaining data pipelines and architectures to support our procurement operations.Key ResponsibilitiesDesign and implement data ingestion processes using Azure...


  • san pedro garza garcía, México Johnson Controls A tiempo completo

    Johnson Controls is a global diversified technology and multi industrial leader serving a wide range of customers in more than 150 countries. Our 130,000 employees create intelligent buildings, efficient energy solutions, integrated infrastructure and next generation transportation systems that work seamlessly together to deliver on the promise of smart...


  • San Pedro Garza García, Nuevo León, México Johnson Controls A tiempo completo

    Johnson Controls is a global leader in diversified technology and multi-industrial solutions. Our 130,000 employees create intelligent buildings, efficient energy solutions, and integrated infrastructure that work together to deliver on the promise of smart cities and communities. Our commitment to sustainability dates back to 1885, with the invention of the...


  • San Pedro, México Johnson Controls A tiempo completo

    Johnson Controls is a global diversified technology and multi industrial leader serving a wide range of customers in more than 150 countries. Our 130,000 employees create intelligent buildings, efficient energy solutions, integrated infrastructure and next generation transportation systems that work seamlessly together to deliver on the promise of smart...


  • San Pedro Garza García, N. L., México Johnson Controls A tiempo completo

    **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 BI Engineer** is...


  • san pedro garza garcía, México Johnson Controls A tiempo completo

    Johnson Controls is a global diversified technology and multi industrial leader serving a wide range of customers in more than 150 countries. Our 130,000 employees create intelligent buildings, efficient energy solutions, integrated infrastructure and next generation transportation systems that work seamlessly together to deliver on the promise of smart...


  • san pedro garza garcía, México Johnson Controls A tiempo completo

    Johnson Controls is a global diversified technology and multi industrial leader serving a wide range of customers in more than 150 countries. Our 130,000 employees create intelligent buildings, efficient energy solutions, integrated infrastructure and next generation transportation systems that work seamlessly together to deliver on the promise of smart...


  • San Pedro Garza García, Nuevo León, MX Johnson Controls International A tiempo completo

    Johnson Controls is a global diversified technology and multi industrial leader serving a wide range of customers in more than 150 countries. Our 130,000 employees create intelligent buildings, efficient energy solutions, integrated infrastructure and next generation transportation systems that work seamlessly together to deliver on the promise of smart...

  • Data Engineer III

    hace 3 semanas


    San Pedro Garza García, Nuevo León, México Johnson Controls A tiempo completo

    Procurement Data Engineering RoleJohnson Controls is a global leader in technology and industry, serving a wide range of customers worldwide. Our employees create innovative solutions for smart cities and communities. We are committed to sustainability and customer success through strategic focus on our growth platforms.Key Responsibilities:Serve as the...


  • San Pedro Garza García, N. L., México Johnson Controls A tiempo completo

    **What you will do? Job Scope & Purpose** Join us in the Procurement Execution Center as a BI Engineer II. 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...


  • San Pedro Garza García, Nuevo León, México Johnson Controls A tiempo completo

    Job Title: Procurement BI Engineer IIIAbout the Role:As a Procurement BI Engineer III at Johnson Controls, you will play a key role in implementing best-in-class Business Intelligence solutions to help the organization make more data-driven decisions. You will be responsible for deploying business analytics, data visualization, data modeling, data mining,...


  • San Pedro Garza García, Nuevo León, México Johnson Controls A tiempo completo

    Procurement BI EngineerAbout the Role:We are seeking a highly skilled Procurement BI Engineer to join our team at Johnson Controls. As a key member of our Procurement Execution Center, you will be responsible for designing, developing, and maintaining business-critical reports and analytics solutions to drive informed decision-making.Key...


  • San Pedro Garza García, Nuevo León, México Johnson Controls A tiempo completo

    Job Summary:We are seeking a skilled Data Engineer to join our Procurement Execution Center as a key member of our diverse team. As a Data Engineer, you will be responsible for deploying and managing the end-to-end data management of our business, including ETL/ELT, data warehousing, data staging, data governance, and data quality.Key Responsibilities:Serve...


  • san pedro garza garcía, México Johnson Controls A tiempo completo

    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 BI Engineer is expected to...


  • San Pedro Garza García, Nuevo León, México Johnson Controls A tiempo completo

    Johnson Controls is a global leader in diversified technology and multi-industrial solutions. Our 130,000 employees create intelligent buildings, efficient energy solutions, and next-generation transportation systems that work together to deliver on the promise of smart cities and communities.As a Procurement Specialist III, you will be responsible for...


  • San Pedro Garza García, Nuevo León, MX Johnson Controls International A tiempo completo

    Johnson Controls is a global diversified technology and multi industrial leader serving a wide range of customers in more than 150 countries. Our 130,000 employees create intelligent buildings, efficient energy solutions, integrated infrastructure and next generation transportation systems that work seamlessly together to deliver on the promise of smart...

  • Procurement Expert III

    hace 5 días


    San Pedro Garza García, Nuevo León, México Johnson Controls A tiempo completo

    Job SummaryWe are seeking a skilled Procurement Expert III to join our team at Johnson Controls. This is an exciting opportunity for a motivated professional to develop their skills in procurement and customer service.About the RoleIn this role, you will be responsible for receiving and processing purchase orders in accordance with company policies and...


  • San Pedro Garza García, Nuevo León, México Johnson Controls A tiempo completo

    Job DescriptionWe are seeking a highly skilled Strategic Data Engineer to join our team at Johnson Controls, driving the transformation of procurement through innovative data-driven solutions.Key Responsibilities:Develop and implement advanced data analytics capabilities to drive business insights and decision-making.Design, develop, and maintain scalable...


  • San Pedro Garza García, N. L., México Johnson Controls A tiempo completo

    **What you will do** The Procurement Operations Analyst is responsible for overseeing and managing the Procurement-PTP project. This role requires a broad understanding of procurement processes, data analystics skills as well as effective outreach to key stakeholders and cross-functional collaboration with procurement, accounts payable, field operations,...


  • San Pedro Garza García, Nuevo León, México Johnson Controls A tiempo completo

    Key Responsibilities:In this role, as a Business Intelligence Engineer at Johnson Controls, you will be responsible for designing, developing, and implementing best-in-class Business Intelligence solutions. Your primary focus will be on deploying business analytics, data visualization, data modeling, data mining, and infrastructure to help the organization...