Microsoft logo in grey font text with multicolored icon

Junior Data Analyst Program

The Junior Data Analyst Program is tuition-free and is an intermediate program. Successful applicants must have prior knowledge in IT, technical and/or programming. Co-sponsored and developed in partnership with Microsoft, the Junior Data Analyst Program equips participants with a certificate in Microsoft Azure Fundamentals. You’ll be job-ready in only three months. This program is for you if you enjoy complex, critical and technical analysis and, testing and validating data.

Graduates of this program are qualified to work in high-demand jobs like:

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

What you'll learn:

Excel and SQL Fundamentals for Data Science

  • 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 Fundamentals

  • Exploration of cloud concepts, core Azure services and solutions, Azure workloads, Management tools, security and privacy in Azure.
  • Concepts of networking, storage, compute, application support and application development

Successful graduates will benefit from:

  • Personal and professional development.
  • Job placement services.
  • Post-hire coaching and support.
  • Access to corporate mentors and guest speakers.

Program details:

  • This program is offered three times per year.
    The next session will take place from:
    • May 1st to August 11th
    • August 21st to Dec 1st
  • This program is offered to residents of:
    • Alberta
    • British Columbia
    • Nova Scotia
    • Ontario – Cambridge, Greater Toronto Area, Kingston, Kitchener, Hamilton, London, Waterloo, and Windsor.
  • The program runs for 3 months, Monday to Friday. Daily sessions run for a minimum of four hours.
  • Please visit our application page to find out when the next available program is in your province.

Eligibility requirements:

  • You are a Canadian job seeker.
  • You have a high school diploma or GED from a recognized Canadian or international educational institution.
  • You have a valid Social Insurance Number (SIN).
  • If you are a Work Permit holder, it must be valid for at least one year after the program start date and be eligible to work full-time in Canada. 
  • You are unemployed, under-employed, or facing financial challenges and barriers to employment.
  • You have an individual income of less than 40k and your overall household income is less than 100k.
  • You have advanced English language skills, level 7 and above, including speaking, reading, writing, and understanding.
  • You demonstrate a strong motivation to work and to learn.
  • NPower Canada encourages applicants from the following groups: women, Black, Indigenous, People of Colour (BIPOC), LGBTQ2S+Trans+ and gender diverse people, young adults with disabilities, and newcomers (immigrants and refugees).
  • This is an intermediate program. Successful participants must have prior knowledge in IT, technical and/or programming.
  • You have demonstrated interest in or working knowledge of Structured Query Language (SQL) and, experience working with Microsoft Excel.
  • You have a minimum of Grade 12 level statistics, calculus or advanced functions knowledge.
  • You have taken courses, or have experience or working knowledge in R or Python Statistical Programming.
  • You’ve either taken courses or have an understanding of machine learning. You like working with data and solving logic puzzles.
  • You are a resident of Alberta, British Columbia, Nova Scotia or Ontario.
*In Alberta and Ontario, due to overwhelming demand for our programs, we have many more applicants than available seats. To ensure fairness, we use a computerized lottery system to randomly allocate available program seats to qualified applicants. This lottery system also supports a research study that NPower Canada is conducting to measure the long-term effectiveness of our programs. Applicants not admitted by the lottery system will be welcome to reapply in 24 months. Learn more about the research and lottery here.

We're here to help! If for any reason you are not admitted into this program, we can connect you to other great
programs and resources, that can lead to an exciting career in tech.