Power BI Developer: AI-Driven Dashboards & Flexible Work

Avidity Careers; England; On-site; GBP 42,000 - 52,000; Full time

Benefits offered by this job

23 days holiday per annum

Bank holidays

Flexible working options

Mental health support

Job summary

Avidity Careers is seeking a Power BI Developer to join the Insight and Reporting Team. You will translate requirements and build dashboards and reports that deliver fast, intuitive insights and influence how we operate.

Work alongside stakeholders to ensure reporting is scalable, trusted and easy to use. You’ll apply advanced DAX, Power Query and create wireframes, then embed AI visuals where appropriate and document data sources and limitations.

Qualifications

• 3+ years of hands-on Power BI development experience
• Advanced DAX skills including time intelligence and complex calculated measures
• Strong experience with Power Query (M) for data transformation
• Experience with design specifications or wireframes rather than building from scratch
• Strong analytical thinking, attention to detail, and problem-solving skills
• Able to communicate effectively and collaborate across functions
• Comfortable building and interpreting wireframes
• Experience with data warehouses is desirable
• Experience with source control and deployment pipelines for BI assets is desirable
• Experience of AI visuals and using Copilot in Power BI is desirable

Responsibilities

• Build and maintain high-quality Power BI reports and dashboards from wireframes and specifications
• Develop intuitive reporting experiences across desktop and web platforms
• Use Power BI features such as bookmarks, drill-through, tooltips, dynamic titles and conditional formatting
• Optimize reports for rendering performance including visual count, query reduction and aggregations
• Write clear and well-structured DAX measures to support report-level calculations
• Use DAX Studio and Performance Analyser to diagnose and resolve slow-running measures
• Use Power Query (M) to shape and transform data at the report level
• Write clean, documented code
• Embed AI-driven visuals and capabilities within Power BI reports where appropriate
• Stay current with new Power BI features and AI capabilities
• Test reports thoroughly prior to publication and follow deployment pipelines
• Document reports with purpose, data sources and known limitations

Skills

DAX

Wireframes

Analytical thinking

Communication

Tools

Power BI

Power Query (M)

Job description

Avidity Careers is seeking a Power BI Developer to join the Insight and Reporting Team. You will translate requirements and build dashboards and reports that deliver fast, intuitive insights and influence how we operate.

Work alongside stakeholders to ensure reporting is scalable, trusted and easy to use. You’ll apply advanced DAX, Power Query and create wireframes, then embed AI visuals where appropriate and document data sources and limitations.