Data Base Analyst

Keyano College’s Information Technology Services Department is currently seeking a Data Base Analyst to join their dynamic team. The Database Analyst’s role is to design, install, and maintain production databases while ensuring high levels of data availability, and system resiliency. This position will be responsible for developing, implementing, and overseeing database policies and procedures to ensure the integrity and availability of databases and their accompanying software. Included in the responsibilities of this position is the implementation of audit, logging, and monitoring solutions to provide proactive operational support.

Working with the ERP team, the Database Analyst will develop a strategy to support the integration of on premise and cloud-based enterprise applications. This work will tie in to a larger data warehouse and enterprise reporting framework. Creating required reports, data sets or ETL in response to business user needs is also a key function of this position.

Responsibilities

Design and maintain database and data warehouse structures to support business and application needs; Monitor database performance and resolve access, reliability, and efficiency issues; Provide technical support for applications that use organizational databases; Plan and coordinate data migrations, system integrations, and data transfers between platforms; Manage database changes, testing, and quality assurance processes to ensure system stability; Develop and maintain reports, datasets, ETL processes, and data solutions to support business operations; Implement monitoring, auditing, logging, backup, and security controls to protect data and support operations; Perform database maintenance activities, including upgrades, patching, and ongoing performance improvements; Develop database strategies, architecture standards, governance practices, and disaster recovery solutions in collaboration with stakeholders; Participate in technology projects, develop technical documentation, write scripts to enhance system functionality, and provide guidance to junior team members

Requirements

Degree/Diploma in a technical field such as computer science, computer engineering or related field; 3+ years of experience in the management and troubleshooting of MS-SQL databases, queries, and development of ETL code and integrations; One of the many available industry certifications in SQL (Microsoft MCSA or similar); Competency with XML constructs and schemas. Knowledge of programming, scripting methods, and best practices is required; Experience in working with or managing a data warehouse and report/dashboard modeling (preferably Azure Data Lake or similar cloud-based solutions); Project management experience; Experience with data processing flowcharting techniques

Nice to have

Experience with API protocols and schemas such as SOAP and REST; Experience working with other SQL platforms (MySQL, etc.) would be desirable; Familiarity with change management processes, testing methodology, and agile development methodology; A collaborative and approachable style with an ability to build consensus with competing departments; Ability to communicate effectively with and influence end user clients; Experience in the education sector (preferably Post-secondary) is a plus

Benefits

Employer paid comprehensive health and dental benefits, including a health spending account; Generous defined benefit pension plan though LAPP starting on day 1 of employment; This position qualifies for additional payment of the Northern Living Allowance of $1,040.00 per month; Generous vacation entitlement and the bonus of paid holidays between Christmas and New Years; Life insurance is 2.5 times your annual salary; Paid sick days; Employee Service and Academic Achievement recognition; Greatly discounted employee membership to the Syncrude Sports and Wellness Centre; Tuition waiver for all employees and dependents to take courses at Keyano College; Employee Discounts for the Keyano Theatre and the Keynotes Bookstore