Harry Antwi Williams

Data Platforms Manager @Wavemaker

London, GB

Leading business intelligence teams in relation to transformation of data across the business. • Analyzing and building on media campaign data to illustrate the effectiveness of media campaigns over a given time period. • Data engineering and predictive modelling using Google Big Query, MySQL and other data platforms. Utilizing CTE’s, windows functions and output aggregation.• Transforming data from SQL to a Microsoft Excel format to allow for accurate data to information transformation and visualization.• Developing an ETL process in relation to media data, from allocated clients in order to amalgamate data into a client usable data dashboard. This is done via the use of Adverity which is the data platform of choice for the business. • Deploying and testing the Power BI data dashboard prior to finalizing product development approval. • Successfully developing data solutions with the aim of allowing business visualization teams to view and present data, with greater speed and accuracy. • Conducting weekly client feedback sessions and presenting data structural changes and bug fixes.• Further data transformation and automation using DBT labs. • Building DSP and sponsored Ads data pipelines using AMC (Amazon Marketing cloud).• BAU data management for live reporting used by client teams. • Liaising with AdOps, display, programmatic, paid search, paid social and Ecommerce teams across the business. • Development approach using the CI/CD approach. • Rolling out data solutions using agile delivery methodologies and practices. • Using modelling practices such as Media Mix Modelling analysis to determine ROI, ad spend, total revenue and ROAS. Additionally, I have to consider various other factors to effectively measure and analyze aggregated data.

London South Bank University

Bachelor's degree, Information Technology

London South Bank University

Higher National Diploma , Information Technology

London Electronics College

Computing and systems development

GREIG CITY ACADEMY

GCSE's , Secondary school