database analyst

Job Description

<ul><li>Work Term: Permanent</li><li>Work Language: English</li><li>Hours: 37.5 hours per week</li><li>Education: Bachelor's degree</li><li>Experience: 5 years or more</li><li><h2>Tasks</h2><br></li><li>Collect data to identify areas for improvement within an organization's IT infrastructure</li><li>Data Science</li><li>Develop and implement a strategic blueprint to follow when deploying databases within their organization</li><li>Develop and maintain computer databases</li><li>Document customers' requirements for projects</li><li>Document reporting needs, queries, logic, results and recommendations to other information systems professionals</li><li>Enact measures to make sure unauthorized users cannot access the data</li><li>Liaise with staff on data requirements, collection and availability</li><li>Provide advice to other informatics professionals regarding database management tools</li><li>Setup the IT infrastructure to allow applications to access databases</li><li>Test data models and database management systems</li><li>Design and develop database</li><li>Operate database management systems to analyze data</li><li>Develop and implement data administration policy, standards and models</li><li>Research and document data requirements, data collection and administration policy, and data access rules</li><li>Develop policies and procedures for network access and usage and for the backup and recovery of data</li><li>Lead and co-ordinate teams of data administrators in the development and implementation of data policies, standards and models</li><li>Write scripts related to stored procedures and triggers</li><li><h2>Computer and technology knowledge</h2><br></li><li>R</li><li>MySQL</li><li>Database software</li><li>Amazon Web Services (AWS)</li><li>Big data</li><li>Python</li><li><h2>Health benefits</h2><br></li><li>Dental plan</li><li>Disability benefits</li><li>Health care plan</li><li>Paramedical services coverage</li><li>Vision care benefits</li><li><h2>Financial benefits</h2><br></li><li>Bonus</li><li>Group insurance benefits</li><li>Life insurance</li><li>Registered Retirement Savings Plan (RRSP)</li><li>Stocks/shares</li><li><h2>Long term benefits</h2><br></li><li>Long-term care insurance</li><li>Maternity and parental benefits</li><li><h2>Other benefits</h2><br></li><li>Free parking available</li><li>On-site amenities</li><li>Paid time off (volunteering or personal days)</li><li>Team building opportunities</li><li>Parking available</li><li>Wellness program</li></ul>