Full-time Senior Data and Analytics Systems Analyst

Original job posting

Designs, develops, integrates, and supports the College's enterprise data and analytics platforms, with a primary focus on the data warehouse, SQL, data models, ETL/ELT, Power BI, and Microsoft Fabric. Implements data quality controls, resolves complex production issues, advises on secure and supportable solutions, and leads assigned technical workstreams while guiding less-experienced staff.

Job details

Please Note: If you are a current Algonquin College employee, apply to this job via the Workday application. Department Data, Analytics and Automation Position Type Full-Time Support Salary Range $48.07-$55.57-Hourly Scheduled Weekly Hours 40 Anticipated Start Date November 30, 2026 Length Of Contract n/a Posting Information Support Staff employees, as defined by the full-time Support Staff Collective Agreement, will be given first consideration. Posting Closing Date October 15, 2026 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 humanresources@algonquincollege.com. While we thank all those who apply, only those to be interviewed will be contacted.

What you’ll do

Designs, develops, integrates, and supports the College's enterprise data and analytics platforms, with a primary focus on the data warehouse, SQL, data models, ETL/ELT, Power BI, and Microsoft Fabric. Implements data quality controls, resolves complex production issues, advises on secure and supportable solutions, and leads assigned technical workstreams while guiding less-experienced staff.

Requirements

Requires a four-year degree in Computer Science, Information Technology, Data and Analytics, or a closely related field, and at least five years of advanced SQL and enterprise relational database experience. Candidates need substantial data warehouse and ETL/ELT experience, enterprise system integration and production support experience, and the ability to deliver complex solutions, lead technical workstreams, and guide junior staff; Microsoft Fabric experience is preferred.

Benefits

• Health Insurance
• Dental Insurance
• Retirement Plans
• Training and Professional Development
• Tuition Assistance

Listed skills

• Power BI · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• Advanced SQL Development
• Enterprise Relational Databases
• Data Warehousing
• ETL/ELT
• Data Integration
• Power BI
• Microsoft Fabric
• Data Modeling
• Data Quality Controls
• Production Support
• Performance Troubleshooting
• Requirements Analysis
• Technical Leadership
• Data Governance
• Data Security
• Legacy and SaaS Systems Integration

Job areas

• Data & Analytics
• Technology
• Software
• Education
• Management & Leadership