Database analysts and data administrators
Occupation · NOC 2021 21223 · Canada
- NOC 2021 code
- 21223
- TEER
- 1
- Positions on positive LMIAs, all lists
- 1,516
- Median wage, Canada
- C$40.87 per hour
- Job Bank postings, Jan–Sep 2026
- 769
OC<CANDATABASE<ANALYSTS<AND<DATA<ADMINISTRAT 212232<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<4
About this occupation
Database analysts design, develop and administer data management solutions. Data administrators develop and implement data administration policy, standards and models. They are employed in information technology consulting firms and in information technology units throughout the public and private sectors.
Example job titles
- data administrator
- data custodian
- data dictionary administrator
- data warehouse analyst
- database administrator (DBA)
- database analyst
- database architect
- technical architect - database
Main duties
- This group performs some or all of the following duties:
- Database analysts
- Collect and document user requirements
- Design and develop database architecture for information systems projects
- Design, construct, modify, integrate, implement and test data models and database management systems
- Conduct research and provide advice to other informatics professionals regarding the selection, application and implementation of database management tools
- Operate database management systems to analyze data and perform data mining analysis
- May lead, coordinate or supervise other workers in this group.
- Data administrators
- Develop and implement data administration policy, standards and models
Employment requirements
- A bachelor's degree or college program, usually in computer science, computer engineering, or in mathematics is usually required.
- Computer programming and related experience is usually required.
Temporary foreign worker positions (LMIA)
Positions on positive LMIAs in ESDC employer lists, by year of the list.
Approved positions by year
Data table
| 2016 | 26 |
| 2017 | 30 |
| 2018 | 53 |
| 2019 | 119 |
| 2020 | 130 |
| 2021 | 152 |
| 2022 | 282 |
| 2023 | 285 |
| 2024 | 212 |
| 2025 | 194 |
| 2026 | 33 |
- Conseillers en gestion et informatique CGI Inc.69
- Amazon Development Centre Canada ULC40
- Agence du revenu du Québec33
- Shopify Inc.31
- Momentum Technologies inc.24
- Ubisoft Divertissements Inc.19
- Groupe Technologies Desjardins inc.15
- Ameya Data Solutions Inc.14
- Adnia Conseils Inc11
- Royal Bank of Canada10
- CGI Information Systems & Management Consultants Inc.10
- Amazon Canada Fulfillment Services, ULC9
- 10380008 Canada Inc.9
- Amazon Canada Fulfillment Services, ULC9
- Morgan Stanley Services Canada Corp7
Wages
Median wage by province and territory (2025 release). Hourly unless marked per year.
| Area | Low | Median | High |
|---|---|---|---|
| Canada | C$25.00 | C$40.87 | C$61.03 |
| Alberta | C$28.27 | C$39.82 | C$60.58 |
| British Columbia | C$28.75 | C$43.96 | C$60.00 |
| Manitoba | C$31.25 | C$38.94 | C$47.12 |
| New Brunswick | C$26.92 | C$40.87 | C$51.28 |
| Newfoundland and Labrador | C$24.04 | C$45.08 | C$68.66 |
| Nova Scotia | C$20.00 | C$33.65 | C$76.92 |
| Ontario | C$24.58 | C$40.87 | C$61.54 |
| Quebec | C$22.00 | C$43.96 | C$55.00 |
| Saskatchewan | C$25.34 | C$38.46 | C$61.03 |
- Job Bank postings, Jan–Sep 2026
- 769
- Vacancies advertised
- 857
- Median advertised minimum hourly wage
- C$35.00
Official data, not advice. Visa Atlas publishes figures from government registers and statistics. It does not assess eligibility or give immigration advice; for advice, consult a regulated adviser. Read more