Power BI Developer

Summary: The Power BI Developer role involves designing, developing, and maintaining Power BI reports and dashboards, integrating with various data sources, and optimizing performance. The position requires collaboration with stakeholders to deliver actionable reporting solutions while navigating complex data models. The developer will also be responsible for implementing data refresh strategies and resolving integration challenges. This is a contract position based in London with hybrid working arrangements.

Key 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 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 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.

Key Skills:

• 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.

Salary (Rate): undetermined

City: London

Country: United Kingdom

Working Arrangements: hybrid

IR35 Status: undetermined

Seniority Level: undetermined

Industry: IT