Learn Data Skills
Beta

George Hamilton-Jones

Certified

Data Analyst

Copyright Licensing Agency | United Kingdom

Technologies

My Portfolio Highlights

My New Track

SQL Fundamentals

My New Course

Introduction to Python

My New Track

SQL Fundamentals

Data navigator, guiding organizations through the sea of information.

My Work

Take a look at my latest work.

DataLab

Course Notes: Exploratory Data Analysis in Python

DataLab

Competition - predict hotel cancellation

DataLab

A Visual History of Nobel Prize Winners

DataLab

Course Notes: Exploratory Data Analysis in Python

My Certifications

These are the industry credentials that I’ve earned.

Data Literacy

Data Literacy

AI Fundamentals

AI Fundamentals

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Python
Introduction to SQL
Understanding Data Science
Intermediate SQL

My Work Experience

Where I've interned and worked during my career.

Copyright Licensing Agency | Jan 2022 - Present

Data Analyst – Technology, Operations and Data

As a data analyst in the publishing industry with strong skills in SQL, Python, and Microsoft Power BI, I have experience building complex data models and conducting ad hoc analysis of company data. Expertise: • Power BI (including DAX and Power Query) • Python (including Pandas and Seaborn) • SQL (data querying) • Excel (including tables, pivot tables, and Power Query) • Book publishing • School and higher education sectors • Product analytics Experience: • Updating and maintaining Power BI data models • Building new Power BI models • Conducting ad hoc analysis of company data • Following a training plan to improve as an analyst • Building a complex Monthly Active User measure in Power BI, winning a company merit award • Contributing to the founding of a new analytics function Workflow tools: • JIRA – track data projects, manage with Kanban • Mural – project ideation, hybrid meetings, brainstorming • Microsoft Teams – remote meetings, collaboration • SharePoint – collaboration Types of Data: • Customer data • Attitudinal surveys • Bibliographic details • Postcode address file (NSPL) • Higher education statistics
Show More

Copyright Licensing Agency | Apr 2019 - Present

Customer Support Advisor—The Education Platform and The Digital Content Store

Helping schools to use their books and CLA Education Licence digitally. • Setting up new schools on the Education Platform • Providing first line customer support • Managing customer queries with Zendesk • Providing administrative support to the Product team • Documentation • Processing data with Excel and Python Providing first line support for CLA's solution to simple copying and automated reporting under the Higher Education Licence. • Standard changes • Documentation • Functional escalation in a professional IT Service Management Environment Business intelligence • Designing, building and maintaining high quality reports using Power BI • Modelling data relationships where needed • Cleaning and shaping data with Power Query in Excel and Power BI • Identifying useful categories, granularity levels and types of data, consulting with company stakeholders • Writing measures and other calculations in DAX language • Building visuals to surface insights and help stakeholders tell their business stories

Foyles (W&G Foyle Ltd) | Oct 2018 - Apr 2019

Head Of Department, Lifestyle ; Duty Manager

Buying responsibility for Cookery, Craft, Puzzle Books, Sport, Gardening and Travel categories. Managing a team of booksellers, responsible for Lifestyle Department. Key responsibilities included: • Creating a pleasant and well-merchandised browsing environment • Buying new lines • Replenishing stock as it sold through the store • Promoting and overseeing excellent customer service • Preserving and repairing and the product range • Requesting, checking and picking returns of stock

Foyles (W&G Foyle Ltd) | Oct 2017 - Oct 2018

Acting Head of Department, Lifestyle; Duty Manager

N/A

Foyles (W&G Foyle Ltd) | Jun 2016 - Oct 2017

Assistant Head of Department, Lifestyle; Duty Manager

N/A

Foyles (W&G Foyle Ltd) | Aug 2014 - Oct 2017

Bookseller, Lifestyle

N/A

Foyles (W&G Foyle Ltd) | Jan 2014 - Aug 2014

Bookseller, Travel and Transport

N/A

Foyles (W&G Foyle Ltd) | Nov 2013 - Jan 2014

Christmas Temp, Cookery

Received an award for performance.

Christine Green Author's Agent | Jun 2013 - Aug 2013

Temporary Contracts Assistant

• Entered new and legacy publishing agreements into a Microsoft Access database • Handled submissions. • Read clients’ manuscripts and helped with edits. • Assisted with compilation of the short story collection Chestnut Street by Maeve Binchy from archival materials.

Christine Green Author's Agent | May 2013 - Jun 2013

Intern

N/A

Titan Publishing | Feb 2013 - Apr 2013

PR Intern

N/A

SelfMadeHero | Jan 2013 - Jan 2013

Editorial Work Experience

N/A

TASCHEN | Oct 2012 - Dec 2012

Sales, Marketing & PR Intern

Sales Materials, Media Outreach and Administrative Support.

Developing Telecoms Ltd | Aug 2012 - Aug 2012

Intern

• Wrote copy • Prepared images with Adobe Photoshop • Joomla! CMS software

William Morris Endeavor (Literary Department) | Jun 2012 - Jun 2012

Summer Intern

N/A

The Sunday Times | Sep 2009 - Sep 2009

Work Experience Trainee

N/A

My Education

Take a look at my formal education

BA, American Studies with Year AbroadUniversity of East Anglia | 2012
American History, American LiteratureReed College | 2011
History, English Literature, EconomicsDulwich College | 2008

Powered by

  • Work
  • Certifications
  • Courses
  • Experience
  • Education
  • Create Your Data Portfolio for Free