Skills Data Analyst - Informatics And Systems near Truro (NS)

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

Analysis Help - Analysis
  • Researching and Investigating
  • Planning
  • Analyzing Information

Analysis

Examining and evaluating information.

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

Service and Care

Taking care of the needs of people and animals.

Operating and Repairing Equipment, Machinery and Vehicles

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

Management Help - Management
  • Co-ordinating and Organizing
  • Supervising

Management

Taking charge of the direction and resources of an organization.

Co-ordinating and Organizing
Organizing and co-ordinating the activities of groups and individuals to align their activities with organizational objectives.
Supervising
Directing and monitoring the performance of others.
Communication Help - Communication
  • Professional Communicating
  • Advising and Consulting

Communication

Using communication skills to share information, advise and influence.

Professional Communicating
Preparing and delivering written, oral or visual material for the workplace that presents information.
Advising and Consulting
Providing guidance and advice to enable decision-making about tasks, situations, and processes.
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.

Handling Goods and Materials

Working with goods and materials manually or with machines.

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.

Building

Working with materials to construct, renovate and maintain structures.

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.

Knowledge

Social Sciences and Arts

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

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.

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.

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.

Business, Finance and Management

Knowledge related to organization and control of business activities.

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

Engineering and Technology

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

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

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.

Communications and Transportation

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

Health Services

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

Labour Market Information Survey
Date modified: