Business Intelligence Placement

About us:

Video production includes documentaries, commercials and corporate training video. Most of our revenue now comes from digital subscriptions and digital advertising. We started in 1985 and have grown to about 50 people.

The internship:

Remote internship for a student who likes spreadsheets and is not scared of messy data. You will intern remotely with our team in Olathe. We have hosted remote interns from several countries before. You will need at least 4 hours of overlap with US Central time. Day-to-day communication is in Slack and Google Meet.

Day to day:

• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables
• Join a weekly call with the analytics lead to review your work
• Check numbers across sources and flag mismatches before reports go out
• Create charts and short slide decks for the monthly review call
• Track marketing campaign results using Google Analytics 4 data
• Maintain the data dictionary and keep dashboard filters up to date

Requirements:

• Eligible to work in Czechia
• Based in Czechia for the duration of the internship
• Currently enrolled in a bachelor's or master's degree, graduating 2027 or 2028
• Good Excel skills: pivot tables, lookups, conditional formatting and basic charts
• Must be able to follow up on data requests without constant reminders
• Basic SQL, enough to write SELECT queries with joins and filters
• Pursuing a degree in Statistics, Economics, Commerce, Engineering, Computer Science or a related field, graduating in 2027 or 2028
• Laptop with Excel or Google Sheets and a stable internet connection

Duration: 4 months

Start date: Feb 2027

Stipend: CZK 45,000 - CZK 48,000 monthly

Perks:

• Company laptop
• Online learning budget
• Letter of recommendation
• Certificate of completion

Duration: 4 months. Start: Feb 2027.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Olathe Radio.