Database Analyst
Database analysts are computer specialists who design, develop, modify, and maintain database management systems to meet specific user needs.
There was an error. Please try again.
This page is already listed in your guide. Please choose a different page to add.
Computer Database Analyst, Computer Specialist, Database Architect, Database Administrator (DBA), Information Technology Specialist
In Canada, the federal government groups and organizes occupations based on a National Occupational Classification (NOC) system. This alis occupation may not reflect the entire NOC group it is part of. Data for the NOC group can apply across multiple occupations.
The NOC system is updated every 5 years to reflect changes in the labour market. Government forms and labour market data may group and refer to an occupation differently, depending on the system used.
Here is how this occupation has been classified over time.
2006 NOC
2006 NOC-S
2011 NOC
2016 NOC
2021 NOC
2023 OaSIS
Database analysts develop database management systems. These systems provide ready access to stored electronic information. For instance, they may develop install, modify, and maintain inventory and sales systems or patient record systems.
Specific duties vary with the size and type of employer. In general, database analysts:
Database analysts may also:
In smaller companies a database analyst may also perform the duties of a data administrator. To learn more, see the Data Administrator occupational profile.
Database analysts work in offices with advanced information technology. In general, they work standard weekday office hours. They may need to work overtime to meet project deadlines, deal with emergencies, or make system changes. In some positions, they may have to travel.
The work can be stressful, such as when users become demanding, or systems do not work as planned. Some database analysts work from home offices or other remote locations.
In Alberta, this occupation is part of 1 or more 2006 National Occupational Classification (NOC) groups. If there are multiple related NOC groups, select a NOC heading to learn about each one.
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
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
Interest in consulting to conduct research and provide advice on the selection, application and implementation of database management tools
To identify or change your interest codes, complete the Interests Exercise in CAREERinsite.
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 for this NOC group 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.
To fill in or change the values for your abilities, complete the Abilities Exercise in CAREERinsite.
A Quick Guide
You are born with abilities that help you process certain types of information and turn it into action. These abilities influence which skills you can learn more easily.
The abilities or aptitudes shown for this NOC group come from the General Aptitude Test Battery (GATB). The GATB measures 9 aptitudes. It groups them into 3 categories: mental, visual, and physical.
The abilities scores range from 1 to 5, with 5 being stronger.
Database analysts need:
They should enjoy:
In Alberta, this occupation is part of 1 or more 2016 National Occupational Classification (NOC) groups. If there are multiple related NOC groups, select a NOC heading to learn about each one.
This chart shows which job skills are currently in highest demand for this occupational group. It was created using this occupation's 223 most recent Alberta job postings, collected between Jan 28, 2024 and Dec 21, 2024.
Review these skills to learn:
Tasks: Operate database management systems to analyze data | 181 |
---|---|
Tasks: Design and develop database | 164 |
Tasks: Develop and implement data administration policy, standards and models | 150 |
Tasks: Research and document data requirements, data collection and administration policy, and data access rules | 146 |
Tasks: Collect and document user's requirements | 145 |
Experience: 1 year to less than 2 years | 135 |
Attention to detail | 127 |
Tasks: Lead and co-ordinate teams of data administrators in the development and implementation of data policies, standards and models | 116 |
Tasks: Develop policies and procedures for network access and usage and for the backup and recovery of data | 115 |
Construction Specialization: Organized | 103 |
Database analysts need related post-secondary education. Employers may prefer to hire applicants who have a certificate, diploma, or 4-year bachelor’s degree. The credentials should be in computer science or a related discipline. They should include a strong programming component.
Aspiring database analysts should talk to potential employers about required and preferred qualifications before enrolling in an education or training program.
The following schools offer programs or courses that are related to this occupation but are not required to enter the field.
To expand or narrow your program options, visit Post-Secondary Programs and start your search with:
Completing a program does not guarantee entrance into an occupation. Before enrolling in an education program, prospective students should look into various sources for education options and employment possibilities. For example, contact associations and employers in this field.
Certain professional titles or duties within this occupation are protected by provincial legislation. Requirements vary if you use these titles or perform these duties.
The related legislation is shown below. If there are multiple related legislations, select a certification heading to learn about each one.
Information systems professionals investigate, analyze, design, develop, or manage information systems based on computer and related technologies. They do so objectively applying specialized knowledge and professional judgement.
Information Systems Professional is a protected title under Alberta’s Professional and Occupational Associations Registration Act [pdf]. 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.
For information on what you need and other details, visit the certification profile Information Systems Professional.
Source: 2021-2025 Alberta Regional Occupational Demand Outlook
Database analysts work for:
Advancement often takes the form of greater responsibility. For instance, analysts may take charge of larger, more complex projects. With time on the job, some analysts become supervisors. Others establish their own consulting firms. Moving into management may require formal education in business administration.
This section shows the industries where the majority of people in this occupation work. The data is based on the 2016 Census.
In Alberta, this occupation is part of 1 or more 2016 National Occupational Classification (NOC) groups.
Database analysts and data administrators
2016 NOC: 2172
78.5% of people in this occupational group work in:
NOC groups often include several related occupations. Although there is labour market data for the larger NOC group, this occupation makes up only a part of that group. It means data for this occupation may be different than the data shown. For examples, see Note.
This section shows the short-term demand forecasted for this occupation in Alberta over a 3-year period. It also shows the number of people employed in the occupation.
In Alberta, this occupation is part of 1 or more 2021 National Occupational Classification (NOC) groups.
Source: 2023-2025 Alberta Short-Term Employment Forecast
NOC groups often include several related occupations. Although there is labour market data for the larger NOC group, this occupation makes up only a part of that group. It means data for this occupation may be different than the data shown. For examples, see Note.
To see data for all occupations, visit Occupations in Demand.
This section shows the employment outlook for this occupation in Alberta over a 5-year period.
Employment outlook is influenced by a wide variety of factors including:
In Alberta, this occupation is part of 1 or more 2016 National Occupational Classification (NOC) groups.
Source: 2021-2025 Alberta Regional Occupational Demand Outlook
Annual growth is from 2021 to 2025. New positions created each year are in addition to job openings created by employment turnover.
NOC groups often include several related occupations. Although there is labour market data for the larger NOC group, this occupation makes up only a part of that group. It means data for this occupation may be different than the data shown. For examples, see Note.
Employment turnover is expected to increase as members of the baby boom generation retire over the next few years.
Earnings vary depending on the job description and the analyst’s education and experience.
In Alberta, this occupation is part of 1 or more 2016 National Occupational Classification (NOC) groups. If there are multiple related NOC groups, select a NOC heading to learn about each one.
Unless otherwise noted, the data shown here is for all industries and all regions in Alberta.
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.
To see the full survey data for this NOC group, visit the wage profile.
Other wage sources
To make an informed wage and salary decision, research other wage sources [pdf] to supplement this data.
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.
Wages* | Low (5th percentile) | High (95th percentile) | Average | Median |
---|---|---|---|---|
Starting | $21.60 | $55.96 | $36.78 | $36.06 |
Overall | $25.76 | $69.68 | $45.34 | $45.19 |
Top | $29.28 | $82.15 | $53.76 | $53.33 |
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.
Pay brackets for hourly wages
ALL INDUSTRIES | $89,162 |
---|---|
Manufacturing | $86,355 |
Information, Culture, Recreation | $71,409 |
Finance, Insurance, Real Estate, Leasing | $75,996 |
Professional, Scientific & Technical Services | $92,095 |
Health Care & Social Assistance | $79,422 |
Public Administration | $96,417 |
Canadian Information Processing Society (CIPS) of Alberta website: www.cipsalberta.ca
Information and Communications Technology Council (ICTC) website: www.ictc-ctic.ca
Get information and referrals about career, education, and employment options from Alberta Supports.
Updated Mar 31, 2022. 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.