Skills Data Analyst - Informatics And Systems in Nova Scotia

National Occupational Classification update

We have updated this page to reflect the transition to the 2021 version of the National Occupational Classification (NOC). This means that the occupation "data analyst - informatics and systems" was moved from the group Database analysts and data administrators (NOC 2172) to the group Database analysts and data administrators (NOC 21223).

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 -
    • 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 -
    • 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 -
    • 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 -
    • 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 -
    • 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 -
    • 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 -
    • 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 -
    • 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: