database analyst

Responsibilities

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

Experience and specialization

Computer and technology knowledge

• R
• MySQL
• Database software
• Amazon Web Services (AWS)
• Big data
• Python

Benefits

Health benefits

• Dental plan
• Disability benefits
• Health care plan
• Paramedical services coverage
• Vision care benefits

Financial benefits

• Bonus
• Group insurance benefits
• Life insurance
• Registered Retirement Savings Plan (RRSP)
• Stocks/shares

Long term benefits

• Long-term care insurance
• Maternity and parental benefits

Other benefits

• Free parking available
• On-site amenities
• Paid time off (volunteering or personal days)
• Team building opportunities
• Parking available
• Wellness program