Procurement BI Engineer II

Johnson Controls; Monterrey; Sur place; MXN 600 000 - 900 000; Plein temps

Résumé du poste

Johnson Controls is seeking a BI Engineer II to implement best-in-class business intelligence. You will scope, analyze, develop, automate, enhance, and validate BI reporting and dashboards to help the organization make data-driven decisions.

You will transform data into actionable insights, design scalable dashboards, and support procurement analytics with cross-functional collaboration. Proficiency in English is required for a global role.

Qualifications

• Bachelor's degree in a related field such as Engineering, Computer Science, Data Science, or similar.
• Minimum 4+ years of experience in BI, data engineering, or related fields.
• Strong SQL skills and ability to transform data into insights.
• Experience in Power BI applications and dashboard design.

Responsabilités

• Transform medium complexity data sets into meaningful conclusions and recommendations.
• Develop and maintain interactive dashboards on Power BI or similar tools.
• Produce automated reporting systems and scorecards for stakeholders.
• Support data visualization by tuning queries and resolving data issues.
• Design and build reports such as Scorecards and Compliance reports.
• Collaborate with end users to translate needs into data models and reports.
• Own the analytics metrics and dashboards used to drive decisions.

Connaissances

Power BI

SQL

Data Visualization

Python

Stakeholder communication

English proficiency

Formation

Bachelor's degree in related field

Outils

Power BI

SQL

Description du poste

Johnson Controls, a global leader in thermal management, mission-critical building systems, energy efficiency, and decarbonization, helps customers use energy more productively, reduce carbon emissions, and operate with the precision and resilience required in rapidly expanding industries such as data centers, healthcare, pharmaceuticals, advanced manufacturing, and higher education. For more than 140 years, Johnson Controls has delivered performance where it really matters. Backed by advanced technology, lifecycle services and an industry-leading field organization, we elevate customer performance, turn goals into real-world results and help move society forward.

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 Power Bi 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. Logistics, 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.

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 Power BI applications to effectively visualize and demonstrate proposed user interface dashboard and scorecard solutions.
• Experience in developing, maintaining and managing Power BI dashboards & analytics.
• 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.
• Johnson Controls does not request pregnancy or HIV testing as a condition for hiring, continued employment, or promotion, in accordance with its commitment to labor equality and non-discrimination.

Johnson Controls: Enhancing the Intelligence of Buildings Your buildings have a purpose. They are places for people to live or work. Facilities for learning or healing. Venues for entertainment and shopping. Sites for the specialized storage of tangible goods or mission-critical data. Your buildings have a huge variety of functions; they are central to your mission. This is where Johnson Controls comes in, helping drive the outcomes that matter most. Through a full range of systems and digital solutions, we make your buildings smarter. A smarter building is safer, more comfortable, more efficient, and, ultimately, more sustainable. Most important, smarter buildings let you focus more intensely on your unique mission. Better for your people. Better for your bottom line. Better for the planet. At Johnson Controls, we’ve been making buildings smarter since 1885, and our capabilities, depth of innovation experience, and global reach have been growing ever since. Today, we offer the world’s largest portfolio of building products, technologies, software, and services; we put that portfolio to work to transform the environments where people live, work, learn and play.