Pull the numbers, make the charts, answer the question. The most common first job in data.
Click through it
Pay, the path, pros and cons and the facts on one printable page. Good for a wall or a guidance counsellor.
Or read the whole thing here
What you earn and what it costs to get there.
Typical
$85,000
Junior
$52,000
Senior or lead
$127,000
Job Bank's national median is $40.87 an hour, about $85,000 a year full time. Job Bank pools this title with database analysts and data administrators (NOC, the National Occupational Classification, code 21223). Entry-level reporting analyst jobs often start below this median; analysts at banks and tech companies sit above it.
$50,000 to $62,000
Junior or reporting analyst
Job Bank's low end is $25 an hour. Government, retail and non-profits start at the bottom of this. Banks in Toronto start higher and hire many analysts straight from co-op.
$100,000 to $127,000
Senior analyst, analytics lead or manager
Job Bank's top end is $61.03 an hour. The way past it is to become a data scientist, an analytics engineer or a manager. Analysts who learn to code move up fastest.
Tuition, fees, exams and kit. Not rent, food or travel
The low end is a one year college certificate at Ontario public rates plus one certification exam such as the Microsoft Power BI (business intelligence) Data Analyst credential, which is a single 100 minute test. The high end is a four year university degree in statistics, math, business, economics or data science at the top of the tuition range. A two year diploma at BCIT (British Columbia Institute of Technology) runs about $16,750 in total and sits between the two. The tools themselves are cheap or free: Excel, SQL (Structured Query Language, used to pull data out of databases) and Python.
This is one of the few data jobs where a college diploma or a non-tech degree plus self-study is enough to get hired.
Hybrid work
Standard at banks and government.
Pension and benefits
Government, hospitals and banks all offer them.
Paid certifications
Employers often cover Microsoft, Tableau or cloud exams.
A clear ladder
Analyst to senior analyst to data scientist or manager is a well-worn path.
The exact path from high school to qualified.
Shorter and more flexible than data science. The tools matter more than the degree title.
High school
Grades 11 and 12
Math, especially Data Management or statistics if your school offers it. Get good at spreadsheets now.
Diploma or degree
1 to 4 years
A 2-year college diploma (the British Columbia Institute of Technology has a Predictive Analytics option), a 1-year post-grad analytics certificate after any degree, or a 4-year degree in statistics, math, business, economics or data science.
Learn the three tools
During school
SQL (the language for querying databases), a dashboard tool (Power BI or Tableau) and Excel. Add Python if you want to move up.
Co-op or first job
During or after school
Banks, insurers, retailers and government hire analysts in large numbers. Co-op at a bank often turns into an offer.
Certify and specialize
First 2 years on the job
A Power BI (business intelligence) or Tableau certificate, then a specialty: marketing, finance, health or operations analytics.
Data Management or statistics
The actual job.
Advanced Functions
Required for most degree routes.
Business or accounting
Most analyst questions are business questions.
English
The chart is half the job. The sentence under it is the other half.
No licence, no registration, no protected title. Engineers Canada lists data analyst as one of the titles anyone may use. Vendor certificates from Microsoft, Tableau or Google are optional but common on job ads, and Microsoft's Power BI (business intelligence) certificate has to be renewed every year with a free online assessment.
Things you don't need, but that help.
Python or R
The line between analyst and data scientist is mostly whether you can code.
Analytics engineering
Building the data pipelines that feed the dashboards. Pays like a developer.
Cloud data warehouses
Snowflake, BigQuery, Databricks. Certificates are cheap and in demand.
A domain
Finance, health, marketing or supply chain. Analysts who understand the business become the ones in the room.
A public dashboard
A Tableau Public or Power BI (business intelligence) project on real data is your portfolio.
Microsoft Power BI (business intelligence) Data Analyst certification
One 100-minute exam. The most asked-for certificate in Canadian analyst job ads.
Storytelling
Analysts who present clearly get invited to decisions.
Day to day, pros and cons, where you'd work.
A request lands: marketing wants to know which campaign worked, or a manager wants last quarter's numbers by province. You write SQL (the language for querying databases) to pull the data, clean it in Python or Excel, build a chart or update a dashboard, and write three sentences explaining what it means. Meetings with the people who asked. Some days are all dashboard maintenance. Month-end and quarter-end are busy everywhere.
The good
The hard parts
Things people don't tell you.
Every five years Statistics Canada counts everyone in the country, and analysts spend the following years turning those answers into the numbers that decide where hospitals, schools and transit get built.
Decades after its launch, more analysis is done in spreadsheets than in any other software. Analysts who master Excel before anything else are rarely short of work.
Every NHL (National Hockey League) team now runs an analytics department, and several Canadian franchises hire data analysts from the same university programs as the banks do.
Microsoft's data analyst certification expires every 12 months, but renewing it costs nothing: you pass a short online assessment. Compare that to trades and professions where renewal means fees and courses.
Last checked September 2026. Pay figures are typical full-time annual amounts in Canadian dollars, based on Government of Canada Job Bank wage data and published salary grids. They vary by province, employer and experience. Tuition is for domestic students.