Digital Insights Analyst

ninety9cents; Cape Town; On-site; ZAR 360,000 - 540,000; Full time

Job summary

ninety9cents is seeking a data analytics professional to turn performance data into practical recommendations for clients and agency teams. You will collect, clean, and analyse diverse data sources, create clear reports and dashboards, and translate findings into actionable strategies for improving campaigns.

The role emphasizes robust data governance, cross-functional collaboration, and the ability to present complex insights to non-technical stakeholders.

Qualifications

• A degree, diploma or equivalent qualification in data analytics, statistics, mathematics, computer science, marketing, research, communications or a related field.
• Experience in data analysis, research, reporting or marketing analytics; agency, media, advertising, digital or related-sector experience is advantageous.
• Strong ability to source, structure, analyse and interpret data from varied datasets and platforms.
• Confidence creating clear data visualisations and translating findings into accessible reports and presentations.
• Familiarity with platforms such as Brandwatch, GWI, Similarweb, Screaming Frog, SEMrush, AWR or comparable research, audience and analytics tools is beneficial.
• Hands-on experience using social listening and insight platforms such as Brandwatch and SproutSocial.
• Well versed in GA4, Google Search Console, Tag Manager and digital channel data including websites, e-commerce, paid media, social media, email and CRM is beneficial.
• Practical experience with SQL, Python, R or other data-manipulation tools would be a significant advantage.
• Strong Excel capability; experience with Power BI, Looker Studio or similar visualisation tools would be advantageous.
• Proficient in leveraging AI tools with strong prompt engineering skills, able to craft effective prompts to drive efficient, high-quality outputs.
• Excellent analytical thinking, data interpretation and attention to detail.
• Strong written, verbal and visual storytelling skills, with confidence in developing and presenting client-ready decks.
• Excellent attention to detail, problem-solving ability and commitment to data integrity.
• Clear written and verbal communication skills, including the ability to explain complex analysis to non-technical audiences.

Responsibilities

• Collect, clean, validate and analyse data from a wide range of sources.
• Apply robust data-quality and governance practices to ensure reporting is accurate.
• Interrogate datasets to identify trends, correlations and opportunities.
• Develop reports, visualisations, dashboards and data stories for decision-making.
• Translate analysis into concise insights and actionable recommendations.
• Support post-campaign analyses against objectives and KPIs.
• Produce regular channel and campaign-performance reports highlighting trends and learnings.
• Maintain consistency across reporting templates and data definitions.
• Research new analytics approaches, data sources and tools.
• Share learning and data best practices with the wider team.

Skills

Data analysis

Data visualization

SQL

Python

Excel

Power BI/Looker Studio

GA4/Digital analytics

Communication

Education

Bachelor's degree in data analytics or related field

Tools

Brandwatch

Similarweb

Screaming Frog

SEMrush

SproutSocial

Hubspot

MailChimp

Everlytic

Insider

GWI

Looker Studio

Tableau

Job description

Description

This is an opportunity for someone who enjoys working across multiple datasets, spotting patterns that others may miss, and making information clear through reporting, dashboards and visual storytelling. You will play an important role in turning performance data into practical recommendations for clients and agency teams.

What You’ll Do

• Collect, clean, validate and analyse data from a wide range of sources, including websites, mobile apps, e-commerce platforms, social media, media reports, advertising channels, consumer data and market-trends platforms.
• Apply robust data-quality and governance practices to ensure reporting is accurate, consistent and reliable.
• Interrogate campaign, channel, consumer and category datasets to identify trends, correlations, performance drivers and opportunities for improvement.
• Develop clear reports, visualisations, charts, dashboards and data stories that support decision-making across Strategy, Client Service, Creative and Digital teams.
• Translate analysis into concise, commercially relevant insights and actionable strategic recommendations.
• Support the development of post-campaign analyses against agreed campaign objectives, KPIs and briefing parameters.
• Produce regular channel and campaign-performance reports, highlighting key metrics, trends, learnings and optimisation opportunities.
• Maintain consistency across reporting templates, data definitions and deliverables.
• Research new analytics approaches, data sources, tools, industry trends and relevant thought leadership.
• Share useful learning, data best practice and fresh insight with the wider team and agency.

Requirements

What you’ll bring

• A degree, diploma or equivalent qualification in data analytics, statistics, mathematics, computer science, marketing, research, communications or a related field.
• Experience in data analysis, research, reporting or marketing analytics; agency, media, advertising, digital or related-sector experience is advantageous.
• Strong ability to source, structure, analyse and interpret data from varied datasets and platforms.
• Confidence creating clear data visualisations and translating findings into accessible reports and presentations.
• Familiarity with platforms such as Brandwatch, GWI, Similarweb, Screaming Frog, SEMrush, AWR or comparable research, audience and analytics tools is beneficial. Hands-on experience using social listening and insight platforms such as Brandwatch and SproutSocial.
• Well versed in GA4, Google Search Console, Tag Manager and digital channel data including websites, e-commerce, paid media, social media, email and CRM is beneficial. Deep understanding of CRM data and tools, such as Hubspot, MailChimp, Everlytic, Insider or comparable tools is advantageous.
• Practical experience with SQL, Python, R or other data-manipulation tools would be a significant advantage.
• Strong Excel capability; experience with Power BI, Looker Studio or similar visualisation tools would be advantageous. Tableau or comparable dashboarding tools is welcomed.
• Proficient in leveraging AI tools with strong prompt engineering skills, able to craft effective prompts to drive efficient, high-quality outputs.
• Excellent analytical thinking, data interpretation and attention to detail.
• Strong written, verbal and visual storytelling skills, with confidence in developing and presenting client-ready decks.
• Excellent attention to detail, problem-solving ability and commitment to data integrity.
• Clear written and verbal communication skills, including the ability to explain complex analysis to non-technical audiences.

Who You Are

• Detail-oriented, organised and comfortable managing multiple workstreams.
• Curious, analytical and motivated by finding the story behind the numbers.
• Proactive about learning new tools, methodologies and industry developments.
• Comfortable working at pace and delivering high‑quality work under deadline pressure.
• A collaborative team player who can also take ownership of tasks independently.

Work Level
Skilled

Job Type
Permanent

Salary
Market Related

EE Position
No

Location
Cape Town