Colin Blyth Email & Phone Number

London, GB

London Area, United Kingdom

London, England, United Kingdom

• Key Accomplishments:
• Consulted with teams across the business to implement and track KPIs relating to commercial performance
• Managed migration away from legacy data analysis infrastructure
• Combining, Cleansing and validating large data sets
• Fully automated data pipeline and reporting in Tableau Server
• data-led insight reporting shared company-wide every quarter covering industry trends, growth opportunities, benchmarking versus UK marketTools used:

• Heading up division-wide BI and reporting, implementing full ETL workflow, and advanced dashboarding in Tableau enabling multiple teams to monitor key KPIs
• Lead analyst for all digital activation in UK, focused on optimising all programmatic buys
• Developed and implemented automation across all trading activities, including custom bidding algorithms, optimising media budget allocation and full commentary.
• Use of R/Python scripting to extract and process data from multiple 3rd party APIs.
• Interrogating programmatic auction logs to identify market trends and opportunities for pricing efficiencies, sharing actionable insights through newsletters and division-wide presentations.

London

• Responsible for growth and development of the UK market’s Data Management Platform
• Client consultancy aimed at developing full tagging strategies across web properties
• SQL querying to extract data from multiple platforms, Tableau for blending and visualisation
• Onboarding client data into DMP for profiling and targeting, auditing data quality, building custom segments, client facing presentations to deliver findings on customer behaviours.
• Production of in-depth industry specific insights, including cross-device, digital attribution, interaction of advertising channels, supply path optimisation, ad frequency, seasonality
• Developed best practice methods for A/B tests to evaluate effectiveness of all data sources.

London

• Trafficking, performance optimisation and yield management of display, VOD and rich media campaigns for portfolio of 15 clients covering finance, travel & automotive sectors.
• Analysing and interpreting campaign performance trends, creating/customising automated reports, providing top level and deep insight reporting for clients and senior management.
• Operational responsibility for newly launched RTB Marketplace for premium VOD inventory.

Edinburgh, Scotland, United Kingdom

• Supporting ambitious programme to integrate health & social care resourcing, analysing data in Excel and using charts to visualise potential impact on key NHS performance indicators.
• Co-ordinated programme of performance feedback visits to 32 councils across Scotland.

Analytics In Python

Computational Thinking Using Python Xseries, Computer Programming, 93%

Bachelor Of Science (Bsc), Mathematics And Statistics, 1St (Honours)

Education record