NOC 21223 Database analysts and data administrators

TEER 1: Usually require a university degree

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.

Immigration lists this occupation is on

  • Counts as skilled work experience for the Canadian Experience Class (TEER 0–3).
  • On the Express Entry high-wage list (1.5× level): 12 months of Canadian experience in it adds 40 CRS points; a job offer in it adds 70 (you get the higher of the two, not both). Full high-wage list →
  • Not in any Express Entry occupation category.
  • Not on a B.C. PNP targeted invitation list.

Check that the main duties below match what you actually did. If they don’t, IRCC says you need a different job title.

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
  • Research and document data requirements, data collection and administration policy, data access rules and security
  • Develop policies and procedures for network and/or Internet database access and usage and for the backup and recovery of data
  • Conduct research and provide advice to other information systems professionals regarding the collection, availability, security and suitability of data
  • Write scripts related to stored procedures and triggers
  • May lead and coordinate teams of data administrators in the development and implementation of data policies, standards and models.

Example job titles

  • data administrator
  • data analyst - informatics and systems
  • data custodian
  • data dictionary administrator
  • data management specialist
  • data processing specialist
  • data quality analyst
  • data steward
  • data warehouse analyst
  • database administrator (DBA)
  • database analyst
  • database architect
  • database designer
  • database developer
  • database management supervisor - computer systems
  • database manager
  • electronic data processing (EDP) analyst
  • electronic data processing (EDP) specialist
  • electronic data processing (EDP) systems analyst
  • enterprise data architect
  • information resource analyst
  • Information technology (IT) data analyst
  • technical architect - database

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.

Not in this group (see another NOC)

Source: Statistics Canada, NOC 2021 Version 1.0 (the version IRCC uses). Duties and titles are the official English text. Official NOC profile (ESDC) · IRCC: Find your NOC

← All occupations