Power BI & Advanced Excel Developer

Sonata Software (SonataOne); Bengaluru; Hybrid; INR 1,800,000 - 3,000,000; Full time

Job summary

Sonata Software (SonataOne) is seeking an experienced Power BI Developer with 7+ years of BI, analytics, and reporting expertise. The role focuses on Power BI, Microsoft Fabric, advanced Excel reporting, and Sales analytics, with hybrid work across multiple Indian cities.

The ideal candidate will design enterprise dashboards, implement data governance, and deliver end-to-end analytics solutions with minimal supervision.

Qualifications

• 7+ years of BI, reporting, and analytics experience.
• Deep expertise in Power BI, DAX, data modeling, and performance tuning.
• Experience implementing Row-Level Security (RLS) and enterprise reporting standards.
• Knowledge of ALDA permissions and Microsoft reporting ecosystem.
• Hands-on with Microsoft Fabric components (Dataflows, Lakehouse, semantic models).

Responsibilities

• Design, develop, and maintain enterprise-scale Power BI dashboards and reports.
• Gather business requirements and translate them into analytics solutions.
• Develop and support end-to-end ETL/data integration pipelines.
• Implement ALDA permissions, RLS, and data governance controls.
• Create and maintain Excel dashboards and automated reporting solutions.
• Develop executive-level reporting and KPI dashboards for stakeholders.
• Build reporting solutions using Microsoft Fabric components.
• Develop GitHub-based operational and governance reporting dashboards.
• Perform data validation, reconciliation, and root-cause analysis.

Skills

Power BI & Analytics

Microsoft Fabric

Advanced Excel

Tools

GitHub

Azure Data Services

Job description

J ob Title: Power BI & Advanced Excel Developer

Experience: 7+ Years
Location: Hyderabad/Bangalore/Chennai
Shifts: 8am-7pm
Mode of work: Hybrid

Job Summary

We are looking for an experienced Power BI Developer with strong expertise in Power BI,Microsoft Fabric, advanced Excel reporting, and Microsoft Salesanalytics. The ideal candidate should possess strong business acumen,data visualization skills, and the ability to independently deliverreporting solutions with minimal supervision.

Key Responsibilities

• Design, develop, and maintainenterprise-scale Power BI dashboards and reports.
• Gather business requirementsand translate them into actionable analytics solutions.

Develop and support end-to-endETL/Data Integration pipelines.

Implement and manage ALDApermissions, Row-Level Security (RLS), and data governance controls.

Create and maintain Excel-baseddashboards, reports, and automated reporting solutions.

Develop executive-levelreporting and KPI dashboards for business stakeholders.

Build and enhance reportingsolutions using Microsoft Fabric components.

Develop and maintainGitHub-based operational, engineering, and governance reportingdashboards.

Perform data validation,reconciliation, and root-cause analysis for reporting discrepancies.

Collaborate with business andtechnical teams to improve reporting efficiency and data quality.

Required Skills

Power BI & Analytics

Minimum 7+ years of experiencein BI, Reporting, and Analytics.

Hands-on experience with DAX,Power Query, Data Modeling, and Performance Optimization.

Experience implementingRow-Level Security (RLS) and enterprise reporting standards.

Knowledge of ALDA permissionsand Microsoft reporting ecosystem.

Microsoft Fabric

Hands-on experience withMicrosoft Fabric components.

Good understanding ofDataflows, Lakehouse, Semantic Models, and Reporting integration.

Ability to design scalablereporting solutions using Fabric architecture.

Experience developingGitHub-based engineering and operational reports.

Knowledge of GitHub dataanalysis, repository metrics, work item tracking, and reportingvisualization.

Basic understanding of Azureservices and cloud architecture.

Familiarity with Azure DataServices, Storage Accounts, and Identity & Access concepts.

Exposure to Azure-basedreporting and analytics environments is preferred.

Advanced Excel

Strong experience in Excel DashboardDevelopment and Data Analysis.
Must possess hands-on expertise in:

SUMIF / SUMIFS

COUNTIF / COUNTIFS

AVERAGE / AVERAGEIFS

IF Statements

INDEX-MATCH

Conditional Formatting

ABOUT SONATA SOFTWARE

A BOUT SONATA SOFTWARE Sonata Software is an AI-first modernization engineering company that helps enterprises transform legacy systems into intelligent, scalable business platforms. Powered by its Platformation framework and Harmoni.AI platform, Sonata delivers AI-led modernization across cloud, data, AI, Dynamics, test automation, and managed services. Headquartered in Bengaluru, India, Sonata has more than $1.2 billion in revenue and 6,400+ AI engineers supporting global delivery across regions including the US, UK, India, Malaysia, Mexico, Australia, DACH, and the Nordics. With deep partnerships across Microsoft, AWS, Salesforce, and Snowflake, Sonata helps Fortune 500 enterprises accelerate innovation, improve efficiency, and drive sustainable growth.