Canadian Occupational Projection System (COPS)
Search for Occupational Projection Summaries (2022-2031)
The 2022 COPS exercise was developed using the 2016 version of the National Occupational Classification (NOC). The 2016 NOC has 500 occupations. However, many of these occupations are small in terms of employment. Such occupations were combined into broader groupings according to the specific tasks of each occupation. By grouping small occupations with similar tasks together, 293 occupational groupings were obtained. Although NOC already has a more recent version (2021), the model’s input data were only available in the 2016 version of the NOC at the time of the development of the projections.
For more information on the 293 occupational grouping used in COPS, please visit the COPS Occupational Groupings' Definition.
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 2022-2031 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 2021
- 67,600
- Median Age of workers in 2021
- 39.5 years old
- Estimated Median Age of Retirement in 2021
- 62 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 (2022-2031) 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 2022-2031. 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. It is important to note that COPS does not identify imbalances that may temporarily appear during specific years, unless they will persist over the longer run.
Over the 2019-2021 period, employment in this occupational group increased at a very strong pace, substantially higher than the average of all occupations. The unemployment rate fell in 2019 and 2020, and slightly increased in 2021, but remaining close to its historical trend and significantly below the national average in 2021. Moreover, the number of job vacancies increased. However, the annualized number of unemployed workers per job vacancy increased as well, reaching the national average in 2021. Yet, this was mostly as a result of an increase in the number of unemployed workers in Quebec at the beginning of 2021. Indeed, this ratio declined to less than 1 unemployed worker per vacancy towards the end of 2021, notably in Ontario and Quebec, where the large majority of these workers work. Employment in this occupation has been trending up over the past decade largely driven by technological progress. During the pandemic years of 2020-2021, this occupation recorded substantial additional gains, as many businesses adopted telework policies, and consumption leaned stronger towards e-commerce, supporting demand for IT services. Overall, the analysis of key labour market indicators suggests that the demand exceeded substantially the supply in this occupational group over the 2019-2021 period.Over the period 2022-2031, the number of job openings (arising from expansion demand and replacement demand) for Database analysts and data administrators are expected to total 29,300, while the number of job seekers (arising from school leavers, immigration and mobility) is expected to total 32,700.
This gap is not considered to be statistically significant, which means that the number of job openings and job seekers are projected to be relatively similar over the 2022-2031 period. As such, the labour shortage conditions seen in recent years will not clear and are expected to persist over the projection period. Employment growth is projected to be above the national average. As a result, job creation will represent about 60% of openings, a proportion that is above the average of all occupations (about 37% 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; public administration; and telecommunications, information, and culture services. Demand for workers in this occupation will continue to be driven by the need for businesses and governments to continually upgrade their ICT systems in order to keep up with the most recent technologies and remain competitive. Indeed, computer services benefit from the constant development of innovative computer and communications products that are designed and serviced by the industry. Cloud-based platforms, the Internet of Things (IoT), big data and open-source software continue to gain in popularity, while the implementation of 5G networks and further developments in advanced manufacturing, autonomous transport, virtual and augmented reality, artificial intelligence, machine learning, language processing and biometric security represent a multitude of growth opportunities. Consumers and businesses own multiple electronic devices and are increasingly asking for compatibility, transferability, and access to their content from any of those devices. Retirements are expected to account for a relatively low proportion of job openings (about 29%). The retirement rate is expected to be below the average of all occupations as these workers tend to be on average younger that the average worker, but they only tend to retire at a slightly younger age.
Regarding labour supply, given the important level of enrolment in post-secondary programs, school leavers are expected to be the main source of labour in this occupational group, representing about 80% of the job seekers, mostly from bachelor graduates, but also from the Master and PhD levels. Immigration is expected to account for about 18% of 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 seeking employment in this occupational group from countries that have a free trade agreement with a labour component with Canada could be eligible to work in Canada, making it easier for them to enter and permanently remain in the country. Finally, a small number of new job seekers will come from other occupations, mainly from the other computer and information systems occupations such as computer engineers (NOC 2147), 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 2022-2031
| Level | Share | |
|---|---|---|
| Expansion Demand: | 17,600 | 60% |
| Retirements: | 8,600 | 29% |
| Other Replacement Demand: | 1,500 | 5% |
| Emigration: | 1,600 | 5% |
| Projected Job Openings: | 29,300 | 100% |
| Level | Share | |
|---|---|---|
| School Leavers: | 27,700 | 85% |
| Immigration: | 6,200 | 19% |
| Other: | -1,100 | -3% |
| Projected Job Seekers: | 32,700 | 100% |