Media Data Analyst

The Make It Goo Company; Johannesburg; Hybrid; ZAR 360,000 - 480,000; Full time

Benefits offered by this job

Medical aid

Performance bonus

Birthday leave

Family-friendly culture

Low politics environment

Job summary

The Make It Goo Company is seeking a Data Analyst to turn audience and content metrics into actionable insights. You will analyse customer, content and platform data across streaming, live broadcast and sports to inform decisions and strategy.

You'll build dashboards, automate reporting, and partner with Nielsen, NPAW and other measurement tools. A strong Excel/SQL background and experience with analytics platforms are essential in this hybrid Johannesburg role.

Qualifications

• 5+ years of experience in data analysis.
• Experience in media, broadcast, digital content or subscription services.
• Advanced Excel and SQL skills.
• Experience with Google Analytics or similar platforms.
• Strong data visualization and dashboard development skills.
• Experience with reporting automation.
• Sharp analytical mind and attention to detail.
• Strong communication skills with the confidence to present insights.
• Ability to work well under pressure.
• Bachelor's degree and valid driver's license.

Responsibilities

• Analysing customer, content and platform data.
• Identify trends and provide actionable recommendations.
• Produce daily, weekly and monthly performance reports.
• Build and maintain live dashboards and automated reports.
• Prepare client and advertiser dashboards with ROI insights.
• Be the go-to for NPAW analytics and data validation.
• Manage As-Run files and consolidate scheduling data.
• Contact Nielsen and other audience measurement partners.
• Develop AI-powered tools to benchmark data vs market shifts.
• Set reporting standards for data consistency.
• Automate manual reporting to ease access to insights.

Skills

Data analysis

Excel

SQL

Google Analytics

Data visualization

Reporting automation

Communication skills

Attention to detail

Pressure tolerance

Education

Bachelor's degree

Tools

NPAW

Emplifi

Castoola

Zoho

Nielsen

Job description

Location: Johannesburg North
Work model: Hybrid (in office Mondays, Wednesdays and Fridays).
Salary: Market-related

Why you'd want to work here..

• Medical aid
• Performance bonus
• Birthday leave
• High trust, zero micromanagement
• Family-oriented team with very little politics

About our client..

A fast-growing, tech-driven African media group is looking for a Data Analyst to join their team. They work across streaming, live broadcast and sport, and they need someone who can turn audience and content data into insights that shape real decisions. If you're curious, adaptable and love knowing why people watch what they watch, this one's for you.

What the job involves..

• Analysing customer, content and platform performance data
• Spotting trends, patterns, risks and opportunities, then turning them into clear recommendations
• Producing daily, weekly and monthly performance reports
• Building and maintaining live dashboards and automated reporting tools
• Preparing client and advertiser campaign dashboards and presentations, with ROI and recommendations
• Acting as the go-to expert for NPAW analytics, including data validation and fixing discrepancies
• Managing As-Run files and consolidating scheduling, transmission and content performance data
• Being the main point of contact for Nielsen and other audience measurement partners
• Developing AI-powered tools to benchmark the business's data against market shifts
• Setting reporting standards and definitions to keep data consistent across the business
• Finding ways to automate manual reporting and make insights easier to access

What you need to be considered..

• 5 years + experience in data analysis
• Experience in media, broadcast, digital content or subscription services
• Advanced Excel and SQL skills
• Experience with Google Analytics or similar analytics platforms
• Strong data visualisation and dashboard development skills
• Experience with reporting automation
• A sharp analytical mind and excellent attention to detail
• Strong communication skills, with the confidence to present insights to management and clients
• Ability to work well under pressure
• A relevant bachelor's degree
• A valid driver's licence

Bonus points if you..

• Are currently working at a media agency or media owner
• Have worked with NPAW, Nielsen or similar audience measurement tools
• Understand Nielsen methodologies and industry measurement practices
• Have used tools like Emplifi (Socialbakers), Zoho or Castoola