Intelligence Analyst (February 2024 – Present) – Health Care Services Sector

• Collaborating with the Population Health Team to gather, extract, manipulate, and analyse data for various health initiatives, producing high-quality reporting and intelligence to support decision-making across the organisation.
• Developed dashboards for key health metrics, such as infant admissions and Over65 hospital admissions, using Power BI.
• Responsible for complex data transformations using Power Query, extracting data from multiple sources (e.g., SQL, Excel, APIs).
• Utilised various DAX functions, including calculated measures and columns, to build interactive reports with features like drill-through, filters, and bookmarks.
• Created SQL stored procedures to extract data and integrated this into Power BI for real-time reporting.
• Automated reports using scheduled refreshes to ensure accurate and up-to-date data.
• Produced insightful trend analysis and YOY (Year on Year) calculations to assess hospital admissions and their causes, aiding in health resource planning.

Data Analyst (June 2023 – November 2023) – Media and Marketing Sector

• Developed and implemented dashboards for tracking key performance indicators (KPIs) such as Click Through Rate, Open Rate, and Bounce Rate for email campaigns and website traffic.
• Worked closely with marketing, sales, and senior management teams to understand requirements and deliver tailored reports for performance analysis.
• Performed data analysis and transformations in Excel before loading it into Power BI for reporting.
• Applied time intelligence functions and various DAX techniques to perform month-on-month analysis and calculate key metrics.
• Optimised data extraction and transformation processes using SQL, reducing processing time by 30% and enhancing data quality.
• Automated weekly and monthly reporting processes, saving 10 hours per week and ensuring timely delivery of critical business reports.
• Collaborated with business users to design data models that supported their analytical needs.

Data Analyst (December 2017 – June 2021) – Marketing Sector

• Worked on marketing analytics for a telecom client, focusing on lead lifecycle management, revenue tracking, and spend analysis for lead nurturing.
• Developed dashboards in Power BI to track key metrics such as Leads, Sales Accepted Leads (SALs), Marketing Qualified Leads (MQLs), and revenue associated with each stage.
• Utilised DAX to create calculated columns, measures, and computed tables, and to perform complex metrics calculations.
• Designed and published various dashboards, including Funnel Executive, Campaign, Market Share, and Digital/Traditional Market Summary Dashboards.
• Configured Row Level Security (RLS) for data access control and set up Power BI Gateways to automate data refreshes and keep reports up to date.
• Worked extensively with SQL to extract and transform data for reporting, streamlining processes to improve efficiency.

For further information on this candidate please use reference number: 012