Cognos BI Suite Establish integration patterns including: Data quality System dependencies Data quality Client: Government of Alberta - GOAPRDJP000001043 We are seeking a highly experienced

Senior Data Architect

to design and lead data integration between the

Digital Regulatory Assurance System (DRAS) ,

Databricks-based Data Management Platform , and

Alberta Geospatial Platform . The successful candidate will provide data architecture leadership across regulatory, environmental, and spatial data domains, ensuring trusted, timely, reusable, secure, and governed data for regulators, decision-makers, and Albertans. Role Snapshot

Job Title: GOAPRDJP000001043 - Data Architect - Senior Client: Government of Alberta Work Location: 9915 - 108 ST NW, Edmonton, Alberta, CAN, T5K 2G6 Work Arrangement: Remote Estimated Start Date: February 11, 2026 Estimated End Date: March 31, 2027 Business Days: 103.00 Estimated Hours: 7.25 hours per day Maximum Extension Term: 24 Months Must Have

Experience designing, planning, implementing and supporting enterprise solution databases in an environment equivalent in size and complexity to the Government of Alberta - 8 years. Experience documenting enterprise solution databases in an workplace equivalent in size and complexity to the Government of Alberta - 8 years. Experience in performing threat and risk assessments and presenting recommendations for risk mitigation to senior management - 6 years. Experience providing leadership, planning, estimating, and presentations of ideas and solutions. Experience with enterprise architecture principles and associated best practices, methods, standards, tools, policies, and processes - 8 years.



Experience working as a Data Architect in an enterprise IT environment equivalent in size and complexity to the Government of Alberta - 8 years. Nice Have

Experience designing and implementing enterprise architecture database plans and models that help align an organization’s data, information or technology with its required business capabilities in a large enterprise IT environment equivalent in size and complexity to the Government of Alberta - 5 years. Experience in using a tool for architecture models such as:

Power Designer ER Studio Er-win BP win Rational Rose - 4 years.

Experience project managing application development projects using Agile sprint development - 4 years. Experience with cloud computing or big data platforms and infrastructure - 5 years. Experience with enterprise business intelligence and performance management products. Specifically:

Cognos BI Suite Microsoft SQL Server Services MS Power BI (Query, View) MicroStrategy - 4 years.

Experience working as a Data Architect designing and implementing enterprise database solutions within an organization of equivalent size and complexity to the Government of Alberta - 4 years. Experience working with developing SQL databases - 5 years. Experience working with implementing a SQL data warehouse - 5 years. Experience working with querying data with Transact-SQL - 5 years. Prior experience with the Government of Alberta (GoA) is considered a strong asset - 5 years.



Description

Data Architect, Digital Regulatory Assurance System (DRAS) The Government of Alberta is modernizing how it regulates and assures environmental outcomes across the province. The

Digital Regulatory Assurance System (DRAS)

is central to that work. It supports applications, approvals, compliance, and monitoring activities that protect Alberta’s air, land, water, and biodiversity. We are looking for an experienced

Data Architect

to design and lead data integration between DRAS, our

Databricks-based Data Management Platform , and the

Alberta Geospatial Platform . You will set the direction for how regulatory, environmental, and spatial data moves, connects, and is governed across these systems. The goal is trusted, timely, and reusable data for regulators, decision-makers, and Albertans. You will join a high-performing, multidisciplinary team in a fast-paced, agile environment. The team includes developers, data engineers, GIS specialists, business analysts, and product owners. Key Responsibilities

Architecture and Design

Define and maintain the target-state data architecture for integrating DRAS, the Databricks Data Management Platform, and the Alberta Geospatial Platform. Design conceptual, logical, and physical data models for regulatory, environmental, and geospatial data domains. Establish integration patterns including:

Batch Near-real-time Event-driven API-based Change data capture suited to each use case.

Design lake house structures on Databricks, including:

Medallion (bronze/silver/gold) layers Delta Lake tables Unity Catalo organization

Architect spatial data flows that preserve geometry, c

📌 GOAPR1043 – Data Architect – Senior (Winnipeg)
🏢 S M Software Solutions
📍 Winnipeg