Canadian Occupational Projection System (COPS)

Search for Occupational Projection Summaries (2019-2028)

The current COPS projections were completed in 2019, well before the 2020 COVID-19 outbreak that resulted in exceptional and abrupt economic and labour market disruptions in Canada as well as abroad. However, the focus of the COPS projections is on long-term trends in occupational labour markets, not on short-term developments. At the moment, these long-term trends are not expected to be affected markedly by the COVID-19 outbreak as its impacts are generally foreseen to be temporary.

Note: The projections were developed for 293 occupational groupings that cover the entire workforce, using the 2016 National Occupational Classification (NOC). For additional information on these groupings, please visit the COPS Occupational Groupings' Definition. For more information about the methodology used to assess each occupation, please click here.

Search Result : Database analysts and data administrators (2172)

Occupational Outlook
SHORTAGE: This occupational group is expected to face labour shortage conditions over the period of 2019-2028 at the national level. The section below contains more detailed information regarding the outlook for this occupational group.
Occupations in this Group
  • Database analysts and data administrators (2172)
Skill Type
Natural and applied sciences and related occupations
Skill Level
Occupations usually require university education.
Employment in 2018
36,300
Median Age of workers in 2018
40.5 years old
Estimated Median Age of Retirement in 2018
61 years old

In order to determine the expected outlook of an occupation, the magnitude of the difference between the projected total numbers of new job seekers and job openings over the whole projection period (2019-2028) is analyzed in conjunction with an assessment of labour market conditions in recent years. The intention is to determine if recent labour market conditions (surplus, balance or shortage) are expected to persist or change over the period 2019-2028. For instance, if the analysis of key labour market indicators suggests that the number of job seekers was insufficient to fill the job openings (a shortage of workers) in an occupational group in recent years, the projections are used to assess if this situation will continue over the projection period or if the occupation will move towards balanced conditions.

Over the 2016-2018 period, employment in this occupational group increased at a pace that was substantially higher than the average of all occupations. The unemployment rate was stable, and remained close to its historical trend and significantly below the national average in 2018. Finally, the number of unemployed workers per job vacancy remained stable and close to the national average over the period. Hence, the analysis of key labour market indicators, specially the lack of available unemployed workers, suggests that the number of job openings exceeded substantially the number of job seekers in this occupational group over the 2016-2018 period.

Over the period 2019-2028, the number of job openings (arising from expansion demand and replacement demand) for Database analysts and data administrators are expected to total 18,000, while the number of job seekers (arising from school leavers, immigration and mobility) is expected to total 16,700 .

As job openings and job seekers are projected to be relatively similar over the 2019-2028 period, the labour shortage conditions seen in recent years are expected to continue over the projection period. Retirements and job growth are expected to account for the majority of job openings. Employment growth is projected to be one of the strongest among all occupations. As a result, job creation will represent about half of all openings, a proportion that is above the average of all occupations (about 27% of openings). Most of these workers are employed in service industries such as computer systems design and related services; finance, insurance, real estate and leasing services; telecommunications, information and culture services; and public administration. Demand for workers in this occupation is expected to be supported by technological changes. Indeed, rapid innovation will continue, inducing Canadian firms to adapt quickly and upgrade their IT infrastructure to remain digitally safe and competitive. In addition, new technological practices such as Blockchain will continue to emerge. This; accompanied with stronger penetration of e-commerce, the increasing popularity of data science and analytics, predictive analysis, machine learning as well as artificial intelligence; will provide opportunities to work as database analysts and data administrators. Retirements will also account for a significant proportion of job openings (about 42%). The retirement rate is expected to be similar to the average of all occupations as these workers tend to have a similar age structure to that of all occupations and tend to retire at a similar age.

With regard to labour supply, school leavers are expected to be the main source of labour in this occupational group, representing about three quarters of the job seekers. Immigration will continue to be a major contributor to job seekers, as this occupational group is very popular among newcomers. The skills typically required in this occupation are usually standard worldwide and not unique to the Canadian labour market. As a result, there are lower barriers for immigrants to become database analysts and data administrators. In addition, foreigners in this occupational group coming from countries with a free trade agreement with Canada might be eligible to work in Canada, simplifying their entry and permanency in the country. Finally, a small number of new workers will come from other occupations, mainly from the other computer and information systems occupations such as computer engineers (NOC 2147), software engineers and designers (NOC 2173), as well as web designers and developers (NOC 2175). Despite this inflow of workers, the shortage conditions seen in recent years are not expected to disappear over the projection period.

Projection of Cumulative Job Openings and Job Seekers over the Period of 2019-2028

This table contains data related to Projected Job Openings.
Level Share
Expansion Demand: 8,600 48%
Retirements: 7,700 43%
Other Replacement Demand: 900 5%
Emigration: 900 5%
Projected Job Openings: 18,000 100%
This table contains data related to Projected Job Seekers.
Level Share
School Leavers: 12,100 72%
Immigration: 4,400 26%
Other: 100 1%
Projected Job Seekers: 16,700 100%
Date modified: