09/19/2026 updated
100 % available
Junior Data Analyst | Workforce Planning & People Analytics
Buckhurst Hill, United Kingdom
Only remote
NCFE Level 3 Diploma - Data TechnicianAbout me
I'm a data analyst with 15+ years across logistics, aviation and casino operations. Two things connect it all: People & Data. I'm now entering Analytics with real business experience, and I welcome small to medium projects. I focus on workforce analytics in Excel and Power BI. Send me a message.
Data AnalysisBusiness IntelligenceHR AnalyticsMicrosoft Power BIVisual AnalyticsData Selection
MS Excel (Advanced)
Advanced proficiency in MS Excel, including complex formulas, Power Query and Pivot Tables. Development of scheduling tools and dashboards to visualise workforce data and improve operational efficiency.
Power BI & Data Reporting
Intermediate knowledge of Power BI, covering data modelling, DAX and dashboard design. Creation of visual reports and forecasts to support workforce planning and management decision-making.
Workforce Planning & Scheduling
Seven years of hands-on experience in workforce planning, building rotas for 300+ employees across multiple departments, implementing scheduling systems and optimising shift coverage aligned with demand forecasts.
SQL & Python
Working knowledge of SQL and Python for data querying and analysis tasks.
WFM & Time and Attendance Systems
Practical experience with Kronos (UKG), TMS Mitrefinch and BrightHR for workforce management, time tracking and payroll support.
SAP & ERP Systems
Experience working with SAP alongside systems such as MAP, AS400, ASR/TDO, DCON/SMARTS and AIMS for logistics planning, customer master data management and invoicing.
Data Modelling & DAX
Intermediate capability in data modelling and DAX within Power BI to build analytical models and support reporting requirements.
KPI Tracking & Performance Measurement
Design and implementation of tracking tools to measure performance where no KPI framework previously existed, enabling data-driven management decisions.
Advanced proficiency in MS Excel, including complex formulas, Power Query and Pivot Tables. Development of scheduling tools and dashboards to visualise workforce data and improve operational efficiency.
Power BI & Data Reporting
Intermediate knowledge of Power BI, covering data modelling, DAX and dashboard design. Creation of visual reports and forecasts to support workforce planning and management decision-making.
Workforce Planning & Scheduling
Seven years of hands-on experience in workforce planning, building rotas for 300+ employees across multiple departments, implementing scheduling systems and optimising shift coverage aligned with demand forecasts.
SQL & Python
Working knowledge of SQL and Python for data querying and analysis tasks.
WFM & Time and Attendance Systems
Practical experience with Kronos (UKG), TMS Mitrefinch and BrightHR for workforce management, time tracking and payroll support.
SAP & ERP Systems
Experience working with SAP alongside systems such as MAP, AS400, ASR/TDO, DCON/SMARTS and AIMS for logistics planning, customer master data management and invoicing.
Data Modelling & DAX
Intermediate capability in data modelling and DAX within Power BI to build analytical models and support reporting requirements.
KPI Tracking & Performance Measurement
Design and implementation of tracking tools to measure performance where no KPI framework previously existed, enabling data-driven management decisions.
Experience
Professional experience10+ years
Freelancer since2026
Languages
EnglishFluentSpanishGoodHungarianNative speaker
Project history
Led the site rollout of Kronos (UKG) across all departments (400 employees) during the Aspers to Genting acquisition. Designed a Rolling Rota system for Table Gaming using historical data and Power BI forecasts. Built a rota scheduling tool in Excel reducing rota production time from two days to under three hours. Managed schedules for 300 employees during and after lockdown, tracking furlough hours in TMS Mitrefinch. Implemented a Flexible Work Request review process and generated weekly Excel dashboards on absence, staffing levels and workforce trends.
Promoted to Supervisor within a year of joining, overseeing 300 gaming machines through the Casino Management System. Built an Excel-based machine locator tool mapping 300 gaming machine numbers to floor locations, deployed on iPads. Led a team of 5 as night shift supervisor (23:00 to 07:00) on a 24/7 gaming floor, managing payout paperwork and accuracy checks for jackpots ranging from 5,000 to 50,000 GBP.
Managed aviation customer master data across SAP, DCON/SMARTS and AIMS to minimise invoicing errors. Built a tracking tool to measure Customer Master performance and led the NA Stripes project creating 400+ customer accounts, earning a management award.