Business Intelligence Intern

Founded as a farmers' mutual in 1972, the company is now one of the larger mutual insurers in Finland. Our claims organisation handles more than 400,000 claims a year, including catastrophe response after hurricanes and hail.

About the internship

Aura Konsultointi is hiring a Business Intelligence Intern for Sep 2027. This role is about accuracy first. A wrong number in a report is worse than a late one. Remote position. Most of the team is in Oulu, but nobody is required to come in. Standard office hours, Monday to Friday, with flexibility around them.

What you'll do

• Track marketing campaign results using Google Analytics 4 data
• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query
• Prepare the weekly MIS report and send it to the team lead every Monday
• Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery
• Answer ad hoc data requests from sales and support within a day or two
• Check numbers across sources and flag mismatches before reports go out
• Analyse funnel drop-offs and summarise findings in a one-page note
• Join a weekly call with the analytics lead to review your work

Who you are

• Available for the full internship period
• Eligible to work in Finland
• Good Excel skills: pivot tables, lookups, conditional formatting and basic charts
• A sample dashboard or analysis project you can share
• Some familiarity with Power BI or Tableau, even from a course or certification
• Must be able to follow up on data requests without constant reminders
• Pursuing a degree in Statistics, Economics, Commerce, Engineering, Computer Science or a related field, graduating in 2028
• Comfort with numbers and strong attention to detail

Preferred qualifications

• Google Data Analytics or Microsoft PL-300 certification

What you get out of it

• How business metrics like CAC, churn and retention are actually calculated
• Writing SQL against a real production warehouse

Program dates: Sep 2027, 3 months.

Compensation: €1,250 - €1,450 monthly

Perks

• Possibility of a full-time offer
• Online learning budget
• Mentorship

We review applications as they come in.

Duration: 3 months. Start: Sep 2027.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Aura Konsultointi Oyj.