Logistics Prmt Data Analyst
Johnson Controls
San Pedro Garza Garcia, Nuevo León, Mexico
hace 2 días

Logistics Procurement Data Analyst

Whatyou will do :

Job Scope & Purpose :

  • Support the Global Logistics Procurementteam, as a Global Center of Excellence supporting EMEA, LATAM, APAC and NA.
  • Annual activities and RFPs for Transportation (i.e. Ocean, TL, LTL,etc), including Data cleansing, data wrangling, data transformation and dataprep for RFP purposes.
  • Enable process automation by using VBA, Access, SQL, SSIS or similar, toenable multiple reports, including RFP Data Prep, Savings automations, RoutingCompliance reports, Negotiation Workbooks, among others.
  • Provide insightful analytics to support data-driven decision making andvalue-generating initiatives, including data extraction, data cleansing anddata analysis
  • Support data cleansing, data extraction and data normalization tasks.
  • How youwill do it :

    Essential Job Responsibilities :

  • Provides analytics and insights by coordinating data extraction fromvarious databases and data interpretation.
  • Support maintenance and update of Mode-Specific Routing Compliancereports.
  • Support of monthly publication of carrier scorecards and Logistics KPIs.Process will require the Analyst to perform multiple data wrangling and datastructuring activities to ensure meaningful data, using multiple data sources.
  • Work together with the Logistics Procurement Specialist for RFP Support,including data extraction, data normalization preparation and analysis of BidResults, development of Negotiation Workbooks, Bid Results, among otherreports.
  • Support data cleansing and structuring behind BI Dashboard requirements.
  • Development of a KBS for data cleansing (Geographical location,supplier / shipper information, etc.)
  • Support procurement RFPs and projects in alignment with the appropriateCategory Managers.
  • Responsible for preparing statistical reports and dashboards regardingspend and / or operational performance on the required basis (e.
  • g. monthly,quarterly, annually).

  • Drive Benchmarking Analytics reports, including FTL and OceanBenchmarking tools (i.e. FMIC, DAT, Drewry, etc).
  • Update rate addendums, manage pricing changes, and ensure prices are upto date on any used platforms (e.g. Ariba, Proship, TMS).
  • Identify all diversity carriers and measure monthly diversitycompliance.
  • Support DocuSign process as required for Rate Addendums and ContractExecution.
  • Other Procurement duties as assigned.
  • What welook for :

    Position Requirements :

  • Bachelor’s degree in related field (Engineering, Computer Science, DataScience or similar)
  • 2+ years of experience in Data Analytics or BI on related fields (e.g.Procurement, Logistics, Transportation, Supply Chain).
  • Advanced MS Excel and Advanced MS Access. VBA is a plus.
  • T-SQL is required. Other SQL Server packages are a plus (SSRS, SSIS,DQS).
  • Power Query language such as M or DAX is preferred.
  • Knowledge of Python and usage of pandas preferred. Other libraries fordata analysis are a plus.
  • Knowledge of statistics and experience using statistical or databasepackages.
  • Strong analytical and problem-solving skills with a proactive andsolution-oriented approach toward business issues
  • Ability to build rapport, cultivate working relationships and drivecollaboration across teams
  • Demonstrate commitment to continuous improvement in a dynamicenvironment, striving to exceed expectations
  • Demonstrate ability to identify and implement change, drive results,provide value-added analysis to assist Procurement and Logistics leaders makeinformed decisions.
  • Strong interpersonal, written, and verbal communication skills; comfortin operating within a dynamic, complex and matrixed organizational structure;
  • ability to establish credibility throughout the organization in processes andpeople by demonstrating JCI Values

  • Ability to convey technical processes to business partners in a clearand meaningful way
  • Johnson Controls does not request pregnancy or HIVtesting as a requirement for admission, permanence or promotion.

    Additional Information

  • Overtime Status : Non-exempt
  • Reportar esta oferta

    Thank you for reporting this job!

    Your feedback will help us improve the quality of our services.

    Mi Correo Electrónico
    Al hacer clic en la opción "Continuar", doy mi consentimiento para que neuvoo procese mis datos de conformidad con lo establecido en su Política de privacidad . Puedo darme de baja o retirar mi autorización en cualquier momento.
    Formulario de postulación