Senior BI Developer - Power BI

Chapman Tate Associates; Wolverhampton; Hybrid; GBP 60,000 - 80,000; Full time

Job summary

A leading BI consultancy is searching for a Senior BI Developer in Wolverhampton. This role emphasizes full technical ownership of BI solutions, primarily utilizing Power BI. Candidates should have over 5 years of experience in BI development, advanced SQL skills, and hands-on expertise in Power BI, including data modelling and ETL processes. The position also involves mentoring junior developers, developing insights into business performance, and ensuring data governance. This is a full-time, hybrid role with significant impact on data transformation projects.

Qualifications

• 5+ years in BI / analytics / BI development with proven ownership.
• Deep understanding of commercial metrics like margin and revenue.
• Ability to work with technical and non-technical stakeholders.

Responsibilities

• Design and optimize Power BI solutions and datasets.
• Develop SQL-based data models for performance reporting.
• Lead BI storytelling for senior stakeholders.

Skills

Advanced SQL

Power BI expertise

Data modelling

Commercial awareness

ETL / ELT experience

Tools

Power Automate

Fabric Data Factory

Job description

Overview

Turn data into decisions. Own the BI layer end to end.

We’re looking for a Senior BI Developer who lives and breathes the Power BI ecosystem — someone who can design elegant data models, build high-performance dashboards, and translate complex commercial questions into trusted, scalable insight.

This is a hands-on, high-impact role sitting right at the centre of the business. You’ll own the BI layer from source to screen, shaping how data is modelled, governed, and consumed across finance, marketing, product, and operations.

If you’re excited by modern Microsoft data platforms and want your work to directly influence revenue, pricing, and customer strategy — keep reading.

The Role

This isn’t just dashboard development. You’ll take full technical ownership of our business intelligence estate, with Power BI at its core.

• Design, build, and optimise enterprise-grade Power BI solutions — semantic models, datasets, dashboards, and deployment pipelines
• Develop robust SQL-based data models that support analytics, forecasting, and performance reporting
• Play a key role in evolving our Microsoft Fabric platform, including Lakehouse/Warehouse design and data pipelines
• Design and maintain ETL / ELT processes using Power Automate, Fabric Data Factory, or similar tooling
• Own the end-to-end BI lifecycle — ingestion, transformation, modelling, visualisation, and business adoption
• Partner closely with commercial teams to deliver insight into pricing, promotions, customer behaviour, margin, and revenue
• Define, standardise, and monitor KPIs across sales, marketing, product, and customer domains
• Drive automation and self-service BI, reducing manual reporting through Power BI, Power Apps, and workflow automation
• Ensure high standards of data quality, governance, documentation, and performance optimisation
• Lead BI storytelling for senior stakeholders — turning data into clear, confident decisions
• Mentor junior BI developers and analysts, shaping best practice across the BI function

About You

You’re a leader who is technically strong, commercially aware, and confident owning solutions — not just contributing to them.

• 5+ years in BI / analytics / BI development, with clear technical ownership
• Advanced SQL (complex transformations, dimensional modelling, performance tuning)
• Deep, hands-on Power BI expertise — DAX, data modelling, optimisation, and deployment pipelines
• Experience working with Microsoft Fabric or comparable modern data platforms (warehouse / lakehouse)
• Proven delivery of ETL / ELT pipelines using Power Automate, Fabric Data Factory, or similar
• Strong understanding of commercial and financial metrics (margin, revenue, ROI, P&L)
• Ability to work confidently with stakeholders across technical and non-technical teams
• A sharp eye for data accuracy, lineage, and governance

Nice to have

• Experience in retail, e-commerce, or consumer-facing environments (pricing, promotions, inventory, multi-site data)
• Exposure to Power Apps for building operational or data-driven tools
• Experience with A/B testing, experimentation, or promotional analysis
• Background in a high-growth or transformation-led organisation

Working Pattern

• Full-time, hybrid role
• Regular travel to the head Office in Wolverhampton

This is a great opportunity for the successful candidate to be involved in a major transformation of their data and moving this over to the cloud. Please apply with your updated CV to be considered for this opportunity.