Data Insights Analyst - Visual Dashboards & Strategy

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

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.