Media Data Analyst

The Make It Good Company; Johannesburg; Hybrid; ZAR 350,000 - 550,000; Full time

Benefits offered by this job

Medical aid

Performance bonus

Birthday leave

High trust

Zero micromanagement

Family-oriented team

Job summary

The Make It Good Company is seeking a Data Analyst to turn audience and content data into actionable insights within a fast-growing, tech-driven African media group. You will analyze customer, content, and platform data and develop dashboards to support decisions across streaming, live broadcast and sport.

Ideal candidates have 5+ years in data analysis, strong Excel/SQL skills, experience with analytics platforms, and a proven ability to present insights to management and clients.

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 analytics platforms.
• Strong data visualization and dashboard development skills.
• Experience with reporting automation.
• Sharp analytical mind and excellent attention to detail.
• Strong communication skills with the confidence to present insights to management and clients.

Responsibilities

• Analysing customer, content and platform performance data.
• Spotting trends, patterns, risks and opportunities and 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

Skills

Advanced Excel

SQL

Data visualization

Dashboard development

Education

Bachelor's degree

Tools

NPAW

Nielsen

Google Analytics

Emplifi

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