Expertise Power BI Admin/Developer (Hands on SQL, ETL and Azure) || Pune / Noida / Bangalore

Overview

Administer and govern the enterprise Power BI platform while designing, developing, and supporting scalable business intelligence solutions, partnering with business, product, data, infrastructure, and security teams.

What you'll do

• Administer Power BI Service, including tenant settings, workspaces, applications, capacities, gateways, deployment pipelines, subscriptions, and platform access.
• Monitor Power BI capacity utilization, dataset refreshes, gateway health, report performance, audit activity, and service reliability; proactively identify and resolve platform issues.
• Define and implement governance standards for workspace creation, naming, ownership, lifecycle management, certified and promoted content, data classification, sharing, and retention.
• Design secure enterprise BI architectures using Power BI, Microsoft Dynamics 365, Dataverse, Azure data services, relational databases, APIs, and cloud data platforms.
• Design and develop executive dashboards, operational reports, paginated reports, semantic models, reusable datasets, dataflows, and self-service analytics solutions.
• Develop Power BI analytics and semantic models using Microsoft Dynamics 365 and Dataverse data, including secure extraction, transformation, integration, and reporting across business applications.
• Develop advanced DAX measures, Power Query transformations, dimensional models, calculation groups, aggregations, incremental refresh, and performance-optimized reporting solutions.
• Implement and support Row-Level Security, Object-Level Security, Microsoft Entra ID group-based access, sensitivity labels, and least-privilege access controls.
• Architect and optimize Import, DirectQuery, Composite, and Direct Lake solutions based on data volume, latency, security, and performance requirements.
• Build and support backend data components such as SQL queries, views, stored procedures, data marts, ETL/ELT processes, APIs, and data validation frameworks.
• Partner with database, cloud, networking, security, and application teams to troubleshoot data connectivity, authentication, gateway, refresh, and performance issues.
• Establish source control, code review, automated testing, release management, and CI/CD practices using Git and Azure DevOps.
• Mentor Power BI developers, review solution designs, enforce development standards, and promote reusable architecture patterns and documentation.
• Support Microsoft Fabric evaluations and implementations using OneLake, Lakehouse, Warehouse, Data Factory, notebooks, pipelines, semantic models, and Fabric capacity management.
• Communicate risks, dependencies, technical constraints, and remediation plans clearly to stakeholders and leadership.

What you'll need

• Minimum 7 to 10 years of experience in business intelligence, analytics, data engineering, or application development, including at least 4 years of hands-on Power BI experience.
• Hands-on experience administering Power BI Service in an enterprise environment, including tenant settings, workspaces, capacities, gateways, security, governance, and monitoring.
• Strong Power BI development experience with Power BI Desktop, Power BI Service, DAX, Power Query (M), semantic modeling, dataflows, deployment pipelines, and performance tuning.
• Strong understanding of dimensional modeling, star schemas, slowly changing dimensions, data warehousing, metadata, lineage, and data quality concepts.
• Strong SQL knowledge, including complex queries, joins, window functions, views, stored procedures, query optimization, and troubleshooting.
• Backend knowledge of REST APIs, JSON, authentication and authorization, batch processing, Microsoft Dynamics 365 and Dataverse data integration, and application-to-database connectivity.
• Experience with Azure SQL Database, Microsoft SQL Server, Azure Data Factory, Azure Storage, or comparable enterprise data platforms.
• Working knowledge of Microsoft Dynamics 365 and Dataverse, including core data structures, security roles, environments, solution-aware delivery, and integration with Power BI and Azure services.
• Experience implementing RLS, OLS, Entra ID group-based permissions, service principals, managed identities, gateway security, and least-privilege access.
• Understanding of Power BI licensing, capacity planning, refresh limitations, disaster recovery, business continuity, and operational support processes.
• Good understanding of Git, Azure DevOps, CI/CD pipelines, Agile/Scrum delivery, change management, and production support.
• Education: BE/BTech/MCA/MTech/BSc or equivalent graduate qualification in Computer Science, Information Technology, Engineering, Data, or a related discipline.
• Strong communication, stakeholder management, analytical thinking, documentation, and problem-solving skills.
• Experience working with distributed teams across India, US, APAC, or UK time zones.

Nice to have

• Hands-on knowledge of Microsoft Fabric, including OneLake, Lakehouse, Warehouse, Data Factory, notebooks, pipelines, Direct Lake, semantic models, Real-Time Intelligence, and Fabric capacity management.
• Experience planning or executing migration from traditional Power BI, Azure Synapse, or other data platforms to Microsoft Fabric.
• Experience with Python, PySpark, C#/.NET, PowerShell, or automation using Power BI REST APIs and Microsoft Graph.
• Knowledge of Microsoft Dynamics 365 applications (such as Sales, Customer Service, or Field Service), Dataverse, Snowflake, Azure Databricks, Azure Synapse Analytics, or other modern cloud data platforms.
• Knowledge of Microsoft Purview, sensitivity labels, data cataloguing, lineage, compliance, auditing, and enterprise data governance.
• Microsoft certifications such as PL-300, DP-600, DP-700, DP-203, AZ-900, or PL-900.
• Experience in financial services or regulated enterprise environments and understanding of secure analytics delivery practices.

Details

• Location: Pune / Bangalore / Noida, India.
• Work mode: 5 days, work from office.