I am working with an NHS Trust that is moving reporting to a new Data Warehouse. You will provide specialist capacity to keep agreed external reporting working through the transition, then support a review of the wider reporting estate.
The role is for 5 months initially and paying £380-400pd (inside IR35).
Responsibilities
- Migrate and reconcile the agreed national, commissioning and other external reports, submissions and feeds that depend on the warehouse.
- Develop agreed reusable semantic model components and help simplify priority portal reports where this supports the migration plan.
- Assess and migrate the 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 with report owner, purpose, usage where available, duplication and technical dependencies. Recommend retain, retire, merge or redesign, with reasons.
Essential
- 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
- Reconciliation, testing and controlled deployment
- Able to develop solutions directly and explain design decisions to teams
BI and Data Warehouse Analyst in London employer: Morgan Law Careers
As a leading Charity, we pride ourselves on fostering a supportive and collaborative work environment that prioritises employee well-being and professional growth. Our Central London location offers a vibrant atmosphere, with hybrid working options that promote work-life balance, while our commitment to meaningful projects ensures that your contributions have a direct impact on the community. Join us to be part of a dedicated team where your expertise in technology services will help drive innovation and service improvement.
