Power BI Architecture Lead — Data Dashboards & AI Insights

Johnson Controls; San Pedro Garza García; Sur place; MXN 900 000 - 1 400 000; Plein temps

Résumé du poste

Johnson Controls seeks a BI Architect to design enterprise-grade dashboards and analytics. You will gather requirements, document processes, and deliver Power BI reports and AI-enhanced solutions across teams. You will mentor others and ensure data quality while aligning with stakeholders.

Required are a strong analytics background, 7–10 years in data roles, and expertise in the Microsoft analytics stack including Power BI, DAX, SSAS, and Azure data services.

Qualifications

• Bachelor degree or higher in engineering, IT, economics, math, statistics, science or related fields.
• 7-10 years of experience in related data roles.

Responsabilités

• Analyze software systems data and recommend analytics solutions and strategy based on organizational needs.
• Expand or modify solutions to meet technical and business specifications; 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.
• Develop enterprise-grade analytics solutions for internal & external customers.
• Develop new reports and enhance existing reports using industry standards and best practices.
• Build test cases and test plans for testing of reports to ensure data quality.
• Incorporate AI functionality into existing or new reports.
• Performance tuning of reports.
• Elicit business requirements from Subject Matter Experts using interviews, document analysis and requirements workshops.
• Use gathered requirements to develop logic for reporting and analytics.
• Understand data standards & identify data abnormalities.
• Lead and provide technical guidance and mentorship to other team members.
• Perform statistical analysis, build predictive models, and formulate decision models that relate operational activities to results; drive value stream enhancement and continuous improvement.
• Build end to end automated analytical solutions using Power BI, Power Apps and Microsoft Flow.
• Understand data standards and identify data abnormalities; instill data quality in all solutions delivered.
• Maintain close alignment with all customers and other data reporting teams to ensure requirements are met.

Connaissances

SQL

PL/SQL

Analytical thinking

Interpersonal communication

Formation

Bachelor degree or higher in engineering, IT, economics, math, statistics, science or related fields

Outils

Power BI

Power Query

Fabric

DAX

T-SQL

SSRS

SSAS

Visual Studio Data Tools

GitHub

Azure Data Factory

Azure Data Lake

Azure SQL DW

Azure SQL

Power Apps

Microsoft Flow

Toad

Office 365

Description du poste

Johnson Controls seeks a BI Architect to design enterprise-grade dashboards and analytics. You will gather requirements, document processes, and deliver Power BI reports and AI-enhanced solutions across teams. You will mentor others and ensure data quality while aligning with stakeholders.

Required are a strong analytics background, 7–10 years in data roles, and expertise in the Microsoft analytics stack including Power BI, DAX, SSAS, and Azure data services.