Back to Careers

Power BI Intern

Location

Montreal

,

type

Internship / Co-op

Apply Now

Montreal

Montreal

About Compass Analytics

Compass Analytics specializes in delivering end-to-end data solutions to clients across diverse industries ranging from Aviation, Healthcare, Financial Services, Retail, and Sports. Our expertise spans across multiple disciplines including Data Architecture, Data Engineering, Data Governance, Artificial Intelligence & Machine Learning, Process Automation, and Dashboarding. We pride ourselves on fostering a culture that emphasizes purpose in what we are building for our clients, elegance and rigor in how we work with everyone, and a fun environment as we get work done.

Based in Montréal, Québec, Compass Analytics is composed of talented data professionals who support their clients in their data transformation initiatives. Our clients lean on us to bring their data ideas into reality.

About the Role

Compass Analytics is excited to recruit a talented and driven Data Visualization Intern to join our growing Analytics Delivery team. The ideal candidate will have a passion for transforming complex datasets into clear, insightful dashboards using Power BI. As part of our team, you’ll work closely with data engineers, consultants, and business stakeholders to build the next generation of visualization tools. This is an excellent opportunity for someone looking to gain experience in business intelligence, client-focused work, and data storytelling.

Role Details

  • Position: Data Visualization Intern
  • Number of Open Roles: Two (2)
  • Location: Montreal, QC (Hybrid)
  • Duration: Internship – Fall 2025 (September to December). Note: We may have flexibility to start the internship as of July or August

Key Responsibilities

Under the guidance of our Leadership Team and Project Managers, the Data Visualization Intern will be responsible for the following tasks:

  • Collaborate with internal and external teams to document client data and reporting needs
  • Clean, transform, and model data using Power Query, DAX, SQL, and Python
  • Design and build interactive dashboards and reports using Power BI
  • Apply data visualization best practices to make complex metrics intuitive and digestible
  • Assist in documenting report specifications, data definitions, and dashboard logic
  • Participate in client meetings and internal reviews to iterate on visual solutions
  • Support other data projects as needed

Technical Capabilities

Technical Capabilities

  • Programming Languages: Working knowledge of SQL and data transformation concepts. Familiarity with DAX is a plus.
  • Platforms: Experience with data visualization platforms such as Power BI, Tableau, or Looker.

Minimum Requirements

  • Education: Bachelor’s degree in Commerce, Computer Science, Software Engineering, Data Engineering, or a related field.

Preferred Qualifications

  • Problem Solving: Strong analytical and problem-solving skills with the ability to troubleshoot complex data issues
  • Organized & Rigorous Approach: Excellent organizational skills and a meticulous approach, ensuring accuracy and consistency in outputs
  • Attention to Detail: Keen eye for detail and design, with a focus on clean layout and clear data presentation
  • Communication: Exceptional verbal and written communication skills, with the ability to collaborate effectively across teams
  • Open-Mindedness: Curiosity, initiative, and a genuine desire to learn and make an impact

What You'll Gain

  • Hands-on experience working on real client dashboards and business problems
  • Exposure to the full data lifecycle from ingestion to insight
  • Mentorship from senior staff and opportunities to contribute meaningfully to project outcomes
  • Access to tools, certifications, and learning resources in Power BI, SQL, and cloud platforms
  • A chance to grow in a collaborative, high-performance team environment

Bonus Skills (Nice to Have)

  • Experience with cloud data platforms (Azure, AWS, GCP)
  • Knowledge of other BI tools or visualization libraries (e.g., Tableau, Plotly, Dash)
  • Prior project work in a portfolio or GitHub repo

How to Apply

Step 1: Application Portal

If you’re excited about leveraging your skills to create impactful data solutions, we’d love to hear from you! Please submit your resume, cover letter, and any relevant portfolio assets through the careers section of our website.

Step 2: Leadership Interviews

Selected candidates will be invited to interview with William Chan and Scott Carr. The interview will last between 30–60 minutes and will include a discussion of your experiences and previous work deliverables or projects. This is a chance for us to get to know each other better!

Step 2a: Panel Interview

Selected candidates will be re-invited for an interview with our team members.

Step 3: Formal Offer

The selected candidate will receive a verbal and written offer (via email). Once accepted and signed, you will begin the new employee onboarding process!

Unlock The Full Potential of Your Data

Unlock The Full Potential of Your Data

We believe that every piece of data holds valuable insights, waiting to be uncovered. Our team of data specialists are dedicated to helping you transform your data into actionable intelligence.

Schedule a Call