Procurement Bi Engineer Ii

Johnson Controls, Inc.; San Pedro Garza García; Presencial; MXN 500,000 - 800,000; Jornada completa

Descripción de la vacante

A global technology leader is seeking a BI Engineer II in San Pedro Garza García, Nuevo León. The role involves implementing business intelligence through data visualization and analytics solutions. The ideal candidate will transform data sets into actionable insights, develop dashboards using Tableau or Power BI, and support procurement activities. A Bachelor's degree and over 4 years of relevant experience are required, along with medium SQL skills and proficiency in data storytelling. Advanced English is essential for this global role.

Formación

• 4+ years of relevant experience in Business Intelligence or related fields.
• Experience configuring and using Tableau or Power BI for dashboard solutions.
• Ability to adhere to deadlines in a competing priorities environment.

Responsabilidades

• Transform medium complexity data sets into insights and recommendations.
• Develop and maintain interactive dashboards using Tableau or other tools.
• Support data visualization by monitoring queries and troubleshooting issues.
• Design and build business-critical reports and support procurement activities.

Conocimientos

SQL skills

Data analysis

Data visualization

Communication skills

Storytelling with data

Change implementation

Educación

Bachelor’s degree in Engineering, Computer Science, or Data Science

Herramientas

Tableau

Power BI

Python

Alteryx

SSIS

Descripción del empleo

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 cities and communities. Our commitment to sustainability dates back to our roots in 1885, with the invention of the first electric room thermostat. We are committed to helping our customers win and creating greater value for all of our stakeholders through strategic focus on our buildings and energy growth platforms. For additional information, please visit www.johnsoncontrols.com or follow us @johnsoncontrols on Twitter.

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 BI Engineer is expected to scope, analyze, develop, automate, enhance, and validate BI reporting & analytics, and dashboard solutions in a timely manner.

How you will do it? Essential Job Responsibilities

• Transform medium complexity data sets into meaningful conclusions and recommendations,
• Develop, design, and maintain interactive dashboards on Tableau or other visualization tools.
• Produce and maintain scaled, automated, user-friendly reporting systems and dashboards.
• Support the data visualization process by monitoring and tuning queries and data loads, addressing user questions concerning data integrity, and troubleshooting functional and technical issues.
• Design and build of business-critical reports such as Scorecards and Compliance reports.
• Work with end users to understand their conceptual needs to production.
• Clearly understand and document conceptual requirements and build/request the data models needed to deliver the final report. Own the design, development, and maintenance of ongoing metrics, reports, and analyses used to drive key business decisions per the Execution Center plan.
• Support annual activities and RFPs for Procurement Categories (i.e. MRO, Professional Svcs, Fleet, etc.) by performing data extraction, data cleansing, and data prep for bidding purposes.
• Trains the Stakeholders from the corresponding business group by creating their dashboard together with them and by boosting our Dashboards usage.
• Other duties as assigned by your Manager.

What we look for? Position Requirements

• Bachelor’s degree in related field (Engineering, Computer Science, Data Science or similar)
• 4 + years of relevant experience in Business Intelligence, BI Data Engineering or other related fields
• Medium SQL skills for acquiring and transforming data
• Proficiency to draw insights from data and clearly communicate (verbal/written) information to stakeholders and senior management as required
• Experience configuring and using Tableau or Power BI applications to effectively visualize and demonstrate proposed user interface dashboard and scorecard solutions.
• Experience in developing, maintaining and managing Tableau/Power BI dashboards & analytics.
• Knowledge of ETL/ELT design/development using either Alteryx or SSIS.
• Understanding of high-level programming languages. Python preferred.
• Ability to analyze and extract relevant information from large, complicated data sets of structured and unstructured data.
• Ability to adhere to plan developments, resolve roadblocks and adhere deadlines in a competing priorities environment.
• Demonstrate ability to story tell with data, as well as identify and root-cause both outliers and critical errors within the data.
• Demonstrate ability to identify and implement change, drive results, provide value-added analysis to assist Procurement leaders make informed decisions.
• Given the global nature of the role, advanced English is a must.