BI and Data Warehouse Analyst

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