Data and Integrations Architect

Brock University is located on the traditional territory of the Haudenosaunee and Anishinaabe peoples, many of whom continue to live and work here today. This territory is covered by the Upper Canada Treaties and is within the land protected by the Dish with One Spoon Wampum Agreement. 

We are one of Canada’s outstanding comprehensive universities, where excellence and innovation thrive! Brock has been proudly recognized as a Hamilton-Niagara Top Employer for eight consecutive years. Brock continues to earn recognition as one of Canada’s Best Employers and one of Canada’s Best Employers for Diversity in 2026. For the second consecutive year, Forbes, in partnership with Statista, also named Brock one of Canada’s Top Employers for Company Culture. At Brock, you will find a welcoming, inclusive community and an exciting range of meaningful career opportunities.

Ignite new possibilities for your career. Break through at Brock.

Post End Date:

November 25, 2026 at 11:59 PM

This job advertisement is to fill an existing vacancy in the Administrative Professional (Employee Group)

About the Role:

Reporting to IT Manager, Enterprise Solutions - Foundational Technologies, the Data and Integrations Architect is responsible for designing the data and integration architecture that supports institutional reporting, analytics, and informed decision-making and that governs how the University’s enterprise systems exchange data, and for administering the University's business intelligence, cloud data, and application programming interface (API) management and integration platforms, including the Microsoft 365 data estate. The incumbent designs, develops, integrates, secures, and supports data solutions, models, pipelines, APIs, integrations, and reporting environments while ensuring data quality, appropriate access, and alignment with governance and enterprise standards. Working directly with users and stakeholders, the incumbent identifies and translates business, reporting, and integration needs into secure, scalable, and supportable technical solutions. The incumbent provides expert troubleshooting, technical guidance, and architecture direction for complex data, integration, API, access, and reporting issues. The incumbent is the design authority for the University’s API management platform and its data platform, which together provide the governed routes through which systems of record are reached. This position maintains a strong hands-on technical focus while providing architectural direction for the University's data and integration environment.

The Data and Integrations Architect will:

• Design, document, and maintain the University's enterprise data architecture, including data models, data pipelines, warehouses, lakehouses, semantic models, and reporting structures;
• Assess current and proposed data solutions and recommend architecture and platform approaches that balance business requirements, scalability, performance, security, supportability, and alignment with enterprise standards;
• Design, develop, and support data conversion, reporting, analytics, and business intelligence solutions that meet business, technical, security, and governance requirements;
• Administer, support, monitor, and continuously improve business intelligence and cloud data platforms, including security, performance, reliability, upgrades, and lifecycle management;
• Design, document, and maintain the University’s integration architecture, including API, event-driven, file-based, and vendor-delivered integration patterns and the standards that determine when each is used;
• Serve as the design authority for the University's API management platform and establish, implement, and maintain API design, governance, lifecycle, security, and management standards that support secure and scalable integration across enterprise systems;
• Design, develop, and support integrations between cloud, on-premises, enterprise, and third-party systems, and evaluate vendor-delivered integration capabilities to ensure alignment with institutional architecture, governance, security, and support requirements;
• Publish approved APIs as connectors for the University’s low-code platform and as governed tools for automation and AI-enabled solutions;
• Provide governed access to AI model services through the API management platform, so that ensuring solutions are built on managed interfaces without direct access to systems of record or stored credentials;
• Monitor API and integration availability, performance, usage, cost, and failures, and proactively identify and address reliability, capacity, or security issues;
• Administer role-based security and user access to reports, datasets, workspaces, data sources, APIs, and related platforms in accordance with least privilege principles and information security standards and policies established by the Information Security function;
• Investigate data discrepancies and reporting issues, perform root cause analysis, and coordinate corrective actions with data owners and technical teams;
• Ensure data architecture, models, integrations, APIs, platform configurations, and access controls incorporate governance, privacy, security, retention, and data quality requirements;
• Partner with users and stakeholders to understand business needs, analyze requirements, and translate them into scalable data, reporting, analytics, and integration solutions;
• Analyze current-state processes and systems, evaluate solution options, and provide recommendations that balance user needs, data governance requirements, technical constraints, scalability, integration impacts, and ongoing support;
• Respond to service requests and incidents, triage and investigate data, integration, API, reporting, refresh, performance, and access issues, and resolve or escalate as appropriate;
• Serve as the technical lead and subject matter expert for data, architecture, integration, reporting, and platform initiatives, including major enterprise system implementations; and
• Lead the planning, design, coordination, implementation, and continuous improvement of data and integration solutions, contributing to architecture standards, roadmaps, governance processes, and platform optimization initiatives.

