Senior Power BI Developer

Project Freelance; Birmingham; On-site; 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

Job Title: Senior Power BI Developer

Location: Completely Remote role, can be Located anywhere in the UK!

Salary: Depending on experience

Job Type: Permanent, Full Time

We're proud to be a trusted leader in SQL development services, and in database, server, cloud, and application services. We enjoy helping our clients, many of which are well-known household brands, stay connected and supported.

We are seeking an experienced Senior Power BI Developer to design, develop and support modern business intelligence and analytics solutions using Power BI and other SQL Server technologies.

About the role:

The successful candidate will combine strong technical expertise with excellent stakeholder engagement skills, helping clients and internal teams transform raw data into meaningful business insights. The role will involve creating enterprise-grade Power BI reporting platforms, and mentoring junior developers to support their technical and professional growth.

This is an excellent opportunity for someone who enjoys working across the full BI lifecycle, from requirements gathering and solution design through to development, deployment, optimisation and support.

Key duties:

Business Intelligence & Reporting

• 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

Client & Stakeholder Engagement

• 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

Leadership & Mentoring

• 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

About you

Essential

• 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

Desirable

• Experience with Azure Data Services
• Experience with Microsoft Fabric Data Factory
• Experience with Lakehouse architectures
• Experience with PowerShell automation
• Experience with CI/CD pipelines and automated deployments
• Experience with Python for data engineering or analytics
• An understanding of data warehousing principles and methodologies is preferable
• Experience developing ETL/ELT processes
• Knowledge of Microsoft Fabric and modern data platform technologies is preferable
• Knowledge of Microsoft Purview and data governance frameworks
• Microsoft certifications including PL-300, DP-600 or DP-203

Personal Attributes

• Excellent analytical and problem-solving skills.
• Strong communication and stakeholder management abilities.
• Passion for data and new technologies.
• Self-motivated and capable of working independently.
• Strong mentoring and coaching capabilities.
• Commercial awareness and customer-focused mindset.
• Ability to prioritise and manage multiple assignments simultaneously.
• Commitment to continual professional development.

Why join us:

• Competitive salary and benefits package
• Generous Pension Contribution Scheme (up to 10% match)
• Income Protection/Life Insurance
• 5 weeks' annual leave (pro rata) plus options to buy/sell days
• Paid birthday leave, volunteering days, and extra leave for long service
• Work with modern Microsoft technologies including Fabric, Power BI and Azure.
• Opportunity to influence technical direction and best practices.
• Supportive environment focused on learning and professional growth.
• Exposure to a diverse client base and challenging projects.
• Opportunity to mentor and develop the next generation of BI professionals.
• Company-sponsored training and certifications
• Quarterly team training and get-togethers

Expected recruitment timeline:

Applications close: 17 September

First interviews: Week of 21 September via video

Second interviews: 14 October in person

Candidates with experience of; Power BI Developer, Senior BI Developer, Business Intelligence Developer, BI Analyst, Data Visualization Specialist, Microsoft Fabric Developer, DAX Developer, SQL & Power BI Engineer, BI Consultant, Analytics Developer, Reporting Specialist, Data Modeller, Enterprise BI Developer, BI Technical Lead, Business Intelligence Analyst also be considered for this role.