Procurement Data Engineer Associate

hace 3 semanas

San Pedro Garza García Nuevo León MX 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 layers of data required to enable a successful BI, Reporting and Analytics 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 large 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.

-Utilizes the DevOps pipeline deployment model, including automated testing procedures.

-Executes data stewardship and data quality across our data marts, to cleanse, enrich and correct issues in our data, using knowledge bases and business rules.

-Performs the necessary data ingestion, cleansing, transformation, and coding of business rules to support annual Procurement bidding activities. 

-Other Data Engineering duties as assigned.

What are we looking for?

  • Bachelor’s degree in related field (Engineering, Computer Science, Data Science or similar)

  • 1+ years of relevant experience in data analytics roles, data engineering, software engineering or other relevant data roles.

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

  • Data manipulation with any programming language (Python + Pandas, SQL, etc.) and/or ETL/ELT development experience (1+ years, SSIS or ADF are preferred.)

  • Ability to resolve ETL/ELT problems by proposing and implementing tactical/Strategic solutions.

  • 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

  • Experience with git/repo management is a plus

  • Due to the global nature of the role, proficiency in English language is a must

  • Procurement Data Engineer Associate

    hace 3 semanas

    San Pedro Garza García, 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 layers...

  • Procurement Data Engineer Associate

    hace 3 semanas

    San Pedro Garza García, 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 layers of data...

  • Procurement Data Engineer Associate

    hace 2 semanas

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

  • Procurement Data Engineer Associate

    hace 3 semanas

    Nuevo León, 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 layers of...

  • Procurement BI Engineer

    hace 3 semanas

    San Pedro Garza García, Nuevo León, MX Johnson Controls International 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 BI Engineer is...

  • Procurement BI Engineer II

    hace 2 semanas

    San Pedro Garza García, Nuevo León, MX 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 expected to...

  • Procurement BI Engineer

    hace 4 semanas

    San Pedro Garza García, México Johnson Controls International 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 BI Engineer is...

  • Procurement BI Engineer II

    hace 4 semanas

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

  • Procurement BI Engineer

    hace 3 semanas

    San Pedro Garza García, N.L., México Johnson Controls International 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 BI...

  • Procurement BI Engineer

    hace 4 semanas

    San Pedro Garza García, N.L., México Johnson Controls, Inc. 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 BI...

  • Procurement BI Engineer

    hace 3 semanas

    San Pedro Garza García, N.L., México Johnson Controls International 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 BI...

  • Procurement BI Engineer II

    hace 2 semanas

    San Pedro Garza García, 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 expected to...

  • Procurement BI Engineer

    hace 2 semanas

    San Pedro Garza Garcia Centro, México Johnson Controls International 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 BI Engineer is...

  • Procurement BI Engineer II

    hace 2 semanas

    San Pedro Garza García, N.L., 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 expected...

  • Procurement BI Engineer II

    hace 2 semanas

    San Pedro Garza García, N.L., 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 expected...

  • Procurement BI Engineer

    hace 3 semanas

    Nuevo León, México Johnson Controls International 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 BI...

  • Costing Engineer

    hace 3 semanas

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

    What do you do?Join us in the Procurement Execution Center as a Procurement Product-Costing Engineer.In this role, you will be responsible for executing our Competitive Product Cost Analysis (CPC) playbook, by performing data collection, interpreting drawings, consolidating data, finding material price differences, and building the foundation for statistical...

  • Procurement BI Engineer II

    hace 2 semanas

    San Pedro Garza Garcia Centro, 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 expected to...

  • Procurement BI Engineer II

    hace 2 semanas

    Nuevo León, 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...

  • Costing Engineer

    hace 3 semanas

    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 Procurement Product-Costing Engineer . In this role, you will be responsible for executing our Competitive Product Cost Analysis (CPC) playbook, by performing data collection, interpreting drawings, consolidating data, finding material price differences, and building the foundation for...