Pcrmt Data Analytics Spec

hace 1 semana

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 Analytics Specialist **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

  • Practicante de Data Analytics

    hace 2 semanas

    Saltillo, México CELEKTA A tiempo completo

    **PRACTICANTE DE DATA ANALYTICS** **Estudiantes Activos de la Carrera**:Ciencias Computacionales Ing. Computacional Sistemas de Información, Ciencia de datos o alguna Ingeniería afín. **Habilidades**: - Proyectos tecnológicos en diferentes areas del Enterprise Technology and Engineering Center para resolver problemas usando data anaytics. - Adquirir...

  • Practicante de Data Analytics

    hace 2 semanas

    Saltillo, México CELEKTA A tiempo completo

    **PRACTICANTE DE DATA ANALYTICS****Estudiantes Activos de la Carrera**:Ciencias Computacionales Ing. Computacional Sistemas de Información, Ciencia de datos o alguna Ingeniería afín.**Habilidades**:- Proyectos tecnológicos en diferentes areas del Enterprise Technology and Engineering Center para resolver problemas usando data anaytics.- Adquirir datos de...

  • Practicante de Data Analytics

    hace 1 semana

    Saltillo, México CELEKTA Consulting A tiempo completo

    Practicante de Data Analytics - John DeereUbicación: Av. Lázaro Cárdenas 2321, Residencial San Agustín, Zona Loma Larga Oriente, 66260 San Pedro Garza García, N.L., México.Carreras**:Ciencias Computacionales, Ingeniera Computacional, Sistemas de Información, Ciencia de datos.**Horario: 8:00 am - 4:00 pm (Modalidad Hibrida y con posible regreso a...

  • Procurement Data Analytics Specialist

    hace 3 semanas

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

  • Pcrmt Analyst Ii

    hace 2 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 the...

  • Pcrmt Analyst Ii

    hace 1 semana

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

  • Pcrmt 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 Data Analytics Specialist

    hace 3 semanas

    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 Analytics Specialist

    hace 2 semanas

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

  • Finance Manager(Data Analytics)

    hace 7 días

    Saltillo, México Johnson Controls A tiempo completo

    **Job Details****What you will do**The GP Finance Manager (Data Analytics) will be responsible for ERP project Record-to-Report process rationalization, mapping, simplification, and harmonization at enterprise level. In addition to that, this role will support Finance Director SAP & PMO Manager in RTR processes model design, its governance and going forward...