Power BI Architect & AI Analytics Leader

Johnson Controls, Inc.; San Pedro Garza García; Presencial; MXN 600.000 - 900.000; Jornada completa

Descripción de la vacante

Johnson Controls, Inc. seeks an experienced BI Architect to design enterprise BI solutions, including Power BI dashboards and scorecards, and to develop AI-enabled analytics across the organization.

You will gather requirements from stakeholders, lead technical design, and mentor team members while leveraging the Microsoft analytics stack. Based in Mexico, the role emphasizes data quality, performance tuning, and cross-functional collaboration.

Formación

• Bachelor's degree or higher in engineering/IT/math/statistics required.
• Minimum 7-10 years of data analytics experience preferred.
• Strong SQL and data analysis skills needed.

Responsabilidades

• Analyze software systems data and recommend data analytics solutions and strategy.
• Expand or modify solutions to meet technical and business specs; test, maintain, and monitor programs.
• Design and develop Scorecards and Dashboards using Power BI for various organizational metrics and KPIs.
• Develop overall Project technical design for report and dashboard development.
• Create enterprise-grade analytics solutions for internal & external customers.
• Develop new reports and enhance existing reports using standards and best practices.
• Build test cases and test plans to ensure data quality.
• Incorporate AI functionality into reports.
• Performance tuning of reports.
• Elicit business requirements from SMEs via interviews and workshops.
• Develop logic for reporting and analytics from gathered requirements.
• Understand data standards & identify data abnormalities.
• Lead and mentor team members.
• Perform statistical analysis and build predictive models.
• Build end-to-end automated analytics using Power BI, Power Apps and Microsoft Flow.
• Maintain data quality across solutions and align with customers and other data teams.

Conocimientos

SQL

Data analysis

Statistical modelling

Analytical thinking

Educación

Bachelor's degree or higher in engineering/IT/math/statistics

Herramientas

Power BI

Power Query

Fabric

DAX

T-SQL

SSRS

SSAS

Visual Studio Data Tools

SQL Server Management Studio

SQL Server Data Tools

GitHub

Azure Data Factory

Azure Data Lake

Azure SQL DW

Azure SQL

Power Apps

Microsoft Flow

Copilot

Foundry

Toad

Descripción del empleo

Johnson Controls, Inc. seeks an experienced BI Architect to design enterprise BI solutions, including Power BI dashboards and scorecards, and to develop AI-enabled analytics across the organization.

You will gather requirements from stakeholders, lead technical design, and mentor team members while leveraging the Microsoft analytics stack. Based in Mexico, the role emphasizes data quality, performance tuning, and cross-functional collaboration.