Logistics Prmt Sr Data Architect
Johnson Controls
San Pedro Garza García, Nuevo León, México
hace 18 horas
source : JobLeads

LogisticsProcurement Sr. Data & BI Analyst

What you will do :

Job Scope & Purpose :

  • Supportthe Global Logistics Procurement team, as a Global Center of Excellencesupporting EMEA, LATAM, APAC and NA.
  • Drivedata management, data governance, and business intelligence globally for the LogisticsProcurement group.
  • Supportmanagement of Johnson Controls Logistics procurement activities being performedglobally to achieve best in class performance.
  • Responsibleto provide insightful analytics to support data-driven decision making and value-generatinginitiatives.
  • SupportGlobal RFP initiatives to support Logistics best-in-class procurement andoperations.
  • Ensuringcompliance with policies and procedures established by the company in terms ofsupplies and make sure is well documented.
  • Generationof Scorecards and Compliance reports to drive operational excellence withinLogistics.
  • How you will doit :

    Essential Job Responsibilities :

  • Implementand establish automation where possible for all Data extraction, transformationand reporting processes, using software as required (SSIS, SSMS, Access,Macros, etc)
  • Developand maintain Routing Compliance reports for Logistics Ops compliance.
  • SupportLogistics Leads by designing, developing and publishing Dashboards that supportData Driven decision making.
  • Supportdaily / weekly ETL Process from multiple data sources.
  • Developmentand monthly publication of carrier scorecards and Logistics KPIs. Process willrequire the Analyst to perform multiple data wrangling and data structuringactivities to ensure meaningful data, using multiple data sources.
  • Supportannual activities and RFPs for Transportation (i.e. Ocean, TL, LTL, etc),including Data cleansing, data wrangling, data transformation and data prep forRFP purposes.
  • Prepareand analyze Bid Results, by supporting Bid Optimization, as well as providingNegotiation Workbooks, Bid Results, among other reports.
  • LeadData Quality and Knowledge Base creations for our multiple data sources.
  • Responsiblefor preparing statistical reports and dashboards regarding spend and / oroperational performance on the required basis (e.
  • g. monthly, quarterly,annually).

  • Support annual activities and RFPs (i.e. Ocean bid, TL bid, etc.)
  • Supportprocurement RFPs and projects in alignment with the appropriate CategoryManagers.
  • Increaserouting compliance and an improved SRM by ensuring RFP award compliancethroughout the organization.
  • DriveInnovation, continuous improvement and operational excellence for globalLogistics Procurement and global Logistics Operations.
  • OtherProcurement duties as assigned.
  • What we look for :

    Position Requirements

  • Bachelor’s degree in related field (Engineering, Computer Science, DataScience or similar)
  • 6+ years of experience in Data Analytics or BI on related fields (e.g.Procurement, Logistics, Transportation, Supply Chain).
  • Advanced MS Excel and Visual Basic (Macros, Data Modeling, Power Query DAX / M , mega-formulas, etc).
  • Advanced MS Access skills (Queries, macros, External connections)
  • Proficiency in T-SQL (Queries, subqueries, database admin, etc.)
  • Data visualization software. Tableau preferred; Power BI is a plus.
  • Strong analytical and problem-solving skills with a proactive andsolution-oriented approach toward business issues
  • Ability to convey technical processes to business partners in a clearand meaningful way
  • 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 balance competing priorities.
  • Johnson Controls does not request pregnancy or HIV testing as arequirement for admission, permanence or promotion

    Additional Information

  • Overtime Status : Exempt
  • Previous Job Searches

    My Profile

    Create and manage profiles for future opportunities.

    Mexico, Nuevo León, San Pedro Garza Garcia

    Mexico, Nuevo León, San Pedro Garza Garcia

    Mexico, Nuevo León, San Pedro Garza Garcia

    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