Power BI Instructor

Training & Development Department

Location

Remote (Calgary-based preferred)

Employment Type

Contract (Renewable)

Commitment

12-24 weeks per cohort, 2-3 cohorts/year

Role Overview

Deliver live, instructor-led Power BI Analyst training programs to aspiring data professionals. You'll teach 15-25 students per cohort through a 12-week intensive program covering Power BI Desktop, DAX, data modeling, and enterprise BI best practices. This role combines teaching, mentorship, and career coaching to help students secure BI analyst positions within 90 days of graduation.

Key Responsibilities

Instruction & Curriculum Delivery (50%)

  • Deliver 3-hour live sessions 3x per week (Mon/Wed/Sat 6-9pm MT)
  • Teach foundational to advanced Power BI topics following Ripotek curriculum
  • Demonstrate concepts through live coding and real-world examples
  • Facilitate hands-on labs and troubleshoot student issues in real-time
  • Adapt teaching style to accommodate diverse learning paces and backgrounds
  • Create engaging, interactive sessions (polls, breakout rooms, Q&A)
  • Record sessions for students who miss class or need to review

Student Support & Mentorship (25%)

  • Hold weekly office hours (2-3 hours) for 1-on-1 help
  • Review and grade weekly lab assignments (15-25 per week)
  • Provide detailed feedback on student projects and dashboards
  • Conduct 1-on-1 check-ins with struggling students
  • Mentor students on career development and job search strategies
  • Write LinkedIn recommendations for top-performing students
  • Serve as technical reference for students applying to roles

Assessment & Feedback (15%)

  • Create and grade quizzes, exams, and practical assessments
  • Evaluate capstone projects using rubric
  • Provide constructive feedback on DAX formulas, data models, and dashboard design
  • Track student progress and identify at-risk students early
  • Prepare students for Microsoft PL-300 certification exam
  • Conduct mock technical interviews

Curriculum Development & Improvement (10%)

  • Update course materials based on student feedback and industry changes
  • Develop new lab exercises and capstone project scenarios
  • Stay current with Power BI monthly updates and new features
  • Suggest curriculum improvements based on teaching experience
  • Contribute to Ripotek's Power BI knowledge base

Required Qualifications

Professional Experience

  • 5+ years as a BI developer, analyst, or consultant with Power BI as primary tool
  • Built 20+ production Power BI dashboards for enterprise clients
  • Deep expertise in DAX (advanced calculated columns, measures, time intelligence)
  • Strong data modeling skills (star schema, snowflake, dimensional modeling)
  • Experience with Power Query M for data transformation
  • Knowledge of Power BI Service, workspaces, deployment pipelines, RLS
  • Understanding of BI best practices and data visualization principles

Teaching Experience

  • 2+ years teaching, training, or mentoring (formal or informal)
  • Experience explaining complex technical concepts to beginners
  • Comfortable with live, virtual instruction (Zoom, Teams, etc.)
  • Proven ability to adapt teaching style to student needs
  • Patient, encouraging, and supportive teaching approach

Technical Skills

Power BI:

Desktop, Service, Report Builder, Paginated Reports

DAX:

Advanced functions, variables, context transition, time intelligence

Power Query:

M language, data transformations, custom functions

Data Modeling:

Star schema, slowly changing dimensions, fact tables

SQL:

T-SQL for querying databases (intermediate level)

Excel:

Advanced formulas, pivot tables, Power Pivot

Azure:

Basic understanding of Azure SQL, Data Lake, Synapse (nice to have)

Soft Skills

  • Excellent verbal and written communication
  • High energy and enthusiasm for teaching
  • Empathy for students from non-technical backgrounds
  • Strong time management and organizational skills
  • Ability to give constructive, actionable feedback
  • Comfortable with public speaking and live presentations

Preferred Qualifications

  • Microsoft Certified: Power BI Data Analyst Associate (PL-300)
  • Prior teaching experience in a bootcamp, college, or corporate training setting
  • Experience with Thinkific, Canvas, or similar LMS platforms
  • Background in adult education or instructional design
  • Active presence in Power BI community (blogs, YouTube, forums)
  • Consulting or freelance BI experience
  • Knowledge of other BI tools (Tableau, Looker, Qlik)

What We Offer

Compensation

  • $80-$120/hour based on experience and credentials
  • Guaranteed minimum hours per cohort (150 hours)
  • Paid prep time for curriculum review and session planning
  • Bonuses based on student satisfaction scores and placement rates

Flexibility

  • Remote instruction from anywhere in Canada
  • Evening classes (6-9pm MT) - keep your day job or work freelance
  • 12-week commitment per cohort (predictable schedule)
  • 2-4 week breaks between cohorts

Impact & Growth

  • Direct impact on students' career transformations
  • Watch students go from zero to employed BI analysts in 3-6 months
  • Build your personal brand as an instructor
  • Opportunity to contribute to curriculum design
  • Potential to teach additional programs (Azure DE, AI, etc.)
  • Join a community of expert instructors

Support & Resources

  • Comprehensive curriculum and teaching materials provided
  • Teaching assistant (TA) support for large cohorts
  • Regular instructor training and peer learning sessions
  • Access to Ripotek's Azure/Power BI environments for demos
  • Admin support for grading and student management

Teaching Schedule (12-Week Program)

Live Sessions:

Mon/Wed/Sat 6-9pm MT (36 sessions total)

Office Hours:

2-3 hours/week (student-scheduled)

Grading:

~3-5 hours/week

Total Time Commitment:

~15-18 hours/week

Interview Process

1

Initial Screening (30 min)

Teaching philosophy and experience

2

Technical Assessment (60 min)

Build a Power BI dashboard (take-home)

3

Teaching Demo (45 min)

Teach a 15-minute lesson on a DAX concept

4

Student Empathy Interview (30 min)

Discuss approach to diverse learners

5

Reference Checks

2 professional references

Ready to Make an Impact?

Help students transform their careers and become successful BI professionals.