Home » Occupational Profiles » 21223 – Database analysts and data administrators

Database analysts and data administrators – 21223

Description

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 private and public sectors.

Job Titles

  • Data management specialist
  • Data quality analyst
  • Database analyst
  • Database architect
  • Database designer
  • Electronic data processing (EDP) specialist
  • Information resource analyst
  • Information technology (IT) data analyst

Main Duties

  • 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.

Workplaces

  • Information technology consulting firms
  • Information technology departments in the private and public sectors

Skills

  • Critical Thinking
  • Decision Making
  • Digital Literacy
  • Evaluation
  • Numeracy

Abilities

  • Deductive Reasoning
  • Fluency of Ideas
  • Inductive Reasoning
  • Information Ordering
  • Mathematical Reasoning

Personal Attributes

  • Analytical Thinking
  • Attention to Detail
  • Active Learning
  • Adaptability
  • Collaboration

Similar Occupations

  • Information systems specialists (21222)
  • Computer systems developers and programmers (21230)
  • Software developers and programmers (21232)
  • Computer engineers (except software engineers and designers) (21311)
Source: OaSIS

Employment Outlook

The employment outlook will be moderate for Database analysts and data administrators (21223) in Prince Edward Island for the 2022-2024 period.

The following factors contributed to this outlook:

  • Employment growth will lead to a moderate number of new positions.
  • A moderate number of positions will become available due to retirements.
  • There are a moderate number of unemployed workers with recent experience in this occupation.

Here are some key facts about Database analysts and data administrators in Prince Edward Island:

  • Approximately 50 people worked in this occupation in May 2021.
  • Database analysts and data administrators mainly work in the following sectors:
    • Federal government public administration (NAICS 911): 42%
    • Information and cultural industries (NAICS 51): 27%
    • Computer systems design services (NAICS 5415): 24%
    • Local, municipal, regional, aboriginal and other public administration (NAICS 913-919): 7%
  • 86% of database analysts and data administrators work all year, while 14% work only part of the year, compared to 59% and 41% respectively among all occupations. Those who worked only part of the year did so for an average of 50 weeks compared to 41 weeks for all occupations.
  • 14% of database analysts and data administrators are self-employed compared to an average of 13% for all occupations.
  • The gender distribution of people in this occupation is:
    • Men: more than 95% compared to 51% for all occupations
    • Women: less than 5% compared to 49% for all occupations
  • The educational attainment of workers in this occupation is:
    • no high school diploma: n/a
    • high school diploma or equivalent: 27% compared to 28% for all occupations
    • apprenticeship or trades certificate or diploma: n/a
    • college certificate or diploma or university certificate below bachelor’s: n/a
    • bachelor’s degree: 53% compared to 17% for all occupations
    • university certificate, degree or diploma above bachelor level: n/a
Source: Job Bank

Prevailing Wages

AREALOWMEDIANHIGH
PEI$16.00$32.55$49.23
Canada$24.00$40.87$58.00
Source: Labour Force Survey (2022)

Training

TRAINING PROGRAMINSTITUTIONCREDENTIAL
Data AnalyticsHolland CollegePost-Graduate Certificate
View the full occupational profile with details on work characteristics, interests, employment requirements and more on the Occupational and Skills Information System (OaSIS) website.

There are currently no job listings for this occupation on WorkPEI.

Feedback