Senior Power BI Lead — Remote UK

Project Freelance; Birmingham; Hybrid; GBP 70,000 - 90,000; Full time

Benefits offered by this job

Generous Pension Contribution Scheme (

5 weeks' annual leave (pro rata)

Birthday leave

Job summary

Onyx-Conseil is seeking a Senior Power BI Developer to design, develop and support BI solutions using Power BI and SQL Server technologies. This remote UK-wide role offers stakeholder engagement, mentoring of junior developers and end-to-end BI lifecycle exposure.

You will build enterprise Power BI reporting platforms, develop dimensional models, DAX calculations and performance optimisations, while guiding best practices and governance across projects.

Qualifications

• Strong commercial experience developing Power BI solutions.
• Advanced knowledge of Power BI including: DAX, Power Query, Semantic Models, Row Level Security (RLS), Workspace and deployment management
• Extensive SQL Server development experience
• Experience designing and implementing dimensional models
• Experience gathering requirements and producing technical documentation
• Experience working directly with business stakeholders and clients
• Experience troubleshooting and performance tuning reporting and database solutions
• Experience using source control systems such as Git and Azure DevOps

Responsibilities

• Design, develop and maintain enterprise Power BI solutions.
• Design and maintain scalable data models using dimensional modelling and star schema best practices.
• Create intuitive dashboards, reports and visualisations that enable data-driven decision making.
• Develop and maintain semantic models, datasets, dataflows and Power BI workspaces.
• Implement best practices for report performance, usability, security and governance.
• Develop advanced DAX calculations, measures and KPIs.
• Optimise report and dataset performance, ensuring reliability and scalability.
• Wider Fabric knowledge would be advantageous.
• Understanding of data warehouse solutions would be ideal but not essential.
• Work directly with clients and business stakeholders to understand requirements.
• Translate business requirements into robust technical solutions.
• Conduct workshops, technical reviews and design sessions.
• Produce high-quality technical documentation and solution designs.
• Provide guidance and recommendations on best practices and future roadmap opportunities.
• Provide technical leadership within the BI aspect of the Development team.
• Mentor and support junior BI Developers and Data Engineers
• Undertake code reviews and provide constructive technical feedback
• Assist in developing standards, frameworks and development methodologies
• Promote continual learning and knowledge sharing across the team

Skills

Power BI

SQL Server

Data Modelling

DAX

Power Query

Row Level Security

Git/Azure DevOps

Tools

Azure Data Services

Microsoft Fabric Data Factory

PowerShell

CI/CD pipelines

Job description

Onyx-Conseil is seeking a Senior Power BI Developer to design, develop and support BI solutions using Power BI and SQL Server technologies. This remote UK-wide role offers stakeholder engagement, mentoring of junior developers and end-to-end BI lifecycle exposure.

You will build enterprise Power BI reporting platforms, develop dimensional models, DAX calculations and performance optimisations, while guiding best practices and governance across projects.