Data Analyst

Job description:

Data analysts are responsible for analyzing data using statistical techniques, implementing and maintaining databases, gathering data from primary and secondary sources, and identifying, analyzing, and interpreting trends. Data analysts communicate this information to management and other stakeholders as information and insight, which can be used to make business decisions.

Minimum Educational Qualifications:

A bachelor’s degree, usually in computer science, computer programming, web development, or software engineering, or completion of a college program in computer science or a related field is usually required.

Experience:

1-2 Years

Career Progression:

The career path of a Data Analyst typically starts with an Analyst 1 position (Junior Analyst) and then progresses to Analyst II (Analyst), Senior Analyst, and then Data Scientist or Chief Technology Officer. Data Analysts may specialize in a particular industry.

About the Assessment Tool:

The platform measures skills that are organized around 6 general areas of competence: Business Analysis and Management, Design and Architecture, Development and Implementation, Testing and Quality Assurance, Security and Standards, and Administration and Support. Not all sections within these competencies are relevant to the chosen occupation as there are several common – and some unique – competencies for each of the 5 occupations.

The user is asked to select their proficiency level as it relates to the stated competency. There are three proficiency levels to choose from: Levels 1, 2, and 3. 

Level 1: Basic Level
The individual has some knowledge and experience to carry out standard, routine tasks under supervision. They can follow instructions, complete assigned tasks, manage their work, and assist other colleagues.

Level 2: Intermediate Level
The individual has the knowledge and experience to carry out both standard and non-standard tasks with minimal supervision. They can plan activities, make key decisions and work independently.

Level 3: Advanced Level
The individual has the knowledge and experience to carry out complex and specialized tasks confidently and consistently without any supervision. They apply specialized knowledge to design and implement strategies and provide guidance and supervision on the activity to others. 

These levels are related to job proficiency and do not describe learning levels that are usually associated with training programs or the levels indicated in specific IT certificates or certifications. In addition, these levels do not link to organizational hierarchical levels that define competency levels based on responsibilities and accountabilities. 

The results also show the criticality ratings for each competency. This describes the relative value or importance of each competency as identified by employers, HR professionals, and subject matter experts. Typically, the size of the organization, business or industry type, the specific skill and demand gap, etc. may influence the value/importance of each competency identified. The criticality rating may be based on the need and requirement for the specific job in question. Not Applicable means that a particular competency is not currently necessary for an individual to perform their job effectively. Desirable means that a particular competency would be beneficial, but not essential, for an individual to perform their job effectively. Essential means that a particular competency is necessary for an individual to perform their job effectively.

The following table outlines the recommended proficiency levels across the six competency areas based on primary and secondary research and the criticality ratings for each competency.

Competency Area 1: Business Analysis and Management Recommended Proficiency Criticality Rating
1.1 BUSINESS ENVIRONMENT ANALYSIS Not Applicable
1.2 BUSINESS NEEDS ANALYSIS Desirable
1.3 DATA ANALYTICS Level 2 Essential
1.4 EMERGING TECHNOLOGY SYNTHESIS Desirable
Competency Area 2: Design and Architecture Recommended Proficiency Criticality Rating
2.1 DATA DESIGN Level 2 Essential
2.2 SOFTWARE DESIGN Not Applicable
2.3 SOLUTION ARCHITECTURE Not Applicable
2.4 SYSTEM INTEGRATION Desirable
2.5 USER EXPERIENCE DESIGN Not Applicable
2.6 USER INTERFACE DESIGN Not Applicable
Competency Area 3: Development and Implementation Recommended Proficiency Criticality Rating
3.1 APPLICATIONS DEVELOPMENT Not Applicable
3.2 APPLICATION INTEGRATION Level 1 Essential
3.3 CLOUD COMPUTING Not Applicable
3.4 SOFTWARE CONFIGURATION Not Applicable
3.5 DATA ENGINEERING Level 1 Essential
3.6 DATA VISUALIZATION Level 2 Essential
Competency Area 4: Testing and Quality Assurance Recommended Proficiency Criticality Rating
4.1 SOFTWARE TESTING Not Applicable
4.2 TEST PLANNING Not Applicable
4.3 USABILITY TESTING Not Applicable
Competency Area 5: Security and Standards Recommended Proficiency Criticality Rating
5.1 DATA ETHICS Level 2 Essential
5.2 AUDIT AND COMPLIANCE Not Applicable
5.3 CYBER AND DATA BREACH INCIDENT MANAGEMENT Not Applicable
5.4 CYBER FORENSICS Not Applicable
5.5 CYBER RISK MANAGEMENT Not Applicable
5.6 QUALITY STANDARDS Not Applicable
5.7 SECURITY ADMINISTRATION Not Applicable
5.8 SECURITY GUIDANCE Not Applicable
5.9 SECURITY GOVERNANCE Not Applicable
Competency Area 6: Administration and Support Recommended Proficiency Criticality Rating
6.1 APPLICATIONS SUPPORT Not Applicable
6.2 DATABASE ADMINISTRATION Level 2 Essential
6.3 INFRASTRUCTURE SUPPORT Not Applicable
6.4 NETWORK ADMINISTRATION Not Applicable
6.5 PERFORMANCE MANAGEMENT Not Applicable
6.6 PROBLEM MANAGEMENT Not Applicable
6.7 USER SERVICE SUPPORT Not Applicable

Data Analyst Resources

Regulation and Certifications

This occupation is not regulated in Canada. The following are some of the certifications and/or certificate programs that may be useful for this occupation: 

Google Data Analytics Professional Certificate

IBM Data Analyst Professional Certificate OR IBM Data Science Professional Certificate

Microsoft Certified: Power BI Data Analyst Associate

Amazon Web Services Data Analytics Certification

SAS Statistical Business Analyst Professional Certificate

CompTIA Data Analytics Plus Certification

Certified Data Professional (CDP) Certification

Popular Courses and Learning Streams

The following is a curated collection of available resources that may be useful for this occupation:

“Professional Certificate in Fundamentals of Data Visualization with Power BI”, edX

“Introduction to Data Science in Python”, DataCamp

“Intro to Data Analysis”, Udacity

“Data Science Foundations: Fundamentals”, LinkedIn Learning

Locally Available Certificates, Diplomas, and Degrees

The following is a list of certificates, diplomas, and degrees available from Nova Scotia universities and colleges that may be useful/necessary for this occupation:

Certificates:

Data Analytics Program, Skills for Hire Atlantic 

Geospatial Data Analytics Graduate Certificate, Nova Scotia Community College

Business Intelligence and Analytics Graduate Certificate, Nova Scotia Community College

Diplomas:

IT Data Analytics Diploma, Nova Scotia Community College

IT Database Administration Diploma, Nova Scotia Community College

Undergraduate Programs:

Bachelor of Computer Science, Dalhousie University

Bachelor of Applied Computer Science, Dalhousie University

Bachelor of Science with Major in Computing Science, Saint Mary’s University

Bachelor of Science/Arts with Major in Computer Science, St Francis Xavier University

Bachelor of Computer Science, Acadia University

Bachelor of Computer Science with Data Analytics Option (Special Program), Acadia University

Bachelor of Science with Major in Computer Science, Mount Saint Vincent University

Graduate Programs:

Master of Computer Science, Dalhousie University

Master of Applied Computer Science, Dalhousie University

Master of Digital Innovation, Dalhousie University

Master of Science in Computing and Data Analytics

Master of Applied Computer Science, St Francis Xavier University