×
Andrew Ibison

Andrew Ibison

Transaction Analytics at EY

Leamington Spa, UK
07955217286

Background


About

About

Bringing insight and analytical skills to solve complex business problems. Experienced in e-commerce, logistics, deal analytics & data analysis.

Work Experience

Work Experience

  • Manager: Transaction analytics - EY

    Nov, 2022 - Present

    As a Deal Analytics Manager at Ernst & Young, I work across the markets but have a specialisation in the AM&M (Advanced Manufacturing and Mobility) sector. I have experience manging teams and leasing directly with clients throughout the engagement lifecycle. I work on both buy-side and sell-side transactions, collaborating with clients to provide valuable insights. My main focus is analyzing datasets and conducting due diligence. My goal is to distil complex information into practical insights that enhance decision-making and drive successful deals.

  • Analytics & Data Manager - Kite Packaging

    Dec, 2020 - Nov, 20221 year 10 months

    I managed a team of data analysts providing support to a wide range of business activities. I was a member of the Kite Packaging leadership team which together make important business decisions for the group.

    Areas of responsibility include: Budgeting for multiple profit/cost centres, Commercial Analysis, PPC/SEO, Website Pricing, Financial Reporting, Website Analytics, Freight Distribution Analysis, Business Intelligence, Database Administration and CRM Administration.

    Technologies used: SQL, Python, Power BI, Excel, VBA, Bespoke CRM, Bespoke WMS, Sage 1000, Netstock, Google Analytics, Google Ads

  • Senior Commercial Analyst - Kite Packaging

    Sep, 2020 - Dec, 20203 months

    Following the success I had in the e-commerce division, I was ‘parachuted in’ to help with the National Distribution Centre; responsibilities that were additive to my role. This appointment also came with an additional person to my team. My appointment objective was to turn around the stock efficiency within the warehouse, optimising a system called Netstock.

  • Data Analyst - Kite Packaging

    Aug, 2016 - Aug, 20204 years

    This role focused on data analytics for the e-commerce division. I made significant advances in PPC and website pricing models, contributing towards record growth of the e-commerce division. This role involved managing another junior data analyst and provided me my first experience of managing an analytics team.

  • Graduate Management Scheme - Kite Packaging

    Aug, 2015 - Jul, 201611 months

    A graduate program designed to develop future leaders. This gave exposure to a wide range of business disciplines, completing high level projects and presenting to senior management on a quarterly basis.

Skills

Skills

  • Data Analysis

    PowerBI

    SQL

    Excel

    VBA

    Python

    Alteryx

    PowerApps

  • Transaction Due Diligence
  • Search Engine Optimization (SEO)

    SEMRush

    Majestic

    MOZ

    Google Search Console

  • Paid Search Advertising

    Google Ads

    Bing Ads

    Adroll Remarketing

  • Problem Solving
  • Budgeting
  • Project Management

    PRINCE2®

  • Tender Management

    Payment Providers

    Parcel & Pallet Couriers

  • Pricing Strategy
  • Stock Management

    Netstock

  • Distribution Logistics
Education

Education

  • Mathematics, Bachelor's Degree, University of East Anglia

    Dec, 2012 - Dec, 2015

  • Mathematics, Further Mathematics, Physics, A-Levels, Dr. Challoner's Grammar School

    Dec, 2009 - Dec, 2011

Awards

Awards

  • Alteryx Designer Advanced Certification , Alteryx

    Awarded on: Feb 01, 2024

  • Alteryx Designer Core Certification , Alteryx

    Awarded on: Mar 06, 2023

  • Power BI Data Analyst Associate , Microsoft

    Awarded on: Jan 20, 2023

  • Azure Data Fundamentals , Microsoft

    Awarded on: Aug 27, 2021

  • Practitioner certificate in Project Management , PRINCE2®

    Awarded on: Aug 03, 2016

  • Foundation certificate in Project Management , PRINCE2®

    Awarded on: Aug 01, 2016

  • AdWords Certification - Search advertising , Google

    Awarded on: Sep 01, 2016

Interests

Interests

  • Climbing

  • Formula1

  • Gym