Please Note: If you are a current Algonquin College employee, apply to this job via the Workday application.

Department:

Position Type:

Salary Range:

Scheduled Weekly Hours:

Anticipated Start Date:

Length of Contract:

Posting Information

Posting Closing Date:

Please note: jobs are posted until 11:59 pm on the job closing date.

Land Acknowledgment:

Algonquin College campuses in Ottawa and Pembroke are located on the traditional unceded, and unsurrendered territory of the Anishinàbe Algonquin People. The Algonquin People have inhabited and cared for these lands since time immemorial. We take this time to express our gratitude and respect to them and to the land for all that it has provided and will continue to provide.

Job Description:

The Senior Data and Analytics Systems Analyst provides senior hands-on technical analysis, design, development, integration, implementation, and production support for the College's enterprise data and analytics platforms, with a primary focus on the enterprise data warehouse. This position independently develops and optimizes complex SQL, data models, ETL/ELT processes, and integrations involving legacy, on-premises, and software-as-a-service systems. This position also develops and supports Power BI and Microsoft Fabric solutions, including semantic models, governed data products, and approved emerging capabilities such as data agents. The Senior Data and Analytics Systems Analyst implements and monitors data quality controls, diagnoses complex data and production issues, and advises College clients and technical teams on secure, reliable, supportable implementation options. This position works within approved enterprise architecture, governance, security, and technology standards; contributes recommendations for platform improvement; and acts as technical lead for assigned workstreams while guiding less-experienced technical staff.

Required Qualifications:

• Four (4) year degree in Computer Science, Information Technology, Data and Analytics, or a closely related field.
• Relevant professional certifications are considered an asset but are not mandatory where equivalent education, training, and experience have been demonstrated.
• At least five (5) years of advanced SQL development and work with enterprise relational databases.
• Substantial experience designing, developing, maintaining, and troubleshooting enterprise data warehouse and ETL/ELT solutions.
• Experience integrating data from multiple enterprise systems, including legacy and software-as-a-service applications.
• Experience supporting production data services and resolving complex data, performance, and integration issues.
• Experience with Power BI and modern data and analytics platforms; Microsoft Fabric experience is preferred.
• Experience translating business requirements into secure, supportable, and reusable data solutions; independently delivering complex technical work; leading defined technical workstreams; and guiding less-experienced analysts or developers.

*This position is paid at Payband K

*Vacancy is for P00655

This position is subject to the terms of Full-time Support Staff Collective Agreement: https://www.algonquincollege.com/hr/files/2024/01/SSCollectiveAgreementCurrent_E-1.pdf

This position is eligible for hybrid work in accordance with the College's Flexible Work Arrangement Policy (subject to change)https://www.algonquincollege.com/policies/hr26/

Why Join Algonquin College?

• Compensation: Many roles offer a competitive base salary and comprehensive benefits, including health, dental, and retirement plans designed to support your well-being. Eligibility for benefits vary by position. Benefits | Careers

• Learning and Development Opportunities: Access to training, tuition assistance programs (Algonquin College Courses and Degree Completion), certifications, workshops, and professional courses that allow you to grow and advance in your career. About Us | Employee Learning and Development. Availability depends on role and employment status.

• Company Culture: Our values of caring, learning, integrity, and respect define how we interact with one another. We foster a supportive and collaborative environment. Algonquin College has been recognized by Forbes as one of Canada’s Best Employers for 2025 and one of Canada’s Best Employers for Diversity for 2024

• Inclusion, Diversity, Equity, and Accessibility (IDEA): We are proud to be the first Ontario college to implement an Equity, Diversity, and Inclusion policy, fostering an inclusive workplace where all employees feel respected and valued. Affinity Group Conversation Communities | Inclusion & Diversity & Truth and Reconciliation

• Flexible Work Arrangement Policy. Select positions are eligible for hybrid work in accordance with the College’s Flexible Work Arrangement Policy https://www.algonquincollege.com/policies/hr26/ (subject to change).

How We Use AI in Hiring:  

Algonquin College uses artificial intelligence technology to assist in screening and assessing applicants and their applications, while ensuring that all processes respect and uphold the provisions of applicable collective agreements above all else.

Accessibility:

Algonquin College values diversity and is an equal opportunity employer. We are committed to fostering an inclusive, equitable, and culturally respectful workplace. We offer an inclusive work environment and encourage applications from candidates of all backgrounds, including Indigenous peoples, persons with disabilities, members of racialized groups, and individuals from diverse communities. If you require accommodation during the recruitment process, please contact the Human Resources department at [email protected]. While we thank all those who apply, only those to be interviewed will be contacted.