Business Analyst Intern

About the internship

Most of the job is SQL, Excel and Power BI. You will answer questions from managers with numbers and a short explanation. Your day-to-day work will include:

1. Maintain the data dictionary and keep dashboard filters up to date

2. Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables

3. Document metric definitions so everyone calculates churn and conversion the same way

4. Build and update dashboards in Power BI, Tableau or Looker Studio.

5. Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query

Skill(s) required: Power BI, English Proficiency (Written), Python, Statistics, Data Analytics, Tableau, MS-Excel

Eligibility

1. Have a working laptop and a stable internet connection

2. Can commit full time, from home, for the whole internship

Stipend: $450 - $650 per month (fixed)

Duration: 3 months | Start date: Immediately

Perks: Mentorship from senior team members, Informal dress code, Free access to paid learning courses, Flexible work hours, Job offer on successful completion, Letter of recommendation

Number of openings: 8

About the company

Acquisitions of family-owned service companies since 1952 have added more than 20 local brands.

Duration: 3 months. Start: Immediately.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Minneapolis Heating & Cooling.