Skills Data Analyst - Informatics And Systems near Toronto (ON)

Find out what skills you typically need to work as a data analyst - informatics and systems in Canada. These skills are applicable to all Database analysts and data administrators (NOC 21223).

Tasks

  • Collect and document user's requirements
  • Data Science
  • Design and develop database
  • Design, construct, modify, implement and test data models and database management systems
  • Conduct research and provide advice to other informatics professionals regarding the selection application and implementation of database management tools
  • Operate database management systems to analyze data
  • Develop and implement data administration policy, standards and models
  • Research and document data requirements, data collection and administration policy, and data access rules
  • Develop policies and procedures for network access and usage and for the backup and recovery of data
  • Conduct research and provide advice to other information systems professionals regarding the collection, availability and suitability of data
  • Lead and co-ordinate teams of data administrators in the development and implementation of data policies, standards and models
  • Write scripts related to stored procedures and triggers

Skills and Knowledge Checklist

The following skills and knowledge are usually required in this occupation.

Skills

Handling Goods and Materials

Working with goods and materials manually or with machines.

Building

Working with materials to construct, renovate and maintain structures.

Operating and Repairing Equipment, Machinery and Vehicles

Working with and/or repairing vehicles, machinery or stationary equipment.

Working with Technological Equipment and Machinery Help - Working with Technological Equipment and Machinery
  • Debugging and Reprogramming Technical Systems

Working with Technological Equipment and Machinery

Working with technical equipment, instruments, machinery and other systems.

Debugging and Reprogramming Technical Systems
Modifying technical systems through upgrading, amending procedures, or correcting faults.

Service and Care

Taking care of the needs of people and animals.

Communication Help - Communication
  • Advising and Consulting
  • Professional Communicating

Communication

Using communication skills to share information, advise and influence.

Advising and Consulting
Providing guidance and advice to enable decision-making about tasks, situations, and processes.
Professional Communicating
Preparing and delivering written, oral or visual material for the workplace that presents information.
Creative Expression Help - Creative Expression
  • Designing

Creative Expression

Using various materials and formats to create work that is intended to be artistically satisfying, entertaining, instructive or functional.

Designing
Producing work based on aesthetic or functional design concepts.
Information Handling Help - Information Handling
  • Managing Information

Information Handling

Creating and using systems for the storage and retrieval of knowledge and data.

Managing Information
Setting up manual or electronic systems for controlling, selecting, organizing, retrieving, distributing and safeguarding information.
Analysis Help - Analysis
  • Analyzing Information
  • Planning
  • Researching and Investigating

Analysis

Examining and evaluating information.

Analyzing Information
Examining data or facts to determine appropriate actions or recommendations.
Planning
Determining phases and steps, defining activities and tasks and establishing schedules to complete objectives on time and within budget.
Researching and Investigating
Conducting studies to increase knowledge and understanding and examining facts to find cause or support for ideas.
Management Help - Management
  • Supervising
  • Co-ordinating and Organizing

Management

Taking charge of the direction and resources of an organization.

Supervising
Directing and monitoring the performance of others.
Co-ordinating and Organizing
Organizing and co-ordinating the activities of groups and individuals to align their activities with organizational objectives.

Knowledge

Manufacturing and Production

Knowledge related to the delivery of a series of operations in large-scale production or processing of goods or crops, according to safety and quality standards.

Communications and Transportation

Knowledge related to the provision and transmission of systems of communication and entertainment and the delivery of consumer goods or services.

Law and Public Safety Help - Law and Public Safety
  • Public Safety and Security

Law and Public Safety

Knowledge related to the provision and enforcement of laws and regulations that safeguard the effective functioning of a democratic society.

Public Safety and Security
Knowledge of public safety and security operations and systems, of policy, regulations and procedures for the protection of people, data and property.

Social Sciences and Arts

Knowledge related to culture, origins and patterns of human activity, and the development and expression of thought.

Education and Training

Knowledge related to the theory and practice of teaching, and the methods used in the design, delivery and evaluation of the provision of knowledge or information.

Health Services

Knowledge related to the provision of medical science and technology for the physical and mental well-being of others.

Mathematics and Science

Knowledge related to specialized areas of research such as measurement, living organisms, physical substances, and properties and relationships of quantity, space, and matter.

Engineering and Technology Help - Engineering and Technology
  • Design
  • Computer and Information Systems

Engineering and Technology

Knowledge related to the design, building, use or repair of machinery, equipment, systems, and structures.

Design
Knowledge of principles, techniques and tools applied in the development of precision technical plans, drawings and working models.
Computer and Information Systems
Knowledge of computer programming, hardware and software.

Business, Finance and Management

Knowledge related to organization and control of business activities.

Labour Market Information Survey
Date modified: