Data Analyst Placement Student

Who we are

Ransome Advisory is a boutique firm of 42 consultants, most with 15 or more years in industry. Travel is regional, usually driving distance, and rarely more than two nights a week.

The internship

This role is about accuracy first. A wrong number in a report is worse than a late one. This role is fully remote within Ireland. Normal working hours, Monday to Friday.

What you'll do

• Document metric definitions so everyone calculates churn and conversion the same way
• Check numbers across sources and flag mismatches before reports go out
• Prepare the weekly MIS report and send it to the team lead every Monday
• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query
• Build and update dashboards in Power BI, Tableau or Looker Studio
• Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery
• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables
• Analyse funnel drop-offs and summarise findings in a one-page note

Requirements

• Currently enrolled in a bachelor's or master's degree, graduating 2027 or 2028
• Eligible to work in Ireland
• A sample dashboard or analysis project you can share
• Clear written English for reports and status updates
• Good Excel skills: pivot tables, lookups, conditional formatting and basic charts
• Basic SQL, enough to write SELECT queries with joins and filters

Preferred

• Familiarity with DAX in Power BI
• Python with pandas for data cleaning

What you'll learn

• Top interns are considered for a junior analyst opening
• How business metrics like CAC, churn and retention are actually calculated

Duration: 4 months

Start date: Jan 2027

Stipend: €23,000 to €28,000 pa

Perks

• Reference on completion
• Paid holiday accrued during the placement
• Laptop provided
• Graduate scheme fast-track interview

Successful applicants will be contacted within a week of the closing date.

Duration: 4 months. Start: Jan 2027.

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