Power BI with Advanced Excel Developer

About Sonata Software Sonata Software, with over $1.2 Billion Revenue, is a leading AI-first Modernization Engineering company, powered by our unique PlatformationTM framework. Our 6400+ AI Engineers are helping enterprises transform from systems to intelligent business platforms leveraging partner ecosystem to drive speed, efficiency and growth. Our bouquet of Modernization Engineering Services with AI -first approach cuts across Cloud, Data, AI, Dynamics, Test Automation, and Managed Services.

Sonata’s AI-led modernization is enabled by a powerful suite of proprietary tools and assets. At the core is the  Harmoni.AI  Enterprise Platform, which includes  AgentBridge -a governance and observability framework;  Agent Builder -a development toolkit for fungible agents integrated into enterprise systems; and the  Agent Marketplace -an internal ecosystem for modular, reusable agents.

Headquartered in Bengaluru, India, Sonata Software has a strong global presence, including key regions US, UK, India, Malaysia, Mexico, Australia, DACH (Germany/Switzerland) & Nordics (Finland). We are a trusted partner of Fortune 500 companies in Banking, Financial Services and Insurance; Healthcare and Lifesciences; Telecom, Media, and Technology; and Retail, Manufacturing and Distribution space.

Deep collaborations with partners like Microsoft, AWS, Salesforce, and Snowflake strengthen our ability to deliver cutting-edge AI solutions. Our 30+years of partnership with Microsoft, and being part of the elite Microsoft Inner Circle, places us among the top 1% of global Microsoft partners. Sonata is now among the first companies to earn the  Microsoft Frontier Partner Badge  Also; Sonata Software is proud to achieve AWS Premier Tier Status in the AWS Partner Network.

J ob Title: Senior Power BI 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 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 Excel Strong 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

At Sonata, you´ll have an outstanding opportunity. The chance to use your skills and imagination to push the boundaries of what´s possible. To build never seen before solutions to some of the world’s toughest problems. You´ll be challenged, but you will not be alone. You´ll be joining a team of diverse innovators, all driven to go beyond the status quo to craft what comes next.

Sonata Software is an Equal Opportunity Employer encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, national origin, gender identity, age, religion, disability, sexual orientation, veteran status, marital status, or any other characteristics protected by law .