Business Intelligence Architect

Overview

The BI Architect designs reports and analytic solutions, gathers reporting requirements, documents business processes, and develops enterprise-grade Power BI dashboards and scorecards along with AI agents that work alongside BI reports.

What you'll do

• Analyse software systems data and recommend data 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 organizational metrics and KPIs.
• Develop the overall project technical design for report and dashboard development.
• Responsible for 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 report testing to ensure data quality.
• Incorporate AI functionality into existing or new reports.
• Performance tune reports.
• Elicit business requirements from subject matter experts through interviews, document analysis and requirements workshops.
• Use gathered requirements to develop reporting and analytics logic.
• Understand data standards and identify data abnormalities.
• Lead and provide technical guidance and mentorship to other team members.
• Perform statistical analysis, build predictive models, and formulate decision models relating 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.
• Instill data quality in all solutions delivered.
• Maintain close alignment with internal and external customers, management, field level, and other data reporting teams to ensure requirements are met.

What you'll need

• Bachelor's degree or higher from a reputed university in engineering, IT, economics, math, statistics, science or another related quantitative or analytical discipline.
• Minimum 7-10 years of experience in related data roles.
• Excellent skill in SQL and PL/SQL.
• In-depth experience with the Microsoft analytics stack (Power BI, Power Query, Fabric, DAX, T-SQL, SSRS, SSAS).
• Advanced knowledge of Power BI.
• Proficient in DAX and M language.
• Experience with associated development tools: Visual Studio 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.
• 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 from multiple sources.
• Excellent verbal, written, and interpersonal communication skills.
• Adaptable self-starter who can work with minimal supervision.
• Able to handle multiple projects and organize time effectively.
• Willing to put in extra time and effort when needed.

Nice to have

• Knowledge of data mining, clustering and statistical modelling.
• Experience with Azure Machine Learning (AML).
• Experience with Microsoft Flow and Microsoft Power Apps.

Details

• Location: Pune, Maharashtra, India.