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