Senior BI Developer: Google Analytics / BigQuery Qlikview

Recruiter
Michael Page Technology
Location
Bath
Posted
23 Apr 2019
Closes
29 Apr 2019
Contract Type
Permanent
Hours
Full Time

Leading UK organisation require a Senior BI Developer to work on a variety of critical projects surrounding product and brands to enhance reporting & analytics and increase insight into market, brand and business performance.

Client Details

Leading UK organisation

Description

Leading UK organisation require a Senior BI Developer to work on a variety of critical projects surrounding product and brands to enhance reporting & analytics and increase insight into market, brand and business performance.

  • Dashboard data (Qlikview) to provide actionable insights, using projections and historical trend analysis.
  • Create rules to categorise articles across multiple brands and platforms using CMS and automated tagging data to build a uniform taxonomy.
  • Create a brand level affiliate report that is automatically updated and will enable the team to understand trading patterns and measure month-to-date site performance vs. previous month and year.
  • Create dashboards in Google Sheets / Data Studio to present data in a meaningful way across multiple cuts of data e.g. country, website and affiliate merchant category.
  • Automate the aggregation and storing of processed affiliate transaction and Google Analytics data from Qlikview QVDs / BigQuery.
  • QA and iterate on rules to achieve high-quality data.
  • Link taxonomy to Google Analytics data (traffic and event tracking) and affiliate transaction data.
  • Unify dimensions in affiliate transaction data across each of the API aggregators.
  • Migration of legacy affiliate data: Analyse transaction data to understand which affiliate networks and merchants are still coming from legacy accounts; Use Google Analytics data to identify legacy links and widgets across websites, articles and templates

Key Technical Skills:

  • Google Analytics / BigQuery / Cloud Platform, Amazon Redshift
  • SQL / Qlikview Script and Design
  • Excel/Google Sheets

Profile

Expert knowledge of:

  • Google Analytics / BigQuery / Cloud Platform, Amazon Redshift
  • SQL / Qlikview Script and Design
  • Excel/Google Sheets

Job Offer

Opportunity to work on varied projects

Similar jobs

Similar jobs