Samuel Hill
London,
Summary
Detail-focused Data Analyst with years of proven experience in cleaning, handling, and analyzing large unstructured datasets within the Health & Retail sectors. Proficient in transforming raw and dirty data into actionable insights through analytical techniques, data cleansing, data manipulation and visualization. Passionate about creating informative and visually compelling visualizations and dashboards that effectively communicate findings to both technical and non-technical stakeholders. Eager to expand on my programming knowledge to find more efficient methods to analyze and manipulate data.
Overview
5
5
years of professional experience
Work History
Insights Analyst
New Look
11.2023 - Current
- Produced, maintained & presented a range of PowerBi Dashboards for key stakeholders.
- Transitioned a number of reports from Excel to PowerBI.
- Baseline Project (ROI) - Produced a interactive Dashboard to track current vs future KPI's in order to show return on investment of new HR system.
- Created the ETL process for Mandatory internal training to support compliance requirements. This involved extracting data from a SQL database, transforming the data in excel then loading data into PowerBI.
- Manipulated & extracted data from a number of different systems including SQL & SAAP.
- Produced tables & views in SQL database to support reporting requirements.
Data Analyst
Whanau Ora Commissioning Agency
06.2020 - 06.2023
- Involved in the building and maintaining of SQL server database.
- Queried the SQL server database on a weekly basis.
- Generated various excel reports, utilizing formulas to assist with pulling metrics data and presenting information to stakeholders.
- Created Powerbi dashboards to monitor and track key performance indicators.
- Utilized Power Query to transform and manipulate data, in order to create more accurate Power BI dashboards.
- Implemented basic Dax formulas to enhance Power BI Dashboards.
- Experience in Extract, Transform, and Load (ETL) processes.
- Documented key processes with process mapping.
- Developed interactive maps with ArcGIS geo analytics software to provide our front line workers with accurate information. eg cluster maps, street maps and statistical area maps
- Implemented Macros on excel to partially automate reports.
- Created basic python scripts to automate certain processes for reporting. eg automating data cleans and emails.
- Project for KPI Automation - Encompassed ASA business intelligence solutions Including tasks such as creating schemas, developing data dictionaries and collaborating closely with data scientists.
- Experience working in a fast paced, agile work environment.
Junior Data Analyst
Te Whanau O Waipareira Trust
01.2019 - 05.2020
- Cleaned and consolidated various datasets.
- Streamlined data cleaning processes using excel formulas.
- Presented results to internal working groups - including technical staff and front-line staff.
- Produced and presented a range of reports on excel.
- Created basic dashboards to visualize data.
Education
Bachelor of Commerce - Economics And Accounting
University of Auckland
Auckland, New Zealand07.2021
Skills
- Data cleaning and processing
- Data visualization
- Data manipulation
- Clear and concise communication
- Presentations and reports to technical & front-line audience
- Excel
- Python (basic scripts)
- SQL
- Microsoft Power BI
- Spatial Visualization (ArcGIS)
Accomplishments
- Awarded the Trust Drury Scholarship at the University of Auckland 2019.
- 1 of 8 University of Auckland students to attend Leadership Summit 2020.
Additional Information
Prior to relocating to the UK, I was employed as a data analyst in Auckland, New Zealand. I am presently in possession of a Youth Mobility Scheme visa.
Can provide references upon request.
Timeline
Insights Analyst
New Look
11.2023 - Current
Data Analyst
Whanau Ora Commissioning Agency
06.2020 - 06.2023
Junior Data Analyst
Te Whanau O Waipareira Trust
01.2019 - 05.2020
Bachelor of Commerce - Economics And Accounting
University of Auckland
Similar Profiles
James McSherryJames McSherry
Retail assistant at New LookRetail assistant at New Look
Giorgia MartiniGiorgia Martini
Partnership Operations Manager at New LookPartnership Operations Manager at New Look
Lucy Burrows-OwenLucy Burrows-Owen
Supervisor at New LookSupervisor at New Look