Senior Lead - Power BI Development

As a Power BI Senior Lead, you will be responsible for leading end-to-end Power BI solution design, architecture, development, performance optimization, and governance. Your deep technical proficiency in Power BI, advanced DAX/MDX, data modeling, and SQL development will be crucial in translating data into meaningful insights for the business stakeholders. Key Responsibilities: - Design and develop interactive dashboards, KPI scorecards, and analytical reports using Power BI Desktop. - Implement advanced visualizations with strong formatting, navigation, drill-through, bookmarks, and storytelling capabilities. - Translate complex business requirements into intuitive and insightful visual reports. - Work with multiple data sources including SQL Server, APIs, cloud sources, and live connections. - Implement import mode, Direct Query, and live connection strategies based on performance needs. - Build optimized data models using Power Query and Power Pivot. - Design and implement star and snowflake schemas with proper handling of Facts and Dimensions. - Write advanced DAX (Data Analysis Expressions) and MDX queries for custom calculations. - Troubleshoot and optimize DAX formulas for performance. - Ensure scalability and performance of large datasets within Power BI. - Architect enterprise-level Power BI solutions using Pro and Premium capacities. - Manage Power BI service, report publishing, app workspaces, and governance. - Implement Row-Level Security (RLS) and dynamic role-based security models. - Work with Power BI Gateway for on-premises data connectivity. - Develop Power BI embedded solutions using REST APIs. - Integrate Power BI with Power Automate for workflow automation. - Stay updated with latest Power BI features, AI integrations, and best practices. - Develop complex SQL queries, stored procedures, functions, and triggers using T-SQL. - Design and develop database objects such as tables, views, constraints, partitioned views. - Implement referential integrity rules and validations. - Perform performance tuning using execution plans and index optimization. - Work on SQL Server 2012/2016 environments for BI and reporting solutions. - Prepare HLD (High-Level Design) and LLD (Low-Level Design) documents. - Create Unit Test Cases and support UAT cycles. - Maintain documentation for data models, report logic, and security frameworks. - Monitor, troubleshoot, and maintain Power BI infrastructure. - Lead BI initiatives and mentor junior developers. - Collaborate with business users to gather requirements and translate them into technical solutions. - Provide architectural guidance and recommend best practices. - Ensure quality, performance, and scalability of BI solutions. Required Skills & Expertise: Technical Skills - 5+ years of hands-on experience in Power BI (Desktop, Pro, Premium). - 3+ years of advanced DAX and MDX experience. - Strong expertise in Data Modeling (Facts, Dimensions, Star Schema). - Strong SQL Server development experience (T-SQL, Stored Procedures, Performance Tuning). - Experience with Power BI Gateway and embedded solutions using REST API. - Experience with Power Automate integration. - Deep understanding of BI architecture and enterprise deployment. Additional Preferred Skills: - Exposure to Power BI AI features and advanced analytics. - Knowledge of Data Warehousing concepts. - Experience in performance optimization of large-scale BI solutions. As a Power BI Senior Lead, you will have the opportunity to lead enterprise-level BI initiatives, work on advanced Power BI architecture including embedded analytics and AI integration, and gain exposure to large-scale data warehouse environments. This strategic role offers high visibility across business functions. As a Power BI Senior Lead, you will be responsible for leading end-to-end Power BI solution design, architecture, development, performance optimization, and governance. Your deep technical proficiency in Power BI, advanced DAX/MDX, data modeling, and SQL development will be crucial in translating data into meaningful insights for the business stakeholders. Key Responsibilities: - Design and develop interactive dashboards, KPI scorecards, and analytical reports using Power BI Desktop. - Implement advanced visualizations with strong formatting, navigation, drill-through, bookmarks, and storytelling capabilities. - Translate complex business requirements into intuitive and insightful visual reports. - Work with multiple data sources including SQL Server, APIs, cloud sources, and live connections. - Implement import mode, Direct Query, and live connection strategies based on performance needs. - Build optimized data models using Power Query and Power Pivot. - Design and implement star and snowflake schemas with proper handling of Facts and Dimensions. - Write advanced DAX (Data Analysis E