PowerBI Lead

Role Overview: As a PowerBI Lead, your primary role will be to understand business requirements and translate them into technical specifications for Power BI reports and dashboards. You will design, develop, and publish interactive dashboards using Power BI tools like Power BI Desktop and Power BI Service. Additionally, you will be responsible for integrating data from various sources such as SQL Server, Excel, SharePoint, and cloud-based sources like Azure. Building and optimizing data models, developing DAX queries for performance, and managing ETL processes will also be key aspects of your role. Implementing row-level security and ensuring data validation for accuracy of reports and dashboards will be part of your responsibilities. Collaboration with stakeholders, monitoring Power BI service performance, and staying updated with industry trends will also be crucial. Key Responsibilities: - Understand business requirements and translate them into technical specifications for Power BI reports and dashboards. - Design, develop, and publish interactive dashboards using Power BI (Power BI Desktop & Power BI Service). - Integrate data from various sources including SQL Server, Excel, SharePoint, and cloud-based sources (Azure, etc.). - Build and optimize data models (star/snowflake schema) and DAX queries for performance and usability. - Develop and manage ETL processes using Power Query, Dataflows, or Azure Data Factory. - Implement row-level security (RLS) and access controls within Power BI reports. - Perform data validation and ensure accuracy of reports and dashboards. - Collaborate with stakeholders, business analysts, and data engineers to ensure report alignment with business goals. - Monitor Power BI service performance and schedule dataset refreshes. - Stay up-to-date with Power BI updates, best practices, and industry trends. Qualifications Required: - Bachelors degree in Computer Science, Information Systems, or a related field. - 8+ years of hands-on experience in Power BI report and dashboard development. - Proficiency in DAX, Power Query (M language), and data modeling. - Strong SQL skills - ability to write complex queries and optimize them. - Experience in integrating Power BI with cloud data sources (e.g., Azure SQL, Data Lake). - Familiarity with Power BI Gateway, Power BI Report Server (optional), and Workspace Management. - Solid understanding of data warehousing concepts and relational databases. - Strong analytical and problem-solving skills. - Excellent communication and stakeholder management abilities. Additional Details: The company prefers candidates with Microsoft Power BI certifications and exposure to other BI tools like Tableau or QlikView (optional). Experience working in Agile or Scrum teams will be an advantage. Note: Skills required for this role include Power BI, SQL, and DAX.,