BI and Data Warehouse Analyst

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 (Apply online only)pd (inside IR35). ResponsibilitiesMigrate 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 outputsDevelop required SQL objects and Power BI reportsAssess the existing semantic model and implement agreed shared measures and dimensionsCatalogue and review portal reportsDocument, test, release and hand over the workCreate a catalogue with report owner, purpose, usage where available, duplication and technical dependencies. Recommend retain, retire, merge or redesign, with reasons. EssentialStrong SQL Server and Data Warehouse migration experiencePower BI report and semantic model design, including DAX and performanceDimensional modelling and clear metric definitionsReconciliation, testing and controlled deploymentAble to develop solutions directly and explain design decisions to ..... full job details .....