Job Radar › All jobs

BI and Data Warehouse Analyst

Company
Morgan Law
Location
London, United Kingdom
Salary
71 797 £/mo
Posted
2026-10-30

Skills: Power BI, SQL, MS SQL

Salary: £? - ? per year

Requirements:

• Strong SQL Server and data warehouse migration experience • Power BI report and semantic model design, including DAX and performance • Dimensional modelling and clear metric definitions • Experience with reconciliation, testing and controlled deployment • Ability to develop solutions directly and explain design decisions to teams

Responsibilities:

• Migrate and reconcile agreed national, commissioning and other external reports, submissions and feeds that depend on the warehouse • Develop agreed reusable semantic model components and simplify priority portal reports where this supports the migration plan • Assess and migrate agreed priority reporting outputs • Develop required SQL objects and Power BI reports • Assess the existing semantic model and implement agreed shared measures and dimensions • Catalogue and review portal reports • Document, test, release and hand over the work • Create a catalogue covering report owner, purpose, usage where available, duplication and technical dependencies • Recommend whether reports should be retained, retired, merged or redesigned, and provide reasons

Technologies:

• Data Warehouse • DAX • Support • Power BI • SQL

More:

We are working with an NHS Trust that is moving reporting to a new Data Warehouse. This five-month role will provide specialist capacity to keep agreed external reporting working through the transition, then support a review of the wider reporting estate. The role pays…

Full text and application on the employer's site.

Apply