Seeking a Power BI & Microsoft Fabric Developer to architect enterprise semantic models and interactive dashboards. You will build Star Schema models connected to OneLake via DirectLake, write complex DAX calculations, and develop ingestion pipelines using Dataflow Gen2 and Power Query (M). Requires strong visualization skills, security governance (RLS/OLS), and business stakeholder collaboration.
Power BI & Microsoft Fabric Developer
Role Overview We are seeking an experienced Power BI & Microsoft Fabric Developer to design, build, and optimize enterprise semantic models, interactive dashboards, and self-service analytics solutions. Acting as a key bridge between data engineering and business teams, you will leverage Microsoft Fabric, DirectLake, Dataflow Gen2, and advanced DAX to transform complex data into intuitive, high-performance business intelligence.
Key Responsibilities
- BI & Dashboard Development: Design and deliver intuitive, visually compelling Power BI reports and executive dashboards that empower self-service analytics across the organization.
- Semantic Modeling & DAX: Architect scalable, high-performance Power BI semantic models using dimensional modeling best practices (star/snowflake schemas) and write complex DAX calculations.
- Microsoft Fabric & DirectLake Integration: Build and optimize semantic models connected directly to OneLake/Lakehouse via DirectLake mode to achieve near real-time query performance without data duplication.
- Data Ingestion & Transformation: Develop, schedule, and maintain low-code data ingestion and transformation pipelines using Dataflow Gen2 and Power Query (M).
- Stakeholder Collaboration: Partner directly with business stakeholders to gather reporting requirements, translate business KPIs into technical metrics, and drive BI adoption.
- Performance Tuning & Governance: Optimize report load times, manage workspace security (Row-Level Security/Object-Level Security), and enforce BI governance standards.
Key Requirements
- Power BI & DAX (Mandatory): Advanced Power BI development skills with deep expertise in writing complex DAX measures and optimizing Semantic Models.
- Microsoft Fabric & DirectLake: Hands-on experience working within Microsoft Fabric, specifically leveraging DirectLake storage mode and Dataflow Gen2.
- Data Modeling: Strong foundational knowledge of dimensional modeling (Star Schema, fact/dimension tables, relationships, and granularity).
- Analytics & Visualization: Proven track record building executive dashboards, operational reports, and scalable self-service analytics frameworks.
- Stakeholder Management: Excellent communication skills with the ability to work closely with non-technical business users to clarify requirements and deliver actionable insights.
Technical Stack
- BI & Visualization: Power BI Desktop, Power BI Service
- Microsoft Fabric: DirectLake, Dataflow Gen2, OneLake / Lakehouse
- Modeling & Languages: DAX, Power Query (M), SQL, Dimensional Modeling

Job ID 562065
Ambition is a leading global recruitment and executive search business operating across key international cities. We access hard-to-find, high-calibre...
More jobs From Ambition
Ambition
Lei Yue Mun, Hong Kong
Ambition
Hong Kong
Ambition
Hong Kong
Ambition
Hong Kong
Ambition
Singapore
Ambition
Singapore
Boost your career
Find thousands of job opportunities by signing up to eFinancialCareers today.More Jobs Like This