database analyst

Education

• College, CEGEP or other non-university certificate or diploma from a program of 1 year to 2 years
• or equivalent experience

Work setting

• Consulting firm
• Private sector

Tasks

• Collect data to identify areas for improvement within an organization's IT infrastructure
• Data Science
• Develop and implement a strategic blueprint to follow when deploying databases within their organization
• Develop and maintain computer databases
• 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
• Setup the IT infrastructure to allow applications to access databases
• 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

Supervision

• 1 to 2 people

Work conditions and physical capabilities

• Fast-paced environment
• Work under pressure
• Repetitive tasks
• Attention to detail

Personal suitability

• Client focus
• Efficient interpersonal skills
• Excellent oral communication
• Excellent written communication
• Organized

Experience

• 2 years to less than 3 years

Employment terms options

• Flexible hours
• Overtime available

Support for newcomers and refugees

• Supports newcomers and / or refugees with foreign credential recognition
• Offers mentorship programs that pair newcomers and / or refugees with experienced employees

Support for Indigenous people

• Offers mentorship, coaching and / or networking opportunities for Indigenous workers
• Provides cultural competency training and / or awareness training to all employees to create a welcoming work environment for Indigenous workers