Learn Data Skills
Beta
Jonathan Dray

Jonathan Dray

Senior Analyst

Inspiralytics Ltd | Eversley, Hook, UK

Technologies

My Portfolio Highlights

My New Course

Introduction to Python

Unleashing the magic of data, one algorithm at a time.

My Work

Take a look at my latest work.

project

Investigating Netflix Movies

course

Data Manipulation with pandas

course

Introduction to Python

course

Intermediate Python

DataCamp Course Completion

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

My Work Experience

Where I've interned and worked during my career.

Supermassive Games Ltd | Apr 2023 - Present

Senior Data Analyst

N/A

Pyramid Analytics | Jan 2021 - Apr 2023

Customer Solutions Consultant

▪ Consult for high value clients, including Global Engineering & Finance companies, identifying needs and requirements. Then integrating Pyramid Analytics in order to Model their data and build out dashboard suites. ▪ Provide support to customers, both remotely and in person, within committed SLAs alongside creating help articles to enable self-service by customers and identifying the need for new articles from usage metrics. ▪ Collaborate with product and software development teams through active participation, developing factors from a customer perspective to be incorporated.
Show More

Ceredata | May 2019 - Jan 2021

Consultant

▪ Design and build of dashboard solutions for end clients using Pyramid Analytics/Power Bi. ▪ Offered strategic advisory services that evaluated client’s data analytics landscape, identifying the best possible solution to meet and empower better decisions. ▪ Helped with the ongoing management and maintenance of the complete data lifecycle, including Real-Time and Batch ETL development, Data Warehousing, Cloud Analytics and Visualisations.

Inspiralytics Ltd | Apr 2017 - Present

Managing Director (Data Visualisation & Integration Specialist)

At Inspiralytics Consulting, we specialise in Data Visualisation & Integration. Whether that is structured, unstructured data from a variety of types and industries. From raw data creation & extraction through to system integration, analysis, predictive modeling and of course data visualisation both online and offline. Applying the latest methodologies and technologies to all things data. ▪ Manage a consultancy specialising in database design, data integration, data analytics, machine learning, business intelligence and Visualisation. ▪ Build out data warehousing & modelling apply necessary predictive algorithms. ▪ Visualize analytics using Power BI/Tableau. Specialties Data Visualisation, Python, SSAS, Tableau, PowerBI, Pyramid Analytics, Data Processing, Analytics, Data Integration, Machine Learning, Predictive Modeling, Business Intelligence , Big Data, SQL, Webservices/APIs, Webscraping, Netsuite, Faststats, Database Design, Database Administration and Javascript

Mind Gym | Dec 2014 - Mar 2017

CRM Admin & Data Analyst

▪ Managed analysis and development projects within the company’s internal CRM system, NetSuite, alongside the external MySQL and Mongo DB databases and their integration with Netsuite and external applications such as Pardot ▪ Build and delivery of customised solutions to business issues. ▪ Led small analytics team, coaching and motivating staff members to enhance job performance values and meet target initiatives.

The Purple Agency | Oct 2013 - Nov 2014

Data Project Manager

▪ Technical lead for client database & analytics projects from concept through to delivery, liasing with clients to understand business requirements and coordinate in house resource. ▪ Worked on analytical side of projects, bringing my experience to solve clients questions.

Datalytics Ltd | Oct 2011 - Oct 2013

Marketing Analyst

services, coffee chains and charities ▪ Responsible for building out data analysis using predictive analysis techniques - Churn analysis, Basket analysis, customer segmentation using cluster analysis such as K-means/KNN, predicting future needs and revenue/ subscription using regression analysis.

Alchemetrics | Jul 2008 - Aug 2011

Database Analyst

My primary responsibility was to service, update and maintain a number of Client marketing databases answering any client queries and updating frontend systems on a weekly basis. This involved heavy use of SQL to query and fix any database issues, knowledge of each of the client database structures and use of Linux shell scripting to create and pull processes together, the role also requires advanced use of MS Office. I was also responsible for running adhoc jobs which require me to dedupe client data and run it against suppression databases to client's specifications. Other responsibilities include maintaining suppressions databases and the use of marketing tools such as Apteco Faststats to extract data for use in client marketing campaigns. Along with experience of using a frontend ESP tool to setup email campaigns for clients.

Nielsen | Dec 2002 - Jul 2008

Senior Data Analyst

2005-2008 Global AdView Senior Data Analyst In my role as a Senior Data Analyst my primary responsibility was to lead a small team in verifying the quality of incoming data and resolving any issues with the central Global Adview database, this involved a lot of contact with suppliers and a heavy use of SQL to query and fix database issues. Other responsibilities I had in this role were to develop new processes for creating client reports and extracts using advanced Excel/Access techniques including VBA macros. I was also tasked with developing data quality checks and took on responsibility for managing the workload of all Assistant Data Analysts within my team and representing my team in meetings at our Amsterdam office. 2003-2004 Global AdView Senior production Executive Client reporting duties, other day to day responsibilities included helping team members with any client queries, training new staff members, formatting and loading new datasets onto the central Global Adview database, harmonizing data, creating new queries to retrieve data from the database, general quality control and checking on outgoing reports, and, visiting and presenting information to clients. I played a major role in restructuring our database categories into a more up to date and organized category tree, as well as being involved in organizing a project in which we monitored advertising data from across the world and matched it with advertising creatives. 2002-2003 Global AdView Production Executive Being a member of the international department of this advertising monitoring company, my primary responsibility was working to tight deadlines to produce Ad-Hoc and ongoing reports using a wide range of tools. These included advanced MS office in conjunction with the Brio querying tool to retrieve data from the central Oracle database, along with some exposure to SQL.

My Education

Take a look at my formal education

BSc Software Engineering, ITUniversity of Portsmouth | 2000
GCSE's; s; A Levels, English; Science, History, French and Business Studies; History and Business...Edgbarrow Comprehensive School | 1997

About Me

Jonathan Dray

Jonathan hasn't filled in a bio text

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free