data analyst - informatics and systems

Government of Canada; Vaughan; On-site; CAD 60,000 - 100,000; Full time

Job summary

An established industry player is seeking a skilled Database Administrator to enhance their IT infrastructure. In this role, you will collect and analyze data, develop and maintain databases, and ensure data integrity across systems. Your expertise in SQL, Python, and various database management tools will be crucial in documenting data requirements and collaborating with teams to implement effective data policies. This position offers a unique opportunity to contribute to meaningful improvements in data management within a dynamic environment. If you are passionate about data and technology, this role is perfect for you.

Benefits

Health Care Plan

Bonus

Free Parking

Qualifications

• Bachelor's degree in Computer Science or related field is essential.
• Experience in database management and data analysis is an asset.

Responsibilities

• Collect and analyze data to improve IT infrastructure.
• Develop and maintain databases, ensuring data integrity.
• Document and communicate data requirements to stakeholders.

Skills

Data Analysis

Database Management

Python

SQL

Excel VBA

Data Modelling

Education

Bachelor's degree

Computer Science

Data Processing Technology

Tools

MS SQL Server

MySQL

PowerBuilder

R

Xcode

Sybase

MS Office

Job description

Overview Languages

English

Education

• Bachelor's degree
• Data processing and data processing technology/technician
• Computer science
• Data modelling/warehousing and database administration

Experience

Experience an asset

On site

Work must be completed at the physical location. There is no option to work remotely.

Responsibilities Tasks

• Collect data to identify areas for improvement within an organization’s IT infrastructure
• Develop and maintain computer databases
• Document reporting needs, queries, logic, results and recommendations to other information systems professionals
• Liaise with staff on data requirements, collection and availability
• Test data models and database management systems
• Design and develop database
• 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
• 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

Experience and specialization Computer and technology knowledge

• Excel Visual Basic for Applications (VBA)
• PowerBuilder
• R
• Xcode
• Data Warehouse
• MAC
• MS SQL Server
• Internet
• Sybase
• XBase
• MySQL
• Database software
• Data analysis software
• MS Office
• Python
• SQL
• XSL
• Visualforce

Additional information Security and safety

• Criminal record check

Benefits Health benefits

• Health care plan

Financial benefits

• Bonus

Other benefits

• Free parking available