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 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.
