Data Solutions Specialist

Socket.dev; Toronto; On-site; CAD 67,000 - 88,000; Full time

Benefits offered by this job

Health & Life-Stage Support

Time Off & Balance

Competitive Salary

Professional Growth

Diversity & Inclusion

Campus Facilities

Job summary

Upper Canada College (UCC) in Toronto seeks a Data Solutions Specialist to accelerate its digital transformation by bridging stakeholders and its data environment. You will deliver scalable data pipelines, enable self‑service analytics in BigQuery, and elevate institution‑wide data literacy within a secure, governed cloud setup.

The role requires a post‑secondary degree in IT/CS, 3+ years in analytics/IT, and strong SQL, Python, APIs, and data visualization skills.

Qualifications

• Post-secondary degree in computer science, data analytics, IT, or related field.
• Minimum 3 years in business analysis, IT, or data analytics.
• Able to gather and document data or system requirements from non-technical stakeholders.
• Experience with data warehousing, data security, and governance.
• Proficient in SQL; strong Python and API concepts.

Responsibilities

• Understand data systems and workflows across College sites.
• Lead discovery sessions to define opportunities to automate data flows.
• Design clear data specifications and project briefs for teams and vendors.
• Develop scalable ETL/ELT pipelines into analytical environments.
• Support AI initiatives within governance and risk frameworks.
• Provide data systems support and documentation.
• Mentor on IB projects.
• Contribute to continuous improvement.

Skills

SQL

Python

APIs & data integration

Data visualization

Data governance

Stakeholder engagement

Cloud platforms (GCP)

Education

Bachelor's degree in computer science, data analytics, information technology, or related field

Tools

BigQuery

Google Cloud Platform

Apps Script

Google Data Studio

Job description

Employment Terms:Full Time, Permanent

Start date: October 2026

With a commitment to equity and fairness, students learn that what makes us different as individuals makes us stronger as a community. A rigorous academic program is supported by accomplished faculty, exceptional co-curricular programming, and state-of-the-art facilities. The UCC experience is underpinned by five core values: learning, pluralism, service, community, and wellbeing. Among its strategic goals is UCC’s ambition to become more diverse and inclusive. This is supported by a recognition that no learning community is whole without the inclusion and amplification of multiple voices; UCC is committed to fostering belonging, striving for justice and peace among all people, and addressing systemic and structural forms of oppression.

The Data Solutions Specialist role serves to accelerate the College’s digital transformation by acting as a crucial bridge between the College’s stakeholders and its digital data environment. Applying robust systems analysis practices, this position partners with internal teams and external vendors to align operational and academic priorities with a modern data architecture. By delivering scalable data pipelines, enabling intuitive self-service visualization tools, and elevating institution-wide data literacy, this position empowers a secure, data-informed K-12 environment prepared for the future of AI and emerging technologies. This role may include work outside of typical school hours.

Key Responsibilities and Tasks

Systems Analysis

• Build and maintain a strong understanding of the College’s data systems and structures;
• Conduct regular structured discovery sessions with stakeholders to identify and define opportunities to streamline and improve data workflows across the College’s connected systems through automation, API integrations and the use of emerging technologies including AI;
• Translate stakeholder requirements into clear, documented data specifications and project briefs for use by both the internal team and external partners;
• Build and maintain trusted relationships across the entire College, ensuring ongoing alignment between data capabilities and organizational needs;
• Develop and maintain vendor partnerships.

Data Infrastructure and Solutions

• Work with the Manager, Data & Analytics to develop tools and solutions that enable users to independently access, analyze, and interpret data;
• Support the development and execution of the College's data strategy including the migration of data into the Google Cloud Platform (GCP) & BigQuery environment;
• Collaborate with Manager, Data & Analytics and external partners, to design, develop, and maintain scalable end-to-end data pipelines (ETL/ELT) to move data securely into analytical environments;
• Implement appropriate data governance and privacy best practise to ensure compliance in federal and provincial legislation and Ministry of Education and school policies in order to ensure a secure, structured, and well-governed cloud environment;
• Continuously evaluate the College’s current data technology stack against emerging trends to identify where automation or AI integration can enhance organizational efficiency.

