Download PDF

Colin Ratcliffe

Analyst Seeking Exciting Opportunities in Berlin

Work History

Jan 2017July 2017

Web Analytics Intern

smava GmbH

Currently working as an intern at smava in Berlin. I'm working with various digital analytics tools to measure, analyse and optimise the company's online performance. Also performing analyses or building reports and dashboards based on large data sets to support all areas of the business. Main tools used are PostgreSQL, Tableau, Google Analytics, Google Tag Manager and Kissmetrics.

Jul 2016Dec 2016

Business Intelligence Intern


worked as an intern on the SAP OEM team in Dublin. My main tasks revolved around building out a database of partner contracts to improve financial forecasting. I worked closely with the financials team based in the USA to determine gaps in organisational knowledge and how to close those gaps using reporting and analytics. Main tools used were MS Excel and MS Access.

Dec 2015Jul 2016

Marketing & Engagement Officer

Blackstone Launchpad @ NUIG

Blackstone Launchpad is a campus start-up accelerator currently accessible by around 500,000 students globally. During my studies I worked at Blackstone Launchpad @ NUIG, looking after various aspects of marketing the programme to students, from online to on-campus events.

Sep 2015Dec 2015

Databases Lab Tutor

National University of Ireland, Galway

Lab tutor for postgraduate students of a Databases(SQL) module. Duties include teaching the main concepts of SQL, outlining solutions to the current problem to the class, answering questions from students.



MSc. Software Design & Development

National University of Ireland

Two year postgraduate course. Year 1 was an intensive course of getting to grips with programming and software design principles. Year 2 was an analysis-focused masters revolving around using machine learning on a natural language processing problem  - "The Effects of Context and Common Ground on Sarcasm Detection in Social Media Data". I achieved a 2:1 grade overall.


Bachelor of Commerce

University College Dublin

Business degree at one of Ireland's top universities. Over the course of my time at UCD I studied a wide range of modules relating to business strategy, management, marketing and information management. I achieved a 2:1 grade overall.

Programming Languages & Software Skills

  • SQL - Advanced
  • Javascript - Intermediate
  • HTML/CSS - Intermediate
  • Java - Intermediate
  • Python - Beginner

  • Google Analytics - Advanced
  • MS Excel - Advanced
  • MS Access - Advanced
  • Tableau - Intermediate
  • Google Tag Manager - Intermediate
  • Kissmetrics - Beginner


  • Google Analytics for Beginners
  • Advanced Google Analytics
  • Google Tag Manager Fundamentals