Power BI Lead / Business Objects Lead - AI-Enabled BI & Analytics

Job Title: Power BI Lead / Business Objects Lead

Experience: 8 - 12 Years
Job Function: Business Intelligence, Data Analytics & Reporting
Employment Type: Full-time

Job Summary

Blumetra Solutions is looking for an experienced Power BI Lead / Business Objects Lead to lead the design, development, migration, optimization, and delivery of enterprise BI and analytics solutions. The ideal candidate will have strong expertise in Power BI and/or SAP BusinessObjects (BO), data modelling, SQL, dashboard development, reporting architecture, and performance optimization.

The role requires a strong understanding of business intelligence architecture, semantic models, data integration, and enterprise reporting. Candidates should also have practical experience leveraging AI tools such as Claude, Microsoft Copilot, or equivalent solutions to accelerate BI development, automate reporting activities, improve data analysis, and enhance development productivity.

The successful candidate will work closely with business stakeholders, data engineering teams, and customers to translate business requirements into scalable, reliable, and insightful analytics solutions.

Key Responsibilities

1. BI Development & Architecture

• Lead the design, development, implementation, and maintenance of enterprise BI solutions using Power BI and/or SAP BusinessObjects.
• Design interactive dashboards, reports, scorecards, and analytical visualizations aligned with business requirements.
• Develop and maintain reusable reporting components, semantic models, datasets, and standardized BI frameworks.
• Define BI architecture, development standards, naming conventions, security practices, and deployment approaches.
• Evaluate existing reporting solutions and recommend improvements in usability, scalability, maintainability, and performance.

1. Power BI Expertise

• Develop and optimize Power BI dashboards, reports, semantic models, and enterprise reporting solutions.
• Demonstrate strong proficiency in DAX, Power Query (M), data modelling, and advanced visualization techniques.
• Implement efficient data models, relationships, measures, calculated columns, and time-intelligence calculations.
• Configure row-level security (RLS), workspaces, apps, gateways, refresh schedules, and deployment pipelines as applicable.
• Optimize report rendering, DAX expressions, data refresh performance, and model size.
• Work with DirectQuery, Import, and composite models based on business and performance requirements.

1. Business Objects Expertise

• Design, develop, enhance, and maintain enterprise reports using SAP BusinessObjects tools, where applicable.
• Work with Web Intelligence (WebI), Information Design Tool (IDT), Universe design, and related BO reporting components.
• Develop and optimize universes, semantic layers, queries, prompts, and complex reporting logic.
• Troubleshoot reporting issues, query performance, data inconsistencies, and refresh failures.
• Support BO report modernization, migration, rationalization, and integration with modern BI platforms where required.

1. SQL, Data Modelling & Integration

• Write and optimize complex SQL queries, joins, subqueries, aggregations, and analytical queries.
• Work with relational databases, data warehouses, and cloud data platforms to build reliable reporting solutions.
• Validate source data, transformations, business rules, and report-level calculations.
• Collaborate with data engineering teams to integrate BI solutions with ETL/ELT pipelines and enterprise data platforms.
• Ensure data accuracy, consistency, reconciliation, and traceability across reports and dashboards.

1. AI-Powered BI & Analytics

• Use AI-assisted development tools such as Claude, Microsoft Copilot, or equivalent tools to accelerate report development, DAX and SQL authoring, troubleshooting, and documentation.
• Explore AI-powered capabilities for natural-language analytics, conversational reporting, automated insights, and report summarization.
• Develop AI-assisted utilities to automate repetitive BI development, testing, documentation, and validation activities.
• Evaluate opportunities to integrate Power BI or enterprise reporting solutions with approved AI services and governed enterprise data sources.
• Apply appropriate validation, access controls, and data privacy practices when using AI-generated code, insights, or business outputs.
• Stay updated on emerging AI capabilities in business in…