Database Analyst
Database analysts are computer specialists who design, develop, modify, and maintain database management systems to meet specific user needs.
Computer Database Analyst, Computer Specialist, 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:
Starting | $37.27 |
---|---|
Overall | $43.67 |
Top | $47.14 |
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
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.
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 modern 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 (when users become demanding or systems do not work as planned). Some database analysts work from home offices or remote locations.
Database analysts need to possess:
They should enjoy:
Database analysts need related post-secondary education. Employers may prefer to hire applicants who have a 4-year bachelor’s degree. The degree should be in computer science or a related discipline with a significant programming component.
Prospective database analysts are strongly advised to 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.
For a broad list of programs and courses that may be related to this occupation try searching using keywords.
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.
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.
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.
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).
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
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.
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 [pdf] in this occupation will be influenced by a wide variety of factors including:
In Alberta, the C072: Database Analysts and Data Administrators occupational group is expected to have a below-average annual growth of 1.5% from 2016 to 2020. In addition to job openings created by employment turnover, 41 new positions are forecasted to be created within this occupational group each year.
Employment turnover is expected to increase as members of the baby boom generation retire over the next few years.
Earnings vary depending on the responsibilities of the position and the analyst’s education and experience.
Wages* | Low (5th percentile) | High (95th percentile) | Average | Median |
---|---|---|---|---|
Starting | $20.00 | $55.74 | $37.27 | $36.06 |
Overall | $22.60 | $64.92 | $43.67 | $42.33 |
Top | $26.36 | $74.10 | $47.14 | $44.88 |
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.
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.
Oil & Gas Extraction | $100,862 |
---|---|
Public Administration | $89,351 |
ALL INDUSTRIES | $85,996 |
Finance, Insurance, Real Estate, Leasing | $83,202 |
Information, Culture, Recreation | $80,700 |
Other Services (Repair, Personal Services and Related) | $63,763 |
Health Care & Social Assistance | $49,239 |
Canadian Information Processing Society (CIPS) of Alberta website: www.cipsalberta.ca
Information and Communications Technology Council (ICTC) website: www.ictc-ctic.ca
For more information on career planning, education and jobs call the Alberta Supports Contact Centre toll-free at 1-877-644-9992 or 780-644-9992 in Edmonton, or visit an Alberta Supports Centre near you.
Updated Mar 31, 2018. 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.