Power BI Lead

Role: Power BI Lead
Role Description:

We are seeking a highly skilled Power BI Technical Lead to join our growing Data & Analytics team. This role is responsible for leading the design, development, and implementation of advanced BI solutions using Power BI, with a focus on integrating AWS-based data platforms and leveraging Microsoft Fabric solutions. The ideal candidate will possess strong technical acumen, leadership qualities, and the ability to influence modern BI reporting strategies across the organization. support a key modernization initiative focused on transforming operational reporting through the implementation of new tools, data processes, workflows, and BI technologies. This role will be responsible for migrating legacy reports, developing new reporting solutions in Power BI, and contributing to overall reporting modernization efforts. The ideal candidate brings strong Power BI and SQL skills, hands-on experience with data modeling and DAX, and the ability to work effectively across technical and business teams in a fast-paced, Agile environment.

Key Responsibilities: Semantic Model Design, Solution architecting and Implementation

o Architect and maintain robust Power BI data models (datasets) with clearly defined measures, hierarchies, and calculated columns.o Ensure adherence to star schema modeling best practices, including the use of fact and dimension tables, role-playing dimensions, surrogate keys, and bi-directional filtering when appropriate.
o Design optimized relationships and data granularity alignment across tables to support accurate aggregations and slicing/filtering.
o Derive various model storage architectural patterns to fit into DW and DataLake data landscape having performant and scalable model architecture.o Good understanding of multi-Cloud Data architecture within AWS and Azure, cross cloud networking, data egress, data integration using Gateway installer to best design semantic model architecture.o Understanding of Business Objects universe functionalities and BI platform migration from BO to Power BI is an added advantage.
o AWS Data Integration to azure Fabric using various fabric capabilities to support design and development of DirectLake data model.o Utilize Power Query (M language) for data shaping, transformation, and cleansing while ensuring query folding is preserved in DirectQuery mode.o Collaborate with data engineers to validate source-to-model mapping, and offload heavy transformation logic to upstream pipelines (e.g., Dataflows, Fabric, or SQL views) where appropriate.
o Ensure data lineage, traceability, and refresh reliability throughout the modeling layer.DAX Development and Optimizationo Design and Develop complex DAX measures to compute KPIs, time-intelligent metrics (e.g., YTD, MTD, YoY), variance analysis, and conditional logic across multiple fact sources including custom measures in DAX to control filter propagation and aggregation.o Optimize DAX code for performance and readability, ensuring low