Data Solutions Architect

Date Posted: 01/05/2026Req ID: 46528Faculty/Division: Operations and Real Estate PartnershipsDepartment: Institutional Research and Data GovernanceCampus: St. George (Downtown Toronto)Position Number: About us The University’s Institutional Research and Data Governance (IRDG) office provides leadership and administrative support for the institution’s data strategy. The IRDG office’s mandate is to: Provide reporting and analytics services within our distributed institutional research model: lead institution-wide analysis projects, provide training opportunities for divisional analysts, implement new analytics tools and platforms, and improve access to curated institutional datasets. Support external reporting of institutional data (SMA metrics, key performance indicators for governance, international rankings, data exchanges with peer institutions). Implement an institution-wide data governance program to support the University in strategically harnessing data to achieve institutional goals. Provide leadership and administrative support for the institution’s data strategy. Your opportunity Under the direct supervision of the Manager of Data Engineering and Business Intelligence, the incumbent will work closely with team members, Central IT, and a wide range of stakeholder groups. This role will play a key part in shaping and executing an ongoing data roadmap that anticipates future growth, strengthens the University’s data security posture, enhances data assets, and elevates the strategic profile of IRDG and the broader institution. The Data Solutions Architect will lead data-related initiatives, design scalable technology solutions, and establish improved data architecture and usability. Key responsibilities will also include designing efficient and maintainable data models, cleaning and optimizing existing data structures, architecting end-to-end data solutions, cataloguing data assets, and implementing governance practices to ensure consistency, accessibility, and long-term value. The Data Solutions Architect will lead our modernization journey across the Microsoft Fabric ecosystem and shape our future state data environment. They will co‑lead architecture committees to define standards, governance, and scalable design practices across the organization. In addition, this role will drive the implementation of AI solutions within IRDG aligned with the university AI framework, enabling adoption, and ensuring responsible, data‑driven integration into our analytics and operational workflows. Your responsibilities Developing and updating architectural framework for highly complex and confidential university-wide IT systems, including creating, designing, reviewing, and evolving data models and data roadmaps, as well as guiding implementation to meet both current requirements and future business needs. Researching, analyzing and recommending potential changes to system features, including initiatives for data classification, archiving, and access control to ensure data security, compliance, and efficient lifecycle management across the enterprise data warehouse. Analyzing business and operational requirements to plan the implementation of new systems, including the cleanup and organization of the existing data warehouse by refining tables, views, and processes to improve system performance, data quality, and operational efficiency. Keeping well-informed on current technologies, best practices, industry standards and developing the architecture of a robust, scalable, secure, and sustainable framework to maximize integration opportunities across all different platforms. Planning the implementation of new business system processes, including developing and sustaining data governance policies and standards to ensure data access, accuracy, traceability, classification, compliance, integrity, and security. Leading and planning IT projects, including navigating the maturity of our MS Fabric environment to ensure it meets current needs while scaling for future use cases. Advising clients and technical subject matter experts on best practices for documenting system requirements, while analyzing and translating business needs into clear, well-documented technical and functional requirements. Essential qualifications Bachelor’s Degree or acceptable combination of equivalent experience. Eight years of experience or more in a data architecture or other data architecture related roles. Experience working with on‑premises and cloud solutions. Experience in data modelling and query performance tuning on SQL Server, MySQL, and Azure platforms. Experience working with large and complex data sets, as well as analyzing volumes of data. Experience in the creation of physical and logical data modelling and administration of databases. Experience with system management, performance monitoring, data security, backup, mirroring, replication, change management, high availability, and disaster recovery solutions. Experience leading IT projects, including defining requirements and scope of complex projects and conducting project costing, scheduling and resourcing. Experience with Data Lakes, Data Analytics, Predictive Analytics, data transformation frameworks, database refactoring/re‑engineering. Expert data modelling and database design skills (both dimensional and relational). Advanced knowledge and experience working with database design, maintenance and operations on various platforms, application security and disaster recovery. Exceptional analytical skills, showing fluency in the use of tools such as MS SQL, MySQL, and strong ETL language SQL programming skills. Excellent written and verbal communications skills at both technical and business level, able to build and foster positive relationships with highly dispersed and dynamic teams. Experience with access management and archiving data. Assets (Nonessential) Experience with Azure Data Factory. Experience with Power Platform and integration with enterprise‑grade database for reporting. Knowledge of MS Fabric features, particularly OneLake. To be successful in this role you will be Diplomatic Intuitive Multi‑tasker Organized Please note This is a new position. A copy of the detailed position description is available to USW employees upon request to the Operations and Real Estate Partnerships Office. Closing Date: 01/25/2026, 11:59PM ETEmployee Group: USWAppointment Type: Budget - ContinuingSchedule: Full-TimePay Scale Group & Hiring Zone: USW Pay Band 18 – $116,547. with an annual step progression to a maximum of $149,043. Pay scale and job class assignment is subject to determination pursuant to the Job Evaluation/Pay Equity Maintenance Protocol.Job Category: Engineering / Technical Lived Experience Statement Candidates who are members of Indigenous, Black, racialized and 2SLGBTQ+ communities, persons with disabilities, and other equity‑deserving groups are encouraged to apply, and their lived experience shall be taken into consideration as applicable to the posted position. Diversity Statement The University of Toronto embraces diversity and is building a culture of belonging that increases our capacity to effectively address and serve the interests of our global community. We strongly encourage applications from Indigenous Peoples, Black and racialized persons, women, persons with disabilities, and people of diverse sexual and gender identities. We value applicants who have demonstrated a commitment to equity, diversity and inclusion and recognize that diverse perspectives, experiences, and expertise are essential to strengthening our academic mission. As part of your application, you will be asked to complete a brief Diversity Survey. This survey is voluntary. Any information directly related to you is confidential and cannot be accessed by search committees or human resources staff. Results will be aggregated for institutional planning purposes. For more information, please see Accessibility Statement The University strives to be an equitable and inclusive community, and proactively seeks to increase diversity among its community members. Our values regarding equity and diversity are linked with our unwavering commitment to excellence in the pursuit of our academic mission. The University is committed to the principles of the Accessibility for Ontarians with Disabilities Act (AODA). As such, we strive to make our recruitment, assessment and selection processes as accessible as possible and provide accommodations as required for applicants with disabilities. If you require any accommodations at any point during the application and hiring process, please contact Job Segment: Solution Architect, Data Architect, Database, Architecture, Developer, Technology, Data, Engineering #J-18808-Ljbffr