Description

A data analyst with a background in retail and digital marketing. Skilled in data manipulation, visualisation and regression analysis. Proficient in SQL, Python, R, and Power BI. Enjoys synthesis of her business acumen gained during her two master’s degrees and coding skills to help create unique and successful business solutions.

• Data manipulation with MS SQL server

• Visualisation & reporting with Power BI

• Statistical analysis and Machine Learning with R, Python

• Microsoft Office Tools

• Fluent French, Native Korean

- Projects

Digital marketing: Reporting of leads generation / Ad-hoc analysis
Retail: Competitor Analysis / Food Analysis / Forecasting / Segmentation Analysis / Sales dashboard
Master's degree: Research Report using Random Forest Analysis with R studio / Dissertation using logistic regression analysis with R studio

Industry field of expertise

Languages

English
Native or bilingual
French
Fluent
Korean
Native or bilingual

Workplace preferences

Can work on-site

London (up to 50km)

Freelancer
Data Analyst (Freelance)
September 2024 - Today (1 year and 9 months)
London, UK
• Freelancing for eProspects
• Cleaning and transforming raw data using SQL and loading it into Power BI
• Analysing campaign performance and media buying strategies, tracking Key Performance Indicators (KPIs)
• Developing and maintaining interactive dashboards in Power BI, eabling data-driven decision-making
E-prospects
Media Campaign Scientist
August 2019 - March 2020 (7 months)
London, UK
• Optimised SQL queries to extract and manipulate data from multiple sources
• Analysed media campaigns' effectiveness, media buying strategies and tracked KPIs
• Created interactive and visually impactful quality Power BI reports to track KPIs, monitoring the quality of reports
• Provided recommendations for decision-making with regards to campaign optimisation and business strategy
• Presented analysis results to internal stakeholders, ensuring clarity and alignment with objectives
Quant Marketing
Data Analyst
May 2018 - August 2019 (1 year and 3 months)
London, UK
• Designed and implemented the data Extract, Transform, Load (ETL) workflow, automating data processing using MS SQL Server Integration Services (SSIS)
• Analysed IKEA's marketing campaign effectiveness, tracked sales KPIs
• Developed comprehensive dashboards in Dundas BI, using SQL to pull large datasets (up to 2 million entries) from the company's data warehouse
• Monitored and improved the dashboards' quality
• Conducted segmentation and predictive analysis, providing insights into customer behaviour and contributing to improved engagement
• Built a predictive model using logistic regression to assess competitor impact on customer purchasing patterns
• Delivered strategic recommendations, leading to measurable improvements in campaign performance