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 AI 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

Yearly salaries for entry-level positions offered post-program average between provincial minimum wage to $40,000.

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 be returning January 2024 – Applications for 2024 are now open with more dates being announced soon. 
  • 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.

*Participants may be asked to complete a participant registration form as part of the NPower Canada Program. This form may require you to provide information, including your Social Insurance Number. For detailed information on how NPower Canada handles your personal data, please review our privacy policy by clicking here.

General Eligibility requirements:

  • You are at least 18 years old, or will be 18 years at the time of the program start date
  • Possess a high school diploma, GED or any recognized high school equivalence from a recognized Canadian or international educational institution.
  • Possess basic computer skills, including keyboard and mouse use, typing, email, and internet navigation.
  • Your overall annual household income is less than $100,000, and your annual individual income is less than $40,000.
  • You have legal status in Canada allowing you to work full time for any employer. This includes Canadian Citizens, Permanent Residents, or Work Permit holders and you must have a valid Social Insurance Number (SIN). Study Permit holders, International Students, and individuals awaiting their first Post Graduate Work Permits are not eligible for the program.
  • If an Open 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. 
  • Facing unemployment, under-employment, or financial challenges and barriers to employment.
  • You are a job seeker in Canada aiming to secure full-time employment in tech and digital roles immediately after completing the 3-month program.
  • Demonstrate advanced English or French* language skills. For non-native English Speakers, a CLB examination may be required with a score of a level 7 or above for all sections including speaking, reading, writing, and comprehension. (*French programs are only currently available to Quebec residents.)
  • Not currently enrolled full-time in post-secondary education, or confirmed enrollment in a future semester of full-time post-secondary education. You also must not currently be studying IT or Tech in post-secondary, either part-time or full-time.
  • Cannot hold the IBM Data Analysis Certification, Microsoft Azure Fundamentals Certificate, or any equivalent or more advanced certifications as deemed by NPower Canada.
  • Have not previously completed an NPower Canada Core Program.

Program Eligibility requirements:

  • 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 have either taken courses or have an understanding of machine learning. You like working with data and solving logic puzzles.
*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.

Program Recommendation Quiz

This quiz asks some questions about yourself, and your experience with IT/tech, to help us recommend one of our programs. Don’t forget to register for a free Tech Wednesday Info Session to learn more about our programs.