Power BI & Advanced Excel Developer

Experience: 7+ YearsLocation: Hyderabad/Bangalore/ChennaiShifts: 8am-7pmMode of work: Hybrid

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

Key Responsibilities

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

• Develop and support end-to-end ETL/Data Integration pipelines.

• Implement and manage ALDA permissions, Row-Level Security (RLS), and data governance controls.

• Create and maintain Excel-based dashboards, reports, and automated reporting solutions.

• Develop executive-level reporting and KPI dashboards for business stakeholders.

• Build and enhance reporting solutions using Microsoft Fabric components.

• Develop and maintain GitHub-based operational, engineering, and governance reporting dashboards.

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

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

Required Skills

Power BI & Analytics

• Minimum 7+ years of experience in BI, Reporting, and Analytics.

• Strong expertise in Power BI Dashboard Development.

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

• Experience implementing Row-Level Security (RLS) and enterprise reporting standards.

• Knowledge of ALDA permissions and Microsoft reporting ecosystem.

Microsoft Fabric

• Hands-on experience with Microsoft Fabric components.

• Good understanding of Dataflows, Lakehouse, Semantic Models, and Reporting integration.

• Ability to design scalable reporting solutions using Fabric architecture.

GitHub Reporting

• Experience developing GitHub-based engineering and operational reports.

• Knowledge of GitHub data analysis, repository metrics, work item tracking, and reporting visualization.

Azure

• Basic understanding of Azure services and cloud architecture.

• Familiarity with Azure Data Services, Storage Accounts, and Identity & Access concepts.

• Exposure to Azure-based reporting and analytics environments is preferred.

Advanced ExcelStrong experience in Excel Dashboard Development and Data Analysis.Must possess hands-on expertise in:

• Power Pivot

• Pivot Tables

• SUMIF / SUMIFS

• COUNTIF / COUNTIFS

• AVERAGE / AVERAGEIFS

• IF Statements

• VLOOKUP / HLOOKUP / XLOOKUP

• INDEX-MATCH

• Conditional Formatting

ABOUT 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 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.

 For more information, please visit