Key Skills and Experience:

• Strong knowledge of Power BI administration and development, including workspaces, gateways, semantic models, datasets, reports, dashboards, refresh schedules, deployment, and role-based security;

• Strong knowledge of SQL and experience extracting, transforming, analyzing, and integrating data from multiple systems and data sources;

• Knowledge of Microsoft Azure data services and Microsoft Fabric, including cloud-based data storage, integration, pipeline, warehouse, lakehouse, and analytics concepts;

• Strong knowledge of integration and API architecture, including ETL/ELT methods, change data capture, REST and SOAP services, OpenAPI specifications, API lifecycle management, and synchronous, event-driven, and batch integration patterns;

• Knowledge of API management, messaging, workflow, eventing, and identity and access management concepts, including Azure API Management, OAuth 2.0, OpenID Connect, Microsoft Entra ID, and related integration technologies;

• Strong knowledge of data architecture and modelling methods, including conceptual, logical, and physical models, relational and dimensional modelling, semantic layers, data warehousing, lakehouse concepts, metadata, lineage, and integration architecture;

• Knowledge of data governance, access management, least privilege, data quality, privacy, security, classification, ownership, and appropriate data handling practices;

• Ability to gather, analyze, document, and translate ambiguous or complex business and technical requirements into practical architecture recommendations and secure, scalable, supportable solutions;

• Knowledge of software development lifecycle, source control, automated deployment, testing, quality assurance, change management, incident management, and project delivery methodologies;

• Strong communication, stakeholder engagement, relationship-building, and collaboration skills, with the ability to explain technical concepts, facilitate discussions, provide guidance, and build effective working relationships with technical and non-technical stakeholders;

• Strong analytical, troubleshooting, and risk assessment skills, including the ability to investigate complex issues, identify root causes, and recommend effective solutions and controls;

• Ability to prioritize and execute work across multiple incidents, service requests, enhancements, and projects with competing deadlines;

• Ability to assess current and emerging technologies, architecture options, and design trade-offs and determine their appropriate application within the University environment; and

• High degree of accuracy, attention to detail, judgement, and discretion when working with institutional data, system interfaces, and access permissions.

Preferred or Asset Skills:

• Microsoft certification related to Power BI, Fabric, Azure Data, Azure integration or development, Azure solution architecture, or Azure administration;
• Experience with Microsoft Azure and Fabric technologies, including Data Factory, Synapse Analytics, Data Lake, API Management, Logic Apps, Service Bus, Event Grid, Functions, DAX, Power Query/M, or comparable data, integration, and analytics solutions;
• Experience supporting ERP, student, human resources, finance, research, or other enterprise administrative systems;
• Experience integrating or migrating enterprise systems such as Ellucian Banner (including Ellucian Ethos) and Workday, or comparable student information, human resources, and finance platforms;
• Experience with Microsoft Power Platform, including Dataverse, custom connectors, managed solution deployment, Azure DevOps, and automated deployment pipelines;
• Experience with data cataloguing, lineage, governance frameworks, privacy practices, or data quality tools, or with higher-education reference models and data standards;
• Business analysis, data management, data architecture, integration architecture, cloud architecture, or project management coursework or certification; and
• Experience in a complex public-sector or post-secondary environment.

Salary and Total Rewards:

• Job Grade [M], Salary Scale ($74,235.00 - 118,776.00);
• Target Hiring Range: $74,235.00 - $90,000.00*;
• This is a permanent position that includes:
• Health & Dental Benefits: Comprehensive extended health, dental, and vision coverage.
• Pension Plan: Enrolment eligibility in the Brock University Pension Plan.
• Vacation: Up to 3 weeks per year, in addition to University holidays.
• Flexible Work Arrangements: Hybrid work schedule available.
• Professional Development: Eligibility for the Brock Tuition Waiver Program.

*The final salary is based on experience, internal equity, and budget considerations within the target hiring range.