workday
Business Intelligence Architect
Johnson Controls
Pune, IND
Full-time
Senior · 7–10 years experience
Discovered 3 days ago
azureazure-data-factorypower-bisql
Key Skills for This Role
azureazure-data-factorypower-bisql
Full Job Posting
JOB RESPONSIBILITIES:
- Responsible for analysing software systems data and recommending Data Analytics solutions and strategy based on the needs of the organization.
- 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.
- Responsible for enterprise-grade analytics solutions for internal & external customer.
- Development of new reports and enhancement of 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 the 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; to 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 (internal, external, management and at the field level) and other data reporting teams to ensure requirements are being met.
- EDUCATION & EXPERIENCE:
- Bachelor degree or higher from a reputed university in engineering, IT, economics, math, statistics, science or other related fields in quantitative or analytical discipline.
- Minimum 7-10 years of experience in related data roles.
- SKILL:
- Excellent skill level in SQL, PL/SQL.
- In-depth experience with Microsoft analytics Stack (Power BI, Power Query, Fabric, DAX, T-SQL, SSRS, SSAS)
- Advanced knowledge Power BI.
- Proficient in DAX, M language.
- Experience with Associated Development Tools - Visual Studios Data Tools, SQL Server Management Studio, SQL Server Data Tools, Microsoft TFS, GitHub.
- Working knowledge of Fabric Data Agent, Copilot, Microsoft Foundry.
- Knowledge of working with database client tools such as Toad.
- Knowledge of Data Mining, Clustering & Statistical Modelling (preferred).
- Experience with Azure Machine Learning (AML). Understanding of Azure and its data services.
- Knowledge of Azure Data Factory, Azure Data Lake, Azure SQL DW and Azure SQL.
- Experience with Microsoft Flow and Microsoft Power Apps preferred.
- Proficient in Microsoft Office Suite and O365.
- Superior documentation and organizational skills. Must be detail oriented.
- Excellent critical-thinking skills with the ability to research and analyze data retrieved from multiple sources
- Must possess and demonstrate excellent verbal, written, and interpersonal communications skills.
- Must be an adaptable self-starter and work with minimal supervision. Must be able to handle multiple projects and organize time effectively.
- Must be willing to put in extra time and effort if need be. Go above and beyond the requirements of the job and strive to exceed expectations.
Qualifications
- Bachelor degree or higher from a reputed university in engineering, IT, economics, math, statistics, science or other related fields in quantitative or analytical discipline.
- Minimum 7-10 years of experience in related data roles.
- Excellent skill level in SQL, PL/SQL.
- In-depth experience with Microsoft analytics Stack (Power BI, Power Query, Fabric, DAX, T-SQL, SSRS, SSAS)
- Advanced knowledge Power BI.
- Proficient in DAX, M language.
- Experience with Associated Development Tools - Visual Studios Data Tools, SQL Server Management Studio, SQL Server Data Tools, Microsoft TFS, GitHub.
- Working knowledge of Fabric Data Agent, Copilot, Microsoft Foundry.
- Knowledge of working with database client tools such as Toad.
- Experience with Azure Machine Learning (AML). Understanding of Azure and its data services.
- Knowledge of Azure Data Factory, Azure Data Lake, Azure SQL DW and Azure SQL.
- Proficient in Microsoft Office Suite and O365.
- Superior documentation and organizational skills. Must be detail oriented.
- Excellent critical-thinking skills with the ability to research and analyze data retrieved from multiple sources
- Must possess and demonstrate excellent verbal, written, and interpersonal communications skills.
- Must be an adaptable self-starter and work with minimal supervision. Must be able to handle multiple projects and organize time effectively.
- Must be willing to put in extra time and effort if need be. Go above and beyond the requirements of the job and strive to exceed expectations.
Preferred Qualifications
- Knowledge of Data Mining, Clustering & Statistical Modelling (preferred).
- Experience with Microsoft Flow and Microsoft Power Apps preferred.
About Johnson Controls
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at Johnson Controls
Business Support Champion
Orlando, USA
MidFull-time
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
Discovered TodayView →
VP & Managing Director, Global Data Center Solutions [Remote]
Milwaukee, USA
ExecutiveFull-time
ROLE OVERVIEW The Managing Director, Global Data Centers exists to own the strategic relationship with a designated hyperscaler and convert executive access into sustained growth, customer trust, and enterprise alignment
Discovered TodayView →
Business Development Sales Representative
, GBR
MidFull-time
Business Development Manager - HVAC Service Sales (Facilities Management Sector) About Us Johnson Controls, a global leader in thermal management, mission-critical building systems, energy efficiency, and decarbonization
Discovered TodayView →
Security Installer (union)
Brecksville, USA
MidFull-time
What you will do As a critical part of the team, the Commercial Installer works onsite with our commercial customers to set up and program their Integrated Security fire and security systems. The Commercial Installer als
Discovered TodayView →
Channel Accounts Manager, Controls
Dubai, UAE
Discovered TodayFull-time
Sales Engineer - Security Systems, Install
Dubai, UAE
Discovered TodayFull-time
Regional Sales Engineer - HVAC Indirect
Dubai, UAE
Discovered TodayFull-time
Connected Chiller Lead - Remote Operations
Dubai, UAE
Discovered TodayFull-time
Business Support Champion
Orlando, USA
Discovered TodayFull-time
VP & Managing Director, Global Data Center Solutions [Remote]
Milwaukee, USA
Discovered TodayFull-time
Business Development Sales Representative
, GBR
Discovered TodayFull-time
Security Installer (union)
Brecksville, USA
Discovered TodayFull-time