Data Base Analyst

Avanti Software Inc.; Fort McMurray; On-site; CAD 68,497 - 83,718; Full time

Benefits offered by this job

Health and dental benefits

LAPP pension

Northern Living Allowance

Vacation entitlement and paid holidays

Life insurance

Paid sick days

Employee discounts

Job summary

Keyano College Information Technology Services Department seeks a Database Analyst to design, install, and maintain production databases, ensuring high availability and resiliency. You will develop policies, implement audit, logging and monitoring, and support on-premises and cloud integrations within a data warehouse and enterprise reporting framework.

On-campus work and relocation to Fort McMurray, AB are required.

Qualifications

• Degree/Diploma in computer science, computer engineering or related field.
• 3+ years in MS-SQL databases, queries, and ETL development/integrations.
• One of the industry certifications in SQL (MCSA or similar).
• Experience with data warehouse and cloud-based solutions (Azure Data Lake or similar).
• Project management experience.
• Experience with data processing flowcharting techniques.

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.

Skills

MS-SQL

ETL

XML

Data warehouse

Reporting

Scripting

Project management

Education

Degree/Diploma in computer science or related field

Tools

Azure Data Lake

Power BI

SSMS

Job description

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.

Note: this is not a remote or hybrid work opportunity, you will be required to work on campus and relocate to Fort McMurray, AB.

About Us

Keyano College is a comprehensive post-secondary educational institution located in Fort McMurray, nested in the Regional Municipality of Wood Buffalo on traditional Treaty 8 territory. We are a strategic community partner that meets both the training and talent upgrading needs of industry, as well as the personal enrichment and cultural needs of the Wood Buffalo community. We take pride in offering a safe work and study environment that embraces Equity, Diversity, Inclusion and Belonging. Our students and customers come from all walks of life and so do we. That is why we are committed to hiring great people from a variety of backgrounds because it makes our employee community stronger.

Duties & 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.

Qualifications

Required Qualifications:

• 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

Preferred Qualifications:

• 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

Please note that if your education was received internationally, upon hire we will require you to provide an international education assessment completed through WES, IQAS or one of the other IRCC approved designated organization.

Compensation and Benefits

• Compensation is $76,108.66 (CUPE TS8-1) with the following health and benefit package.
• 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

We offer various perks and discounts to our employees:

• Employee Service and Academic Achievement recognition
• Greatly discounted employee membership to the Syncrude Sports and Wellness Centre (our well-known gym and recreational facility).
• Tuition waiver for all employees and dependents to take courses at Keyano College to support your thirst for learning.
• Employee Discounts for the Keyano Theatre and the Keynotes Bookstore.

Additional Information

At Keyano College, we are committed to fostering an equitable, caring and resilient environment where everyone feels valued and connected to the common goal and the college community. We welcome applications from all qualified individuals and encourage candidates who will contribute to the diversity of the College to apply.

We would like to thank all applicants in advance for submitting their resumes. Please note, only those candidates chosen to continue through the selection process will be contacted.