analyst, database

Overview

Languages

English

Education

• College/CEGEP

Experience

5 years or more

Responsibilities

Tasks

• Collect data to identify areas for improvement within an organization’s IT infrastructure
• Document customers’ requirements for projects
• Document reporting needs, queries, logic, results and recommendations to other information systems professionals
• Enact measures to make sure unauthorized users cannot access the data
• Liaise with staff on data requirements, collection and availability
• Provide advice to other informatics professionals regarding database management tools
• Test data models and database management systems
• 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
• Write scripts related to stored procedures and triggers
• Project management

Experience and specialization

Computer and technology knowledge

• MS SQL Server
• Project management software
• Database software
• Programming languages
• Software development
• .NET
• C#
• Object-Oriented programming languages
• SQL
• Data analysis system

Additional information

Work conditions and physical capabilities

• Fast-paced environment
• Work under pressure
• Tight deadlines
• Repetitive tasks
• Handling heavy loads
• Attention to detail
• Sitting

Personal suitability

• Accurate
• Efficient interpersonal skills
• Excellent oral communication
• Excellent written communication
• Initiative
• Organized
• Team player
• Adaptability
• Accountability
• Quick learner

Benefits

Health benefits

• Dental plan
• Disability benefits
• Health care plan
• Vision care benefits

Financial benefits

• As per collective agreement

Long term benefits

• Maternity and parental benefits