- Established the BI function and team across Product, Marketing & Core areas- Managing, advancing and expanding our primary BI platform (Looker)- Supporting stakeholders in data-driven strategic decision making- Overhauling areas of data infrastructure to improve accuracy, reliability and capability- Constructing efficient LookML to improve speed and productise data across the organisation- Creation and maintenance of key assets that provide insight into every area of the business- Advanced Analytics implementations with R/Python/SQL- Long term BI strategy and planning

- Built out and support the development of the Sweepstakes business- Integrated and maintain raw Google Analytics data in BigQuery, enabling enhanced analytics post-Universal Analytics sunsetting- Established GA4 ETL covering all sites and events- Supporting Analytics and Engineering questions

- Built an end-to-end data pipeline covering all transaction, billing and compliance data integrated into Snowflake- Developed an automated AML transaction monitoring system- Direct Hubspot API integration to analytics database and developed an advanced commercial data model- Built out Looker environment from scratch to cover all key KPIs, OKRs and operational aspects of the business- Automated invoice revenue calculations accounting for complex fee and commercial structures

- Owned and managed the digital data infrastructure for both Radio and Publishing with hundreds of data pipelines processing over ~30bn rows per month.- Supporting both the Publishing and Radio business in data engineering, ML, analytics & log level processing.- Integrated and developed a data model for the Audio+ subscription business.- Developing realtime impressions pipelines for the Octave business and managing all data pipelines.- Built out a model for On-Air radio competitions, allowing us to improve revenue streams, competition reporting & CRM response rates.- Curating Looker dashboards for senior management KPI's, content analysis for writers/editors and revenue/performance trackers for the affiliate teams.- Integrated log-level performance and revenue data for Bauer Radio territories, including: UK, Ireland, Poland, Slovakia, Norway, Denmark, Sweden, Finland and consultancy work for Greece & Romania.- Created realtime CRM unsubscribe & subscribe APIs - ensuring the process was fast, reliable and secure.- Developed a podcast performance model that is IABv2 compliant and is surfaced to both internal and external users for podcast analytics, ad reporting & user behaviour.- Improved financial reporting by aggregating all revenue data & revenue streams into a single model for finance & ad teams to report on.- Managed the CRM imports, exports and reporting for email communication covering ~12m users.- Integrated a realtime webhook logging process for onsite/inapp data collection, which operates across projects covering ads, competitions, user activity & subscription entitlements.- Expanded the use of data and analytics within the business through Looker with self-serve analytics models & dashboards.- Built a variety of ML models for ad-optimisation and content.- Scoped and adjusted the digital data architecture to be GDPR compliant and created a custom SAR interface.- Consulting with the US division on it's competition platform.

Created and maintain the entire process from data creation/collection > pipe-lining > storing/archiving > cleaning/categorising(for brand level/market level analytics) > visualizing/higher level processing > analysing for over 100 brands (crossing Radio, Lifestyle and Specialist brands).Experienced with: R (advanced), Facebook API, Twitter API, Youtube API, Pinterest API, Instagram API, Spike, Keylime, Google Analytics API, Looker, Shiny (Web Apps/Data Apps), Redshift, EC2 machine - with R server, Google BigQuery, Snowplow pipeline, Machine Learning systems, caret package.Tools: R, Python (pandas), SQL (postgres/redshift/bigquery), webscraping (via R), caret package, dashboarding/visualising data (via Looker/R), R Server/Elastic map reduce, Amazon AWS services (S3/Redshift/EC2 etc), BlueKai DMP platform, identity stitching (Web cookie to registration data and unknown ID's).Projects: Social Reach and content engagement, Audience Selection/Segmentation, Holistic Data Models, Leading indicators/KPI overview, taxonomy segmentation, engagement/overlapping audience profiling, realtime audio stream (matching content performance by what is currently playing, active sessions and performance by time of day and device). Machine learning applications - e.g. retrospectively classifying article content as evergreen, viral, season and assigning value based on performance index/percentile. Created a data platform to view all third party ad data. Currently building a news/clickbait classifier based on article title (nlp).