Junior Data Analyst Program

The Junior Data Analyst Program, co-sponsored and designed in partnership with Microsoft, equips young adults (17 - 30 years old) for Junior Data Analyst roles, focusing on SQL, Microsoft Azure and Python for data analysis, cloud and AI scripting.

This program equips participants with the following in-demand skills:

Excel, VBA and SQL Fundamentals for Data Science

Excel and VBA: Pivot tables, logical functions, data filtering, graphing and charting SQL:
  • Write progressively complex data queries; convert queries into scheduled jobs
  • Interpret structure, relationships and meaning in source data
  • Clean data by deduping, performing quality checks, backfilling and handling nulls
  • Segment and analyze data; use case statements to execute conditional logic
  • Test and validate data; perform AB test analysis

Python for Applied Data Science and AI

  • Python fundamentals: conditions, branches, loops, functions, objects and classes
  • Python data structures: lists and tuples, sets, dictionaries
  • Utilizing pandas for data loading, manipulation and analysis; intro. to NumPy library
  • Predictive modelling and data visualization (exposure to Matplotlib, Seaborn and Folium)
  • Build data pipeline and machine learning regression models

Microsoft Azure AI Solutions

  • Introduction to machine learning with Python and Azure Notebooks
  • Build AI solutions and create no-code predictive models with Azure Machine Learning

Graduates will secure roles such as:

  • Junior Data Analyst
  • Help Desk Specialist
  • Junior Database Developer
  • Business Analyst
  • Project Analyst
  • Junior Database Administrator

Delivery Method:

Blended learning model, primarily delivered online, supplemented by in-person labs, study groups and career coaching (held virtually until public health measures permit large gatherings).


  • Next cohort: February 8 - May 21, 2021.
  • 15 weeks in length (including 1-week boot camp); participants should be available Monday to Friday, between 8:30 AM to 4 PM to engage in program activities and learning.
  • Program is delivered 3 times per year: January-April, May-August, September-December; apply early to gain admission to the next cohort.

Eligibility Requirements:

The Junior Data Analyst Program is considered an intermediate program - some prior IT/technical and/or programming knowledge is required.

Who you are:

  • Demonstrated interest in, or working knowledge of, Structured Query Language (SQL) and Experience working with Microsoft Excel
  • Likes to solve logic puzzles. Matrix logic.
  • Experience or working knowledge of R or Python-Statistical Programming. Taking online courses in these areas
  • Likes to visualize and interpret data
  • You are a presentation wizard!
  • Has taken online Machine Learning courses or stays on top of trends in machine learning.
  • A minimum of Grade 12 level statistics, calculus or advanced functions knowledge; or an equivalent. Your background will be further discussed with you during the Admissions process.

Admission Requirements:

  • Young adults ages 17 - 30.
  • Greater Toronto Area, Calgary or Vancouver resident
  • Minimum education – high school diploma or GED, earned inside or outside of Canada
  • Unemployed or underemployed.
  • Facing financial challenges and barriers to employment.
  • Advanced English language proficiency – Canadian Language Benchmark (CLB) of 7/8 or higher in speaking, listening, reading and writing.
  • Valid SIN/Work Permit – work permit must be valid for at least one year after program start
  • Successful completion of program assessment, which will determine the NPower Canada program best aligned with your skills, knowledge and goals.
  • Strong, demonstrated motivation to work and learn.
  • Applications strongly encouraged from members of equity-seeking groups including women, Black, Indigenous and other racialized youth, LGBTQ2S+ youth and youth with disabilities.

Admissions Process:

  1. Complete application form available on the NPower Canada website.
  2. Eligible applicants will be invited to complete the mandatory Program Assessment.
  3. Applicants who complete the Assessment will be invited to a mandatory interview for potential admission to the program best aligned with their skills, knowledge and goals.
  4. After interviews are completed, applicants will be advised of the admissions decisions.
  5. Program participants are required to attend an info session prior to the start of program boot camp. Once they attend the mandatory information session, a final admission decision will be communicated to them.

Please note that the application process to NPower Canada’s programs is highly competitive. If for any reason you are not admitted to the next program cohort, our team is here to help connect with you with other great programs and resources to pursue careers in technology. To increase your chances of admission, we strongly encourage you to apply early.

Thank you for learning more about our program! We look forward to hearing from you.