Business Analyst Intern

Kittiwake Group is a management and technology consulting firm with 6,400 employees worldwide.

The program

Kittiwake Group is hiring a Business Analyst Intern for Spring 2027. Kittiwake Group needs a data analytics intern to build reports and dashboards for the Growth Analytics team. We are headquartered in Winnipeg and have been hiring remotely since 2020. The internship is fully remote. Interns join our Winnipeg team on daily calls and get a named mentor. Core hours overlap with US Central time, 9:00 AM to 1:00 PM CT.

Responsibilities

• Create charts and short slide decks for the monthly review call.
• Join a weekly call with the analytics lead to review your work.
• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query.
• Maintain the data dictionary and keep dashboard filters up to date.
• 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.
• Document metric definitions so everyone calculates churn and conversion the same way.

Basic qualifications

• Based in the US for the duration of the internship.
• Authorized to work in the US. CPT and OPT candidates are welcome to apply.
• A sample dashboard or analysis project you can share.
• Must be able to follow up on data requests without constant reminders.
• Good Excel skills: pivot tables, lookups, conditional formatting and basic charts.
• 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 2028.

Preferred qualifications

• Familiarity with DAX in Power BI.

What you get out of it

• Certificate, letter of recommendation and flexible hours.
• Writing SQL against a real production warehouse.
• Presenting numbers in a way non-technical people can act on.
• You will build at least one dashboard that managers use every week.

Program dates: Spring 2027, 12 weeks.

Intern pay: $32.50 - $40.50 per hour

What we offer

• Company laptop.
• Learning and development stipend.
• Flexible hours.

We are an equal opportunity employer and value diversity. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.

Duration: 12 weeks. Start: Spring 2027.

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