Business Intelligence Architect

Johnson Controls, Inc.; Pune District; Presencial; INR 1.500.000 - 2.300.000; Jornada completa

Descripción de la vacante

Johnson Controls, Inc. seeks a Business Intelligence Architect to design reports and analytics, gather requirements, and document business processes. You will develop enterprise dashboards and BI scorecards in Power BI, and create AI agents aligned with BI reports.

You will collaborate with multiple teams, engage stakeholders, and ensure solutions meet expectations. The role requires strong SQL, Power BI, and Azure data services expertise with a focus on data quality and scalable analytics.

Formación

• Bachelor's degree or higher from a recognised university in engineering, IT, economics, math, statistics, science or related analytical fields.
• 7–10 years of experience in related data roles.

Responsabilidades

• Analyze software systems data and recommend data analytics solutions and strategy.
• 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 metrics and KPIs.
• Develop overall project technical design for report and dashboard development.
• Create enterprise-grade analytics solutions for internal and 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 reports and perform performance tuning of reports.
• Elicit requirements from SMEs via interviews and workshops; translate into reporting logic.
• Understand data standards and identify data abnormalities; instill data quality across solutions.
• Lead and mentor team members; perform statistical analysis and build predictive models.
• Build end-to-end automated analytics solutions using Power BI, PowerApps and Microsoft Flow.

Conocimientos

SQL & PL/SQL

Power BI

DAX

Azure ML

Azure Data Factory

SSAS

GitHub

Educación

Bachelor's degree or higher

Herramientas

Visual Studio Data Tools

SSMS

SQL Server Data Tools

Toad

Copilot

Foundry

Descripción del empleo

JobDescription–Business Intelligence (BI) Architect

Summary – The BI Architect will be responsible for designing reports and analytic solutions, gathering reporting requirements and documenting business processes as needed. The architect will develop enterprise grade dashboards and BI scorecards in Power BI, develop AI agents which work in tandem with BI reports. Also engages with other teams, departments and stakeholders to make sure all the reporting solution developments are fully understood and deliveredto expectations.

JOBRESPONSIBILITIES:

• 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.
• DesignanddevelopScorecardsandDashboardsusingPowerBIforvariousorganizationalmetricsandKPIs.
• 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.
• ElicitbusinessrequirementsfromSubjectMatterExpertsusinginterviews,documentanalysisandrequirements workshops.
• Usethegatheredrequirementstodeveloplogicforreportingandanalytics.
• 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.
• BuildendtoendautomatedanalyticalsolutionsusingPowerBI,PowerAppsandMicrosoftFlow.
• Understanddatastandardsandidentifydataabnormalities.Instilldataqualityinallsolutionsdelivered.
• Maintainclosealignmentwithallcustomers(internal,external,managementandatthefieldlevel)andotherdata 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 otherrelated fields in quantitative or analytical discipline.
• Minimum7-10yearsofexperienceinrelateddataroles.

SKILL:

• ExcellentskilllevelinSQL,PL/SQL.
• In-depth experience with Microsoftanalytics Stack (Power BI, Power Query, Fabric, DAX, T-SQL, SSRS, SSAS)
  • AdvancedknowledgePowerBI.
  • ProficientinDAX,Mlanguage.
• ExperiencewithAssociatedDevelopmentTools-VisualStudiosDataTools,SQLServerManagement Studio, SQL Server Data Tools, Microsoft TFS, GitHub.
• Working knowledge of Fabric Data Agent, Copilot, Microsoft Foundry.
• KnowledgeofworkingwithdatabaseclienttoolssuchasToad.
• KnowledgeofDataMining,Clustering&StatisticalModelling(preferred).
• ExperiencewithAzureMachineLearning(AML).UnderstandingofAzureanditsdataservices.
• KnowledgeofAzureDataFactory,AzureDataLake,AzureSQLDWandAzureSQL.
• ExperiencewithMicrosoftFlowandMicrosoftPowerAppspreferred.
• ProficientinMicrosoftOfficeSuiteandO365.
• Superiordocumentationandorganizationalskills.Mustbedetailoriented.
• Excellentcritical-thinkingskillswiththeabilitytoresearchandanalyzedataretrievedfrommultiplesources
• Mustpossessanddemonstrateexcellentverbal,written,andinterpersonalcommunicationsskills.
• Mustbeanadaptableself-starterandworkwithminimalsupervision.Mustbeabletohandlemultipleprojectsand organize time effectively.
• Must bewilling to put in extratime and effort if need be. Go above and beyond the requirements of the job and striveto exceed expectations.