Interim BI & Quality Lead. LilyLifestyle

Location: London, hybrid
Duration: 4 months + possible extension
Rate: 400 per day, Inside IR35
Sector: London Market Insurance / Wealth & Life Domains

The BI & Quality Lead is the primary link between technical delivery and business value within the Wealth and Life domains. You are responsible for ensuring that the transition from legacy reporting (Business Objects, SSRS, Qlik) to the Hydra Power BI layer preserves institutional memory and meets the specific regulatory and operational needs of a mature insurance and investment estate.

• Domain-Led Engagement:
  Lead targeted value discovery workshops across key domains including Wealth/Investments, Life/Actuarial, and Finance to capture decision-critical KPIs.
• Stakeholder Validation:
  Manage the Business Validation Gate process, ensuring no report or data mart is retired without explicit confirmation from Domain Data Sponsors.
• User Utility Discovery:
  Deploy and analyze targeted user surveys to identify "Shadow Analytics" and manual workarounds currently used by the 1,500+ users across the estate.
• Value Index Matrix:
  Build and maintain the Business Value Rationalisation Matrix, scoring legacy assets based on their impact on regulatory submissions, solvency reporting, and daily investment performance.
• Parity & Quality Assurance:
  Define and execute the "Parity Testing" strategy to ensure the new Hydra dashboards match legacy Oracle EDW outputs with 0% variance for critical financial metrics.
• Pilot Delivery:
  Oversee the reporting phase of the "Thin Slice" Pilot, delivering production-ready Power BI dashboards that demonstrate the self‑service capabilities of the target architecture.

• Insurance/Wealth
  
  Experience:
  
  Deep understanding of data structures and reporting requirements specific to Life and Wealth products, including Actuarial model inputs and Solvency II dependencies.
• Legacy-to-Cloud Transition:
  Proven track record in migrating users from traditional BI platforms (Business Objects, Qlik) to Power BI environments.
• Business Analysis:
  Strong capability in "translating" complex technical data lineages into business-friendly value propositions.
• Quality Governance:
  Experience in defining data quality gates and reconciliation frameworks for parallel-running systems.

• Visualization:
  Expert proficiency in Power BI (DAX, Power Query) and exposure to Microsoft Purview for automated lineage visibility.
• Data Interrogation:
  Strong SQL skills to perform cross-system validation between Oracle EDW and the Hydra Azure Landing Zone.
• Legacy Systems:
  Familiarity with the semantic layers and report structures of Business Objects (Universes), SSRS, and Qlik View/Qlik Sense.
• Microsoft Certified:
  Power BI Data Analyst Associate (PL-300).
• Microsoft Certified:
  Azure Data Fundamentals (DP-900).
• Knowledge of DAMA Data Quality or Data Governance frameworks.