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