Support

• Provide data systems technical support and liaise with vendors when required or if escalation is necessary;
• Promote and reinforce responsible data governance and management best practices;
• Create and maintain required technical documentation and process manuals related to data systems and core processes;
• Support the secure, strategic exploration, development and deployment of AI technologies in compliance with governance and risk protocols;
• Develop and deliver internal professional development to enhance data literary skills within the College in order to support the College’s vision of becoming a data-informed organization;
• Support broader technology initiatives within the Information & Innovation team as required;
• Participate in ongoing professional learning and development.

Other Duties

• Contribute to continuous improvement and operational excellence initiatives;
• Be a mentor for an IB continuum project (Personal Project, PYP Exhibition or Extended Essay).

Job Requirements

Experience, Knowledge and Competencies:

• Post-secondary degree or diploma in computer science, data analytics, information technology, or a related field;
• Minimum of 3 years of experience in a business analysis, information technology or data, analytics role;
• Demonstrated experience engaging with non-technical stakeholders to gather, define, and document data or system requirements;
• Experience with data warehousing concepts and best practices for data storage and security;
• Strong working knowledge of Google Cloud Platform (GCP), including BigQuery, Google Cloud Storage, and related services;
• Understanding of API concepts, data integration patterns, and workflow automation principles;
• Proficiency in SQL, including writing and optimizing queries for data extraction, transformation, and validation in environments such as Google BigQuery;
• Working knowledge of Python & Google Coding tools such as Apps Script for data manipulation, automation scripting, and interacting with cloud services and APIs;
• Strong Understanding of data governance, privacy, and data security principles;
• Experience with data visualization and business intelligence tools such as Google Data Studio;
• Knowledge of AI tools and prompt optimization techniques.

What We Offer

At UCC, we believe in supporting the whole person. We offer a highly competitive total rewards package designed to support your professional growth, personal well-being, and every stage of your life journey:

• Comprehensive Health & Life-Stage Support: Robust medical, dental, and vision coverage, health care and lifestyle spending accounts, and dedicated support for various life stages—including a progressive menopause policy, hormonal health supports, and 24/7 access to our Employee & Family Assistance Program (EFAP).
• Generous Time Off & Balance: Enjoy additional paid time off during school-calendar breaks (including winter holiday, midterm breaks, and March Break), generous vacation allotment, paid volunteer time, and the unique opportunity for self-funded sabbaticals.
• Financial Security: A competitive salary ranges, a generous UCC-matched RRP program for staff, and parental leave top-ups.
• Unparalleled Professional Growth: Robust funding for external workshops, conferences, and networking, alongside access to UCC’s custom leadership development program and visiting global experts.
• A Vibrant, Pluralistic Community: Access to employee-resource groups, cultural celebrations, multi-faith spaces, and collaborative book clubs focused on equity and anti-oppression.
• Beautiful Campus Amenities: Work on a stunning midtown Toronto campus with free parking, and enjoy employee access to exceptional libraries, green spaces, and state-of-the-art athletic facilities (including fitness rooms, an indoor pool, and tennis/pickleball courts).

About UCC

Upper Canada College (UCC) is focused on making the world a more just and inclusive place through dialogue and teamwork. With a commitment to equity and fairness, students learn that what makes us different as individuals makes us stronger as a community. A rigorous academic program is supported by accomplished faculty, exceptional co-curricular programming, and state-of-the-art facilities.

The UCC experience is underpinned by five core values: learning, pluralism, service, community, and well-being. Among its strategic goals is UCC’s ambition to become more diverse and inclusive. This is supported by a recognition that no learning community is whole without the inclusion and amplification of multiple voices; UCC is committed to fostering belonging, striving for justice and peace among all people, and addressing systemic and structural forms of oppression.

UCC is an Equal Opportunity Employer and values diversity, encouraging applications from all qualified individuals including women, Indigenous Peoples, persons with disabilities, 2SLGBTQIA+ and historically marginalized persons. UCC embraces pluralism – celebrating differences, cherishing similarities, and giving voice to multiple perspectives.

This position is an existing vacancy. Compensation is based on qualifications and experience. The range for the position is $66,746-$87,604.