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.