Power BI Lead

Job Overview: We are seeking an experienced Power Bi Developer / Business Intelligence Engineer to lead our Business Intelligence operations in the Americas. The successful candidate will be responsible for leading a team developing reporting, dashboards, working with PBI power user ensuring governance and standards are respected and followed. Working closely with our data team integrating reports and dashboards with Google Cloud Platform (GCP) to enhance business insights, and self-service analytics capabilities. Key Responsibilities: Lead Power BI Team - Requirement Gathering, Performed needs assessment, Impact Analysis with Business Users for reporting and analytical projects. - Analyzed data flow and gathered Business requirements to create design documentation. - Participated in translating key Business requirements into technical specifications - To understand business requirements in the BI context and design data models to convert raw data to meaningful insights - To create dashboards and visual interactive reports using Power BI - To design, develop, and deploy Power BI scripts and perform efficient detailed analysis - To create charts and document data with algorithms, parameters, models, and relations explanations - Oversee delivery of PBI team including power users - Provide guidelines and standards for report and dashboard delivery. - Define KPIs for measuring performance, user adaption and improvement opportunities Power BI Development & Modernization - Design, rebuild, and optimize complex visualizations and dashboards in Power BI. - Develop advanced DAX expressions, measures, and variables to accurately model business logic. - Utilize Power Query and Power View for intuitive data visualization. - Provide specification to the data team to redesign and optimize underlying data models for improved performance and scalability. Data Modeling & Integration - Configure Direct Query and Import Mode connections to Google BigQuery for real-time and large-scale data analytics. - Develop semantic data models in Power BI to abstract complex GCP data structures and enable self-service reporting. - Collaborate with data engineering teams to design and orchestrate ETL pipelines using BigQuery, Cloud Storage, and Dataflow. - Implement incremental refresh policies for BigQuery datasets, improving data load efficiency and reducing refresh times. Performance Optimization & Governance - Utilize DAX Studio, Tabular Editor, and Performance Analyzer to troubleshoot and optimize slow queries and visuals. - Apply BI performance best practices to enhance report responsiveness, achieving performance gains. - Establish governed Power BI datasets, ensuring data standardization, security, and compliance. - Monitor Fabric capacity metrics and Power BI usage reports to identify performance trends and optimize capacity planning. Administration & User Enablement - Manage Power BI workspaces, roles, and licenses according to business requirements. - Configure scheduled refreshes, alerting mechanisms, and access controls to ensure reliable and secure data delivery. - Provide end-user training on Power BI self-service features, including report personalization, Analyze in Excel, bookmarks, and content sharing. Required Skills & Qualifications: - Proven experience in Power BI (Desktop & Service) development, including DAX, Power Query, and Tabular modeling. - Understanding of Google Cloud Platform (BigQuery, Dataflow, Cloud Storage) integration with Power BI. - Solid understanding of data modeling concepts (star schema, normalization, ETL). - Experience in performance optimization using tools like DAX Studio, Tabular Editor, and Performance Analyzer. - Proficiency in SQL - Excellent analytical, problem-solving, and communication skills. Preferred Qualifications: - Experience implementing BI governance frameworks and security models (RLS, workspace permissions, capacity management). - Familiarity with Fabric metrics, self-service analytics enablement, and enterprise BI modernization initiatives. - Certification in Power BI, or related technologies is a plus. Environment / Tools: Power BI (Desktop, Service, DAX, Power Query, Power View, Tabular Editor, Performance Analyzer, RLS, Fabric Metrics) Google Cloud Platform (BigQuery, Cloud Storage, Dataflow) Confluence, Jira Cheers, Adler