Ogilvy South Africa

Data Analyst

Job Function

Business Unit: Ogilvy CT
Department: Data Analytics
Location: Cape Town
Type: Permanent

Job description

We are looking for a data analyst to work within our data planning and analytics team.

The successful candidate will be responsible for working with a portfolio of clients. The successful candidate will not necessarily come from a pure web analytics background, but an excellent, in-depth level of knowledge in digital, CRM and social marketing, along with experience in strategic and analytical management of digital, social, CRM or integrated campaigns is essential.

Campaign strategy

  • Identifying client objectives and advising on suitable measurement strategies
  • Benchmarking performance across all online channels and
  • Development of KPI framework
  • Ensuring relevant tracking is put in place
  • Using methodical performance analysis to influence/support campaign strategies

Reporting and analysis

  • Reporting on key metrics, analysing and interpreting trends and providing actionable insights based on available analytics data
  • Analysing the effect of different online and offline channels on each other and developing and implementing innovative strategies for improvement and growth
  • Analysing online user behaviour, conversion data and customer journeys, funnel analysis and multi-channel attribution
  • Performing ROI analysis to evaluate efficiency and effectiveness of different marketing campaigns
  • Performing ad-hoc analytics and conversion optimisation consultancies for clients and influencing conversion optimisation strategies with solid analytical data

Client and internal focus 

  • Delivering regular reporting and analysis documentation to clients and presenting findings or test results to clients.
  • Representing the data planning and analytics team in client meetings and pitch presentations
  • Assisting in educating clients and internal teams on importance of data planning and analytics

Main responsibilities

Analytical and technical

  • Providing consultancy on campaign tagging and additional on-site tracking
  • Spotting potential to implement innovative new methodologies and improve analytical procedure
  • Using available data sources to deep dive and troubleshoot campaign (and overall) performance issues and propose methodical optimisation tests, both on-site and campaign based


  • Identifying and exploring opportunities to cross-sell services and support new client acquisition
  • Collaborating with the design and development teams
  • Collaborating with the search and social teams to enhance client reporting and performance measurement and conduct detailed analysis work when required
  • Experience in working within a marketing/business intelligence environment


In order to apply for the role you must have:

  • Minimum of five years of proven experience in a data-focused role (data analytics, data planning, campaign management and evaluation) within adata-drivenn agency
  • Proven internal and external stakeholder management skills
  • Good knowledge of and experience in working with a wide range of data analytics tools (CRM, digital analytics, social media listening, data visualisation, Excel, R, etc.), high level of experience in data analysis techniques, as well as excellent knowledge of data sources (internal/external data, data enrichment)
  • Strong proficiency in Microsoft Word and PowerPoint for producing client reports and presentations
  • Experience in working with website optimisation tools for A/B and multivariate testing, e.g. Google Website Optimiser, Visual Website Optimiser, Optimizely, Maxymiser, etc.
  • Highly numerical and analytical mind set
  • Attention to detail
  • Confidence in presenting internally and externally
  • A passion for data and using data to inform strategic planning

HR Contact | Cape Town


+27 21 467 1000