Senior Business Intelligence Developer

Harnham - Data & Analytics Recruitment; West Midlands; Hybrid; GBP 50,000 - 70,000; Full time

Benefits offered by this job

Hybrid working

Office visits to Wolverhampton

Job summary

Harnham - Data & Analytics Recruitment in the West Midlands is seeking a Senior BI Developer to own the end-to-end BI lifecycle. You will design and maintain scalable Power BI dashboards, develop SQL data models, and leverage Microsoft Fabric to deliver advanced analytics for commercial performance.

The role offers hybrid working with regular travel to a Wolverhampton office, a £50,000–£70,000 salary, and opportunities to shape BI standards, governance, and self-service analytics across the

Qualifications

• Strong commercial experience across business intelligence, analytics or BI development.
• Advanced SQL skills covering complex transformations, dimensional modelling and performance optimisation.
• Deep hands-on Power BI expertise, including DAX, data modelling, deployment pipelines and optimisation.
• Experience with Microsoft Fabric or a comparable modern cloud data platform.
• Strong knowledge of data warehouses, Lakehouse architectures and ETL or ELT processes.
• Experience creating scalable and reusable datasets for reporting and analytics.
• Understanding of commercial and financial measures such as revenue, margin, ROI and P&L.
• Confidence partnering with both technical and non-technical stakeholders.
• A strong approach to data accuracy, governance and lineage.
• Experience within retail, e-commerce or consumer-focused environments with pricing, promotions, inventory or multi-site data.

Responsibilities

• Own end-to-end BI lifecycle from design to deployment.
• Design and maintain scalable Power BI dashboards, semantic models and datasets.
• Build and optimise SQL data models supporting analytics, reporting and forecasting.
• Develop solutions within Microsoft Fabric, including Lakehouse, Warehouse and data pipeline capabilities.
• Design and maintain ETL and ELT pipelines using Fabric Data Factory, Power Automate or comparable technologies.
• Establish reusable BI datasets supporting multiple reporting requirements.
• Partner with finance, marketing, product and operational stakeholders to analyse revenue and performance.
• Define and standardise KPIs across key business areas.
• Automate manual reporting and improve self-service analytics through Power BI and the wider Microsoft ecosystem.
• Maintain data quality, lineage, governance and performance.
• Translate complex analysis into clear commercial insights for senior stakeholders.
• Support developing BI and analytics professionals while helping establish technical best practice.

Skills

Power BI

SQL

Data Modelling

DAX

Microsoft Fabric

ETL/ELT

Data Governance

Stakeholder Communication

Tools

Power Automate

Fabric Data Factory

Job description

Senior Business Intelligence Developer

Hybrid - West Midlands

£50,000 - £70,000

The Company

They are a growing, consumer-focused organisation investing significantly in their data and technology capabilities. Data is increasingly central to how they understand commercial performance, customers and operational effectiveness. You will join an environment undergoing continued transformation, with the opportunity to improve how BI is developed, governed and adopted across the organisation.

The Role

As a Senior BI Developer / Senior Data Analyst, you will own key elements of the end-to-end BI lifecycle. You will:

• Design and maintain scalable Power BI dashboards, semantic models and datasets.
• Build and optimise SQL data models supporting analytics, reporting and forecasting.
• Develop solutions within Microsoft Fabric, including Lakehouse, Warehouse and data pipeline capabilities.
• Design and maintain ETL and ELT pipelines using Fabric Data Factory, Power Automate or comparable technologies.
• Establish reusable BI datasets supporting multiple reporting requirements.
• Partner with finance, marketing, product and operational stakeholders to analyse revenue, pricing, customer behaviour and wider commercial performance.
• Define and standardise KPIs across key business areas.
• Automate manual reporting and improve self-service analytics through Power BI and the wider Microsoft ecosystem.
• Maintain strong standards around data quality, lineage, governance, documentation and performance.
• Translate complex analysis into clear commercial insights for senior stakeholders.
• Support developing BI and analytics professionals while helping establish technical best practice.

Your Skills & Experience

You will bring:

• Strong commercial experience across business intelligence, analytics or BI development.
• Advanced SQL skills covering complex transformations, dimensional modelling and performance optimisation.
• Deep hands-on Power BI expertise, including DAX, data modelling, deployment pipelines and optimisation.
• Experience with Microsoft Fabric or a comparable modern cloud data platform.
• Strong knowledge of data warehouses, Lakehouse architectures and ETL or ELT processes.
• Experience creating scalable and reusable datasets for reporting and analytics.
• Understanding of commercial and financial measures such as revenue, margin, ROI and P&L.
• Confidence partnering with both technical and non-technical stakeholders.
• A strong approach to data accuracy, governance and lineage.

Experience within retail, e-commerce or another consumer-focused environment would be beneficial, particularly involving pricing, promotions, inventory or multi-site data. Exposure to Power Apps, experimentation or A/B testing would also be advantageous.

What They Offer

• Salary dependent on experience.
• Hybrid working, with regular travel to an office in Wolverhampton.
• Significant ownership of the BI environment and its future development.
• Exposure to Microsoft Fabric and a modern Microsoft data stack.
• Opportunity to influence BI standards, self-service analytics and data-driven decision-making.
• Scope to develop your technical leadership and mentoring experience as the data capability evolves.