Ian Haley

Lead the design and development of a Global and UK-wide suite of Placement Monitoring dashboards in Power BI, incorporating placement, premium, and claims data. Facilitated requirements capture and validation through workshops with over 10 senior operational leads, engaging stakeholders to document requirements and mapping processes, workflows, and data flows to identify gaps and guide design. Translated business needs into dashboard features, user stories, and acceptance criteria, creating POCs, wireframes, and mock-ups, and defining KPIs and metrics for consistent understanding. Sourced and transformed data from multiple databases using SQL and Databricks, collaborating with data engineering on modelling, and designing datasets, measures, and interactive visualisations in Power BI using DAX. Resolved data quality and availability by collaborating with technical teams. Performed validation and reconciliation. Designed and executed test scenarios. Facilitated UAT sessions and managed feedback. Delivered end-user training, supported deployment, post-implementation checks, and issue resolution, gathered feedback for enhancements, and promoted data governance and reporting best practice.

I worked as a Business Analyst in the Data Delivery & Analytics workstream on a data migration program from an on-premises data warehouse to a cloud solution. Gathered and documented business requirements, translating them into technical specifications for data delivery and Power BI solutions. Conducted data gap analyses and collaborated with data modelers to ensure integration supported business needs. Designed wireframes and Power BI visualisations, demonstrating key concepts and aligning with stakeholder requirements. Led workshops and maintained clear communication with stakeholders to manage expectations and align project objectives. Utilised technical skills including DAX, SQL, and Snowflake to analyse large datasets, create queries, and support data transformation. Interrogating data within policy administration systems to support data mapping requirements for migration.

Participated in an MDM Programme, enhancing data governance across 5 distinct workstreams. Utilised SQL for thorough data mapping, ensuring comprehensive understanding of organisational data flow and interconnectivity. Managed a portfolio of data-centric system enhancements, involving collaboration with 5 cross-functional teams. Overseen data mapping projects with SQL, showcasing scope through management of over 20+ organisational datasets. Utilised API refinement skills to optimise data exchange processes, enhancing system efficiency and contributing to the overall success of data integration initiatives. Played key role in refining & implementing Master Data Management (MDM) strategies, centralising critical data assets & engaging stakeholders effectively.