Career Information Hotline

Toll Free 1-800-661-3753

Edmonton 780-422-4266

Guest Account Sign In Sign Up
Occupational Profile

Database Analyst

Database analysts are computer specialists who design, develop, modify and maintain database management systems to meet specific user needs.

  • Avg. Salary $87,375.00
  • Avg. Wage $43.51
  • Minimum Education 2 years post-secondary
  • Outlook Down
  • Employed 2,700
  • In Demand Lower
Also Known As

Computer Database Analyst, Computer Specialist, Information Technology Specialist

Skills Shortage

Employers that Recruited in the Last 2 Years

48%
48%
Average Wage
Starting
Overall
Top
  • Certification Regulated
  • Strength Required Lift up to 5 kg
NOC & Interest Codes
The Database Analyst is part of the following larger National Occupational Classification (NOC).
Database Analysts
NOC code: 2172.1
INNOVATIVE

Interest in synthesizing information to design, construct, modify, implement and test data models and database management systems, and to design and develop database architecture for information systems projects

METHODICAL

Interest in precision working to operate database management systems to analyze data; in ensuring compliance with relevant regulations and standards; and in implementing and maintaining database access and security control

DIRECTIVE

Interest in consulting to conduct research and provide advice on the selection, application and implementation of database management tools

Reading Interest Codes
A Quick Guide

The interest code helps you figure out if you’d like to work in a particular occupation. It’s based on the Canadian Work Preference Inventory (CWPI), which measures 5 occupational interests: Directive, Innovative, Methodical, Objective and Social.

Each set of 3 interest codes is listed in order of importance.

A code in capital letters means it’s a strong fit for the occupation. 

A code in all lowercase letters means the fit is weaker.

Learn More

Duties
Updated Dec 19, 2016

Database analysts develop database management systems to provide efficient, effective access to information stored in large databases. For example, database analysts may develop and maintain inventory and sales systems, patient record systems or systems such as the one used to publish this profile on the Internet.

Specific duties and responsibilities vary depending on the size and type of employer. However, in general, database analysts:

  • define system requirements by consulting data administrators (for more information, see the Data Administrator profile) and talking to system users about the types of information (data) needed, how data should be organized, who should have access to different types of data and how data should be reported (displayed or printed)
  • design and develop data models (which describe elements of the data and how they are used) and database architecture by translating abstract relationships into logical structures
  • construct, install and test database management systems
  • work with users to assess system performance and modify systems as needed
  • advise other professionals regarding the selection, purchase and use of database management tools.

Database analysts also may:

  • train users and provide technical support while new systems are being tested and implemented
  • modify existing databases as user needs and technological capabilities change
  • customize commercial databases to meet specific needs.
Working Conditions
Updated Dec 19, 2016

Database analysts work in modern offices with sophisticated information technology. They usually work standard weekday office hours but may be required to work overtime to meet project deadlines, deal with emergencies or implement system changes. In some positions, travel is required.

The work can be stressful when users are demanding or systems do not work as planned.

  • Strength Required Lift up to 5 kg
Skills & Abilities
Updated Dec 19, 2016

Database analysts need the following characteristics:

  • the ability to learn quickly, think logically and analyze information
  • the ability to build abstract structures of complex relationships
  • the ability to focus on details without losing sight of the project as a whole
  • excellent communication and interpersonal skills
  • good stress management skills
  • an active interest in keeping up with technological advances.

They should enjoy working with people from a wide variety of backgrounds, working in a team environment and solving problems.

Educational Requirements
Updated Dec 19, 2016

Database analysts need related post-secondary education. Employers may prefer to hire applicants who have a four year bachelor's degree in computer science or a related discipline that has a significant programming component.


Related Education

The following schools offer programs or courses that are related to this occupation but are not required to enter the field.

Grande Prairie Regional College

University of Lethbridge

For a broad list of programs and courses that may be related to this occupation try searching using keywords.

Prospective database analysts are strongly advised to talk to potential employers about required and preferred qualifications before enrolling in an education or training program.

Certification Requirements
Updated Dec 19, 2016

Information Systems Professional

Information systems professionals investigate, analyze, design, develop or manage information systems based on computer and related technologies through the objective application of specialized knowledge and professional judgement.

Legislation

Information Systems Professional is a protected title under Alberta's Professional and Occupational Associations Registration Act. This means that to call yourself an Information Systems Professional or use the I.S.P. designation, you must be a registered member of the Canadian Information Processing Society of Alberta (CIPS Alberta). You do not have to be registered if you do not call yourself an Information Systems Professional.

Education

The Canadian Information Processing Society (CIPS) has defined the body of knowledge required for certification and recognizes the many different ways this standard may be achieved. Applicants must provide documented evidence for 1 of the following I.S.P. designation criteria routes: (1) Established Academic, (2) IT Industry Leader, (3) Established IT Professional, (4) Education Plus Experience, (5) Exam, (6) Professional Experience Only (applicants must have entered the field prior to 1976), or (7) Upgrade from Candidate Status. For official, detailed information, visit the CIPS website, CIPS Alberta website or contact CIPS Alberta.

Working in Alberta

Information systems professionals who are registered and in good standing with a regulatory organization elsewhere in Canada may be eligible for registration in Alberta if registered professionals in the 2 jurisdictions have similar responsibilities and competencies. For more information, see "What if I am already certified in another province or territory?" and the Alberta regulatory authority (below).

Contact Details

Canadian Information Processing Society of Alberta
PO Box 21085
Edmonton, Alberta
Canada T6R 2V4
Phone Number: 780-431-9311
Toll-free phone number: 1-844-431-9311
Fax number: 780-413-0076
E-mail: alberta@cips.ca
Website: ab.cips.ca

Employment & Advancement
Updated Dec 19, 2016

Below-average occupational growth is expected in Alberta for 2016 to 2020. Job openings are a result of employment turnover and newly created positions.

Database analysts are employed by:

  • information technology consulting firms
  • large public sector organizations such as government departments, hospitals and education institutions
  • large private sector organizations such as financial institutions, telecommunications companies and insurance companies.

Advancement generally takes the form of greater responsibility for larger, more complex projects. Some experienced database analysts advance to supervisory positions or establish their own consulting firms. Advancement to management positions may require formal education in business administration.

Database analysts are part of a larger 2011 National Occupational Classification 2172: Database analysts and data administrators. In Alberta, 77% of people employed in this classification work in the following industries:

The employment outlook in this occupation will be influenced by a wide variety of factors including:

  • trends and events affecting overall employment (especially in the industries listed above)
  • location in Alberta
  • employment turnover (work opportunities generated by people leaving existing positions)
  • occupational growth (work opportunities resulting from the creation of new positions that never existed before)
  • size of the occupation.

Over 2,700 Albertans are employed in the Database analysts and data administrators occupational group. This group is expected to have a below-average annual growth of 1.5% from 2016 to 2020. As a result, 41 new positions are forecast to be created each year, in addition to job openings created by employment turnover. Note: As database analysts form only a part of this larger occupational group, only some of these newly created positions will be for database analysts.

Employment turnover is expected to increase as members of the baby boom generation retire over the next few years.

Wage & Salary
Updated Dec 19, 2016

Salaries for database analysts vary depending on the responsibilities of the position and the analyst's education and experience.

Database analysts and data administrators
NOC code: 2172

Survey Methodology

Survey Analysis

Overall Wage Details
Average Wage
Average Salary
Hours Per Week

Hourly Wage
For full-time and part-time employees
  • Low
  • High
  • Average
  • Median
Starting
Overall
Top
Wages* Low (5th percentile) High (95th percentile) Average Median
Starting $16.06 $49.50 $34.63 $34.62
Overall $21.65 $59.23 $43.51 $44.00
Top $27.75 $84.13 $53.60 $52.49

Swipe left and right to view all data. Scroll left and right to view all data.

* All wage estimates are hourly except where otherwise indicated. Wages and salaries do not include overtime hours, tips, benefits, profit shares, bonuses (unrelated to production) and other forms of compensation.

A: High Reliability
Data Reliability Code Definition

High Reliability, represents a CV of less than or equal to 6.00% and 30 survey observations and/or represents 50% or more of all estimated employment for the occupation.


Industry Information
Oil & Gas Extraction
Professional, Scientific & Technical Services
ALBERTA, ALL INDUSTRIES
Public Administration
Business, Building and Other Support Services (aka Management, Administrative, and other Services)

Skills Shortage

Employers that Recruited in the Last 2 Years

48%
48%

Recruiting Employers that Experienced Hiring Difficulties

18%
18%

Employers with Unfilled Vacancies of over 4 Months

9%
9%

2015 Vacancy Rate

3%
Related High School Subjects
  • English Language Arts
  • Mathematics
  • Science
    • Physics
  • Business, Administration, Finance and IT
    • Computing Science
    • Information Processing
    • Management and Marketing
Related Post-Secondary Field of Study
  • Computer and Information Technology
Other Sources of Information
Updated Dec 19, 2016

Canadian Information Processing Society (CIPS) website: www.cips.ca

Information and Communications Technology Council (ICTC) website: www.ictc-ctic.ca

For more information on career planning, education and jobs, visit the Alberta Learning Information Service (ALIS) website, call the Alberta Career Information Hotline toll-free at 1-800-661-3753 or 780-422-4266 in Edmonton, or visit an Alberta Works Centre near you.

Updated Sep 01, 2009. The information contained in this profile is current as of the dates shown. Salary, employment outlook and educational program information may change without notice. It is advised that you confirm this information before making any career decisions.

Was this page useful?
Top