John Arnold Email and Phone Number

Generalist Data Analyst role with specialization in Web (GA360, Tealium) and mobile Analytics•Data Analyst in a multi-functional Client Analytics team supporting marketing operations in BDC’s 100+ employee marketing division•Subject matter expert in Google web analytics data, advised on tagging strategy, taxonomy and best practices to implementation specialists. Actively guided ETL of hit/session/user scoped web data to data engineers and architects. •Resolved data… Show more Generalist Data Analyst role with specialization in Web (GA360, Tealium) and mobile Analytics•Data Analyst in a multi-functional Client Analytics team supporting marketing operations in BDC’s 100+ employee marketing division•Subject matter expert in Google web analytics data, advised on tagging strategy, taxonomy and best practices to implementation specialists. Actively guided ETL of hit/session/user scoped web data to data engineers and architects. •Resolved data quality issues in a multi-million-dollar SAP deployment leveraging web data. Advised and collaborated across multiple teams ranging from IT solution architects to end-users within the marketing division. •Primary point of contact on all analytics reporting for BDC’s mobile client app. Developed KPI reports, ran regular AdHoc analyses and generated targeting lists for mobile app adoption campaigns.•Engaged in QA initiatives to assess, identify and resolve web data quality issues requiring daily and advanced use of T-SQL (SSMS). •Currently the lead analyst migrating BDC’s web analytics software (UA -> GA4) requiring profound knowledge of BDC’s website architecture, analytics measurement strategy and marketing needs Show less

Business Analyst• Conducted industry sales analyses for clients such as Mazda Canada and HSBC Canada to support fiscal year budget planning and go-to-market advertising strategies• Employed statistical techniques on raw survey data to estimate the size of Mazda Canada’s brand target, demographics and geographical distribution• Prepared and presented market analyses and media target summaries to senior Mazda marketing stakeholdersWeb Analyst• Supported web… Show more Business Analyst• Conducted industry sales analyses for clients such as Mazda Canada and HSBC Canada to support fiscal year budget planning and go-to-market advertising strategies• Employed statistical techniques on raw survey data to estimate the size of Mazda Canada’s brand target, demographics and geographical distribution• Prepared and presented market analyses and media target summaries to senior Mazda marketing stakeholdersWeb Analyst• Supported web page design with Google Analytics 360 ad-hoc web traffic and engagement analyses • Developed and presented Mazda Canada’s web traffic and media dashboard using Google Data Studio• Lead Adobe Analytics web tagging processes, coordinating with development, project management and account teams on new client web pages• Analyzed Adobe Analytics user-level data (Adobe Data Feeds) with R aggregation and data cleansing functions to isolate and exclude bots inflating web traffic metrics Show less

• Conducted internal and client-side ad hoc analytics requests using Adobe Analytics to identify insights and support future webpage design• Developed regression models to forecast client web traffic targets and conversion rates• Website tagging quality assurance ensuring accurate and consistent data capture and flow• Responsible for client web traffic reporting on weekly, monthly and quarterly cadences using Adobe Report Builder

Summer employment (university)

Summer employment (university)