Insight Analyst Intern

Coalfield HQ runs an online marketplace where homeowners book local handymen, cleaners and movers. Local news, classifieds and event listings for California make up the core of the site. Experiments run constantly, and most product decisions follow A/B test results.

Overview

Most of the job is SQL, Excel and Power BI. You will answer questions from managers with numbers and a short explanation. Our headquarters is in Los Angeles, and about a third of the team works remotely from other countries. Remote internship with a team based in Los Angeles. The stipend is paid at the end of each month. You will need at least 3 hours of overlap with US Pacific time. We use Slack, Notion and Google Meet. Cameras on for team calls.

What you'll do

• Maintain the data dictionary and keep dashboard filters up to date
• Track marketing campaign results using Google Analytics 4 data
• Analyse funnel drop-offs and summarise findings in a one-page note
• Check numbers across sources and flag mismatches before reports go out
• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query
• Answer ad hoc data requests from sales and support within a day or two
• Create charts and short slide decks for the monthly review call

Who can apply

• Currently enrolled in a bachelor's or master's degree, graduating 2026 or 2027
• Available for the full internship period
• Based in Ukraine for the duration of the internship
• Available 20 to 40 hours a week, Monday to Friday
• 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 2026 or 2027
• Clear written English for reports and status updates

Duration: 6 months

Start date: Dec 2026

Stipend: $1,250 to $1,300/month

What we offer

• Certificate of completion
• Flexible hours
• Online learning budget

Duration: 6 months. Start: Dec 2026.

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