Senior Business Intelligence Developer

Provallar Executive Search; Greater London; On-site; GBP 70,000 - 110,000; Full time

Job summary

Senior BI Developer is sought to join a fast-growing global sportswear and lifestyle brand. You will own the end-to-end Power BI environment, collaborating with business leaders to shape BI systems and data infrastructure as the business scales.

Key responsibilities include designing semantic models, optimizing SQL queries, managing ERP data, ETL pipelines, security and governance, and delivering enterprise BI solutions across Sales, Finance, Operations and Supply Chain.

Qualifications

• Substantial hands-on experience with Microsoft Power BI.
• Proficient in Advanced SQL Server / T-SQL.
• Strong skills in stored procedures and views.
• Ability to optimise SQL queries and performance.
• Experience with data transformation processes.
• Expertise in enterprise semantic models.
• Advanced DAX expertise and Power BI Service.
• Experience with Power BI gateways and dataflows.
• Understanding ERP data structures and integrations.
• Knowledge of BI governance and security.

Responsibilities

• Design, build and maintain scalable Power BI semantic models and datasets.
• Write, optimise and maintain complex SQL queries, views and stored procedures.
• Own backend SQL logic supporting the Power BI semantic layer.
• Manage ERP data structures, extraction and integrations.
• Design and maintain ETL processes and data transformation pipelines.
• Develop data cleansing, mapping and validation logic.
• Manage Power BI gateways, dataflows, workspaces and deployment pipelines.
• Develop and optimise DAX measures and calculations.
• Implement incremental refresh and performance optimisation.
• Troubleshoot data integrity, refresh, connectivity and performance issues.
• Establish BI governance, security, testing, documentation and version-control standards.
• Manage Row-Level Security (RLS) and user access.
• Support reporting across Sales, Finance, Operations and Supply Chain.
• Act as internal SME for Power BI infrastructure and BI data architecture.

Skills

Advanced SQL

SQL performance tuning

Data transformation

Enterprise semantic models

Advanced DAX

BI governance and security

Row-Level Security

Tools

Power BI

SQL Server

T-SQL

Stored procedures

Dataflows

Gateways

Job description

Senior BI Developer | Power BI | Advanced SQL | ETL | Data Engineering

This is an opportunity to join a fast-growing global sportswear and lifestyle brand house at a genuinely exciting point in its journey.

The business is entrepreneurial, ambitious and moving quickly, with an expanding portfolio of internationally recognised brands and plenty happening across the Group.

But what particularly stands out to me is the culture. It is commercially driven, straightforward and built around people rather than layers of corporate structure. Senior management are accessible, down-to-earth and respectful, and good people are trusted to get on with the job.

It is also an environment where you can make a difference.

Rather than simply inheriting systems and processes that are set in stone, you will work collaboratively with business leaders and colleagues to shape, improve and build the BI systems and data infrastructure the business needs as it grows.

For the right BI professional – a hands-on Senior BI Developer - this means ownership, visibility and influence – and the opportunity to see the direct impact of what you build.

We are looking for someone strong in the engine room of BI: advanced SQL Server, ETL, ERP data, data transformation, semantic modelling, advanced DAX and Power BI architecture – someone capable of owning the data and infrastructure behind enterprise reporting.

The Role

You will take technical ownership of the end-to-end Power BI environment and its underlying data infrastructure, working across enterprise datasets, semantic models, ERP data, SQL Server, ETL processes, gateways, dataflows and reporting architecture.

Key responsibilities include:

• Design, build and maintain scalable Power BI semantic models and enterprise datasets
• Write, optimise and maintain complex SQL queries, views and stored procedures
• Own backend SQL logic supporting the Power BI semantic layer
• Manage ERP data structures, extraction and system integrations
• Design and maintain ETL processes and data transformation pipelines
• Develop data cleansing, mapping and validation logic
• Manage Power BI gateways, dataflows, workspaces and deployment pipelines
• Develop and optimise complex DAX measures and calculations
• Implement incremental refresh, partitioning and performance optimisation
• Troubleshoot data integrity, refresh, connectivity and performance issues
• Establish BI governance, security, testing, documentation and version-control standards
• Manage Row-Level Security (RLS) and user access
• Support reporting across Sales, Finance, Operations and Supply Chain
• Act as the internal technical SME for Power BI infrastructure and BI data architecture

What We Are Looking For

You should have substantial hands‑on experience in:

• Microsoft Power BI
• Advanced SQL Server / T-SQL
• Stored procedures and views
• SQL query optimisation and performance tuning
• Data transformation
• Enterprise semantic models
• Advanced DAX
• Power BI Service
• Power BI gateways and dataflows
• ERP data structures and integrations
• BI governance and security

Experience working with complex ERP, Finance, Sales, Operations, Supply Chain or Retail data would be particularly relevant.

This opportunity should appeal to a Senior BI Developer, BI Engineer or SQL BI Developer who enjoys getting underneath the reporting layer and taking ownership of the data, SQL, ETL and architecture that make enterprise BI work.

#SeniorBIDeveloper #BIDeveloper #BIEngineer #PowerBIDeveloper #PowerBI #SQLDeveloper #SQLServer #TSQL #ETLDeveloper #DataWarehouseDeveloper #DataEngineering #SemanticModels #DAX #ERPData #BusinessIntelligence #PowerBIService #DataModelling #SQLBI #MicrosoftBI #LondonJobs