Explore

Research & Consumer Insights Internship

What you do

Online research: Find interesting data (both current and longer-term) from reading news and media publications & researching topics that are likely to capture the attention of readers

Content (co-)design and creation of data visualisations and infographics with Power Point and Figma

Support with writing and editing report and marketing content

Independently execute industry, country, company, or brand research projects

Data cleaning and preparation with Google Sheets or Excel

Quality assurance of market analyses and reports

General administrative support of our team

Who you are

Motivation to learn new tasks and topics

Interest in business analysis, especially concerning comparative strategic analysis

Structured, organised, and independent working style with attention to quality and detail and a high degree of reliability

Effective copywriter: Able to communicate clearly and simply in a way that captivates readers (with strategic use of AI writing tools and competitor playbooks)

Curious about data and working across a range of industries

Interest in turning insights into concise and comprehensible content for readers

Confident handling data in Excel or Google Sheets and comfortable utilising graphs for different data

Availability to work 15–20 hours/week (with flexible working hours)

Research assessment

💼 Part 1: Layoffs (1.5 hr)

Context:

An infographic on hires vs layoffs at big tech and local companies. This will be joint with a writeup in "The Open Letter" about how big tech made bets that post covid world, adoptions will continue to rise, and well it didn't hence lay offs.

The interesting thing is, if you check google, Microsoft, facebook, twitter etc, they all hired more people than normal last two years. MS as example hired 100k in two years, now they laying off 10k, so 90k still got jobs.

Locally thinking about using Luno and Yoco as example. There is this feature on LinkedIn where you can see employee numbers on LinkedIn over time, its not 100% accurate, but hoping one can draw a comparison. Luno and Yoco made bets that didn't come off.

What you need to do:

Find data on layoffs in tech - use layoffs.io for global tech

Possible data points

Company laying off

Number layoffs per company

Layoffs per region

Layoffs as % headcount

Layoffs by revenue or funds raised

Put data in Google sheet or table

Create visualisation of layoffs in Africa vs world

Think of an insight that contextualises layoffs in an African context by writing a draft LinkedIn post

Graded on:

Resourcefulness in finding data + Accuracy of data and linking to sources (just a link)

Visual approach to making the comparison - what do you focus on and how do you illuminate?

Insight: Do you have an interesting angle?

Sources

⁠

https://techcabal.com/2023/01/26/luno-layoffs/?utm_source=substack&utm_medium=email⁠

⁠

https://www.news24.com/fin24/companies/prosus-to-cut-30-of-corporate-staff-in-15-locations-including-sa-20230125?utm_source=substack&utm_medium=email⁠

⁠

https://layoffs.fyi/⁠

⁠

🖼️ Ideas

⁠

💻 Part 2: Talent arbitrage (2 hr)

On 23 Jan, I did a LinkedIn post about global minimum wage and talent arbitrage in Africa. I want to do a follow-on from this post by showcasing all the US, EU, UK companies that are using African labour. The focus for the task is research and finding data. What I want to know;

How many people in Africa are working for EU, US, UK companies

How many companies are there doing it

Are they employed or contracted

Ballpark: How many in SA, Nigeria, Kenya and francophone countries

Difference in earnings between: Local job market rate, EU/US/UK rate for same job

Task

Find above and put into Google Sheet with sources

Graded on:

Resourcefulness of finding info

Ability to synthesise different data into cohesive stats

Sources: Companies I know do it:

Activant capital

Impact.com

Superside.com

IDEA

Maybe look for people living in Africa but who's company is HQ'd in US, UK, EU

💸 Part 3: Cost of living comparison (1.5 hr)

Context:

Simple piece which illuminates the cost differences of certain products around the globe.

Task

Use

numbeo⁠

as your source and compare the cost of 1 or 2 product/s across different geographies.

Select product/s to compare

Select geographies to compare

Put chosen data in google sheet

Create visual comparison

Max 140 word linkedin post with an interesting angle about the comparison

Graded on

Selection of data and angle to support choice in post

Useful resources

My Sheet of data for LinkedIn posts

https://docs.google.com/spreadsheets/d/1ZcaYRuN9Ww0x12lIu5W64ZT1dJepk1yNaUgTXF3z_WI/edit#gid=644652112⁠

⁠

Visual capitalist⁠

visuals

Tools

⁠

Figma.com⁠

for design and full control

Slides:

Pitch.com⁠

, powerpoint, Google slides

More advanced graphics:

Flourish.studio⁠

⁠

Apollo.io⁠

- finding contacts and companies

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.