$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Junior
{{ $t($store.state.user.experience_search_name) }}
0
jobs
Google Cloud Certified Professional Data Engineer and Data Engineer
James Cottrill
,
London, United Kingdom
Experience
Other titles
Skills
I'm offering
I am a Google Cloud Certified Professional Data Engineer with experience across all areas of data, from analytics and insight to pipeline engineering, data structuring to data science. I strongly believe that data should be at the heart of every organisation, that it should be there to make business decisions and looking forward, not for reporting and looking back and that every team in the company should have access to and be empowered to use data in their work.
I am the author of a number of GTM custom templates available in the GTM template library and have just released an alpha version of a Google Tag Manager R package, googleTagManageR.
I'm also a keen skier, scuba diver and climber and love the outdoors. I've been volunteering with Protect Our Winters UK as the head of data and digital since January 2018, working on optimising existing assets, developing actionable campaigns that deliver measurable results and increasing the quality and quantity of content we're producing as well as developing the website to deliver a B2B engagement campaign launching next year.
I am the author of a number of GTM custom templates available in the GTM template library and have just released an alpha version of a Google Tag Manager R package, googleTagManageR.
I'm also a keen skier, scuba diver and climber and love the outdoors. I've been volunteering with Protect Our Winters UK as the head of data and digital since January 2018, working on optimising existing assets, developing actionable campaigns that deliver measurable results and increasing the quality and quantity of content we're producing as well as developing the website to deliver a B2B engagement campaign launching next year.
Markets
United States
(Remote
only)
United Kingdom
France
(Remote
only)
Germany
(Remote
only)
Links for more
Once you have created a company account and a job, you can access the profiles links.
Industries
Language
English
Fluently
French
Good
Ready for
Larger project
Ongoing relation / part-time
Full time contractor
Available
My experience
2020 - 2020
freelance
Data Engineer
The Telegraph.
• Built a pipeline processing of Ad Manager Export logs and external data sources including Google APIs and Adobe Analytics into a usable data source for the operational analytics team to understand their Ad Manager performance using Python (PySpark) and SQL.
• Deployed the pipeline using Docker and Airflow on a Kubernetes cluster.
• Created a new pipeline in DBT, using nine SQL queries and six data sources to give a full overview on advertising revenue sources and reduced the size existing queries from 400GB to 60GB.
• Identified areas to reduce BigQuery storage on the project, saving over $18,000 a year in storage costs for one dataset.
• Deployed the pipeline using Docker and Airflow on a Kubernetes cluster.
• Created a new pipeline in DBT, using nine SQL queries and six data sources to give a full overview on advertising revenue sources and reduced the size existing queries from 400GB to 60GB.
• Identified areas to reduce BigQuery storage on the project, saving over $18,000 a year in storage costs for one dataset.
Python, Pyspark, Mysql, Dbt, Google cloud, Gcp, Google Cloud Platform, Big Data, Sql
2019 - 2020
freelance
Senior Data Analyst
AKQA.
• Built connected ETL Pipeline and Analytics processes, extracting data from multiple sources including Google Analytics and Ads via API calls and processing the data using R to automate the production of monthly reports.
• Measurement framework design, tag specification and implementation for a luxury car website, working closely with developers to ensure correct dataLayer implementation and continued maintenance of the dataLayer during sprints.
• GDPR compliance updates to the GTM implementation of a multinational car manufacturer using OneTrust, updating over 70 containers in the space of 30 minutes using my own R Package to manage the updates, saving over 100 hours of manual work and enabling teams to quickly confirm compliance.
• Reporting on multiple campaigns using data from GA, CRM and Social Listening (Netbase) to deliver a 360 view of the effectiveness of the campaigns and provide insights on areas to monitor or improve for future campaigns.
• Developed a modified Enhanced Ecommerce implementation using the EE framework to track car accessory wish list usage without a full ecommerce function on site.
• Training for the in-house teams in London and Gothenburg on best practices for Google Analytics and GTM set up and implementation.
• Measurement framework design, tag specification and implementation for a luxury car website, working closely with developers to ensure correct dataLayer implementation and continued maintenance of the dataLayer during sprints.
• GDPR compliance updates to the GTM implementation of a multinational car manufacturer using OneTrust, updating over 70 containers in the space of 30 minutes using my own R Package to manage the updates, saving over 100 hours of manual work and enabling teams to quickly confirm compliance.
• Reporting on multiple campaigns using data from GA, CRM and Social Listening (Netbase) to deliver a 360 view of the effectiveness of the campaigns and provide insights on areas to monitor or improve for future campaigns.
• Developed a modified Enhanced Ecommerce implementation using the EE framework to track car accessory wish list usage without a full ecommerce function on site.
• Training for the in-house teams in London and Gothenburg on best practices for Google Analytics and GTM set up and implementation.
Design, Ecommerce, CRM, R, GDpr, GDPR Compliance, Analytics, Website, Compliance, Implementation, Testing, Campaign, Framework
2019 - 2019
job
Data Analyst
ConversionWorks.
• Implementation: Complete Google Analytics and Google Tag Manager setup for Boots UK and ROI including advanced dataLayer documentation and full Enhanced Ecommerce setup as well as multiple marketing tag types, Enhanced Ecommerce setup for Lloyd Webber Theatres and Which?, tagging specification for Diageo sites using their enterprise solution and a full GTM audit for IUBH (German University) followed by new tagging specification, developer documentation and new multi-site zoned implementation using data attributes.
• GTM Custom Templates: I have been an active figure within the GTM community for Custom Templates, developing three templates that are freely available in the official GTM Community template gallery. My implementations for Boots UK and IUBH used only custom templates for marketing tags, improving the site security and reducing container size, load time and complexity. I also implemented a custom template for Diageo's new Trade Desk Pixel, combining it with my multi-column tables to manage tags with multiple values in one table.
• Cloud: Auto PII detection for Which? using Cloud Functions, DLP and BigQuery, Data Syphon using Python to send GA hits direct to BigQuery, "Free BigQuery" Implementation using Python, Product Categorisation for Affiliates using BigQuery and Cloud Functions, website deployment using App Engine.
• Audits & QA: QA for the Enhanced Ecommerce implementation for Next, QA of a PII Audit for Belron and Scoping for a GTM redevelopment for Domino's Pizza.
• Insights and Evaluation: Produced custom dashboards using R/Shiny covering custom
• GTM Custom Templates: I have been an active figure within the GTM community for Custom Templates, developing three templates that are freely available in the official GTM Community template gallery. My implementations for Boots UK and IUBH used only custom templates for marketing tags, improving the site security and reducing container size, load time and complexity. I also implemented a custom template for Diageo's new Trade Desk Pixel, combining it with my multi-column tables to manage tags with multiple values in one table.
• Cloud: Auto PII detection for Which? using Cloud Functions, DLP and BigQuery, Data Syphon using Python to send GA hits direct to BigQuery, "Free BigQuery" Implementation using Python, Product Categorisation for Affiliates using BigQuery and Cloud Functions, website deployment using App Engine.
• Audits & QA: QA for the Enhanced Ecommerce implementation for Next, QA of a PII Audit for Belron and Scoping for a GTM redevelopment for Domino's Pizza.
• Insights and Evaluation: Produced custom dashboards using R/Shiny covering custom
Website, Manager, Enterprise, Google, App, Community, Implementation, Analyst, Developer, It, Security, Marketing, QA, Analytics, ROI, Google tag manager, Deployment, R, Audit, Cloud, Ecommerce, Google analytics, Python
My education
2012
-
2015
University of St Andrews
N/a, Medicine
N/a, Medicine
2005
-
2012
Adams Grammar School
Secondary, A Levels
Secondary, A Levels
AS - Physics (B)
James' reviews
James has not received any reviews on Worksome.
Contact James Cottrill
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to James directly in Worksome.
38100+ qualified freelancers
are ready to help you
Tell us what you need help with
and get specific bids from skilled talent in Denmark