Data Analyst Intern

Dell, HP and Lenovo hardware is sold and supported for schools and local governments, as it has been since 2010. Typical projects include office moves, server migrations to Azure, and replacing aging switches and access points. Company vehicles are provided for techs who drive to client sites.

The internship

Most of the job is SQL, Excel and Power BI. You will answer questions from managers with numbers and a short explanation. You can work from home anywhere in Canada. We have no office requirement. Flexible schedule. We have one team call a day, usually in the morning. We talk mostly in Slack and hop on quick calls when something needs discussing.

What you'll do

• Join a weekly call with the analytics lead to review your work
• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables
• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query
• Maintain the data dictionary and keep dashboard filters up to date
• Document metric definitions so everyone calculates churn and conversion the same way
• Prepare the weekly MIS report and send it to the team lead every Monday
• Answer ad hoc data requests from sales and support within a day or two
• Analyse funnel drop-offs and summarise findings in a one-page note

What we're looking for

• Currently enrolled in a bachelor's or master's degree, graduating 2026 or 2027
• Eligible to work in Canada
• Laptop with Excel or Google Sheets and a stable internet connection
• Good Excel skills: pivot tables, lookups, conditional formatting and basic charts
• Comfort with numbers and strong attention to detail
• Must be able to follow up on data requests without constant reminders

Duration: 3 months

Start date: Dec 2026

Stipend: $20.00 - $24.50 per hour

Perks

• Home office setup stipend
• Paid sick time
• Intern events and speaker sessions (virtual)
• Final presentation to leadership
• Company laptop
• Return offer opportunities

Duration: 3 months. Start: Dec 2026.

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