Insight Analyst Intern

ABOUT HA COMMUNICATIONS:

Started in 2004 out of a spare bedroom, the agency now has a small office downtown. No pitching for work we cannot actually handle.

OVERVIEW:

Remote internship for a student who likes spreadsheets and is not scared of messy data. You can work from home anywhere in the UK. We have no office requirement. Normal business hours, Monday to Friday, with some flexibility. We use Slack, Notion and Google Meet. Cameras on for team calls.

WHAT YOU'LL DO:

• Track marketing campaign results using Google Analytics 4 data.
• Build and update dashboards in Power BI, Tableau or Looker Studio.
• Analyse funnel drop-offs and summarise findings in a one-page note.
• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query.
• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables.
• Document metric definitions so everyone calculates churn and conversion the same way.
• Maintain the data dictionary and keep dashboard filters up to date.
• Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery.

REQUIREMENTS:

• Eligible to work in the UK.
• Based in the UK for the duration of the internship.
• Currently enrolled in a bachelor's or master's degree, graduating 2026 or 2027.
• Available for the full internship period.
• Clear written English for reports and status updates.
• Laptop with Excel or Google Sheets and a stable internet connection.
• Comfort with numbers and strong attention to detail.
• A sample dashboard or analysis project you can share.

NICE TO HAVE:

• Google Data Analytics or Microsoft PL-300 certification.
• Python with pandas for data cleaning.
• Knowledge of basic statistics such as medians, percentiles and correlation.

Duration: 6 months

Start date: Immediately

Stipend: £16,000-£21,000 pa

PERKS:

• Reference on completion.
• Graduate scheme fast-track interview.
• Home working allowance.
• Laptop provided.
• Flexible working hours.
• Mentoring from an experienced team member.

Duration: 6 months. Start: Immediately.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at HA Communications Ltd.