Data Platform & BI Lead (London)

Environmental Resources Management (ERM); Greater London; Hybrid; GBP 70,000 - 110,000; Full time

Job summary

Environmental Resources Management (ERM) in London is seeking a Data Operations Lead to maintain and evolve ERM's data platforms, focusing on SQL Server, BI, and Fabric technologies. You will ensure uptime, performance, and data quality across finance and reporting environments while guiding architecture and delivery of analytics solutions.

You will collaborate with IT and business stakeholders to design robust data models, build scalable ETL/ELT pipelines, and deploy Power BI reports and

Qualifications

• 5+ years in Database Admin/BI/Data Engineer roles.
• Strong SQL, data modeling, and performance tuning.
• Experience with Power BI and Microsoft Fabric.

Responsibilities

• Maintain availability and performance of SQL Server and BI platforms.
• Develop robust data models and data pipelines for reporting.
• Design scalable ETL/ELT processes and data governance.
• Collaborate with IT and business stakeholders on analytics solutions.

Skills

SQL Server

Power BI

ETL/ELT

Data modeling

Performance tuning

MDX/DAX

Azure Data Factory

Fabric (Microsoft)

Education

Bachelor's degree in a relevant field

Tools

SSIS

Azure Data Factory

Microsoft Fabric

OneLake

Notebooks

SSRS/Report Builder

Job description

Environmental Resources Management (ERM) in London is seeking a Data Operations Lead to maintain and evolve ERM's data platforms, focusing on SQL Server, BI, and Fabric technologies. You will ensure uptime, performance, and data quality across finance and reporting environments while guiding architecture and delivery of analytics solutions.

You will collaborate with IT and business stakeholders to design robust data models, build scalable ETL/ELT pipelines, and deploy Power BI reports and