Power BI Developer

Job Title: Power BI Developer

Location: London (Hybrid)

Job Type: Contract

Responsibilities:

– Design, develop, and maintain Power BI reports and dashboards using both Direct Query and Import modes.

– Integrate Power BI with Databricks and other data sources, ensuring secure and efficient data access.

– Optimize the performance of Direct Query reports through advanced query tuning and robust data modeling techniques.

– Operate within Power BI Pro licensing constraints (excluding Premium, PPU, and Fabric) while maintaining high usability and performance standards.

– Implement incremental data refresh strategies where applicable, accounting for the limitations of non-date-partitioned datasets.

– Navigate complex data models—such as degenerate fact tables with multiple grains—by applying creative solutions to meet reporting needs.

– Facilitate the migration of selected reports from Direct Query to Import mode, focusing on refresh efficiency and optimized model size.

– Engage with stakeholders to gather requirements and deliver insightful, actionable reporting solutions.

– Resolve challenges related to Paginated Report Builder, particularly in connection with Databricks integration.

Required Skills and Experience:

– Proven expertise in Power BI, with hands-on experience in both Direct Query and Import modes.

– Strong background in connecting Power BI to Databricks and managing large datasets effectively.

– Deep knowledge of query optimization, data modeling, and performance tuning techniques.

– Familiarity with incremental refresh mechanisms and their limitations.

– Experience working with complex, non-standard data models, including multi-grain fact tables.

– Demonstrated success in delivering real-time or near real-time reporting solutions.

– Ability to operate efficiently within Power BI Pro environments, with a solid understanding of associated licensing considerations.

– Excellent analytical thinking, problem-solving skills, and effective communication abilities.

Regards

Anita