GOAPRDJP000001043 – Data Architect – Senior

S M Software Solutions Inc; Edmonton; A distancia; CAD 120.000 - 170.000; Jornada completa

Descripción de la vacante

The Government of Alberta is modernizing regulatory data systems. We seek a Senior Data Architect to lead integration across DRAS, a Databricks-based data platform, and a geospatial platform. You will set data direction for regulatory, environmental, and spatial data, ensuring trusted, timely, reusable data for regulators and Albertans.

You will join a high-performing agile team and mentor others while delivering architecture with governance, security, and data quality at the core.

Formación

• 8+ years of experience in enterprise data architecture and data integration.
• Experience documenting enterprise databases at GOV-sized scale.
• Leadership and presentations to senior management.
• Knowledge of data governance, security, and privacy standards.
• Experience with cloud data platforms and BI tools.

Responsabilidades

• Define target-state data architecture for DRAS, Databricks platform, and Alberta Geospatial Platform.
• Lead data pipelines design and interface agreements across systems.
• Establish data contracts, API specs, and data quality rules.
• Participate in agile ceremonies and turn architecture into user stories.
• Mentor team members and promote data architecture best practices.

Conocimientos

Leadership

Agile ceremonies

Data governance

Data modelling

Public sector experience

Educación

University degree in Computer Science or related field

Herramientas

Databricks

Delta Lake

Power Designer

ER Studio

Rational Rose

BPwin

Er-win

SQL

Power BI

Cognos BI Suite

Descripción del empleo

• 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 environment 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, coordinate reference systems, and spatial accuracy across platforms.

Integration and Delivery

• Lead the design of data pipelines and interfaces between systems, working closely with data engineers and developers during build.
• Define data contracts, API specifications, and interface agreements between system owners.
• Resolve complex integration issues involving:
  • Data quality
  • Schema changes
  • Latency
  • System dependencies
• Take part in agile ceremonies, including:
  • Sprint planning
  • Backlog refinement
  • Reviews
• Turn architecture into actionable user stories.

Data Governance, Security, and Quality

• Embed data governance practices, including:
  • Metadata management
  • Lineage
  • Data classification
  • Master data
  • Reference data
• Ensure designs meet Government of Alberta standards for:
  • Information security
  • Privacy, including Alberta's access-to-information and privacy legislation
  • Records management
• Define data quality rules, validation frameworks, and monitoring approaches across integrated systems.
• Apply role-based access controls and data-sharing policies appropriate to data sensitivity.

Leadership and Collaboration

• Serve as the trusted data architecture advisor to program leadership, product owners, and technical teams.
• Work with business areas to understand regulatory processes and turn them into data requirements.
• Coordinate with enterprise architecture, cybersecurity, and other ministries' platform teams to keep the work aligned with GoA standards and roadmaps.
• Produce clear architecture documentation, diagrams, and decision records.
• Mentor team members and promote data architecture best practices.

Required Qualifications

• University degree in Computer Science, Information Systems, Engineering, Geomatics, or a related field.
• 7+ years of progressive experience in data architecture, data engineering, or data integration, with at least 3 years in a data architect role.
• Hands-on experience designing solutions on Databricks, including:
  • Delta Lake
  • Spark (PySpark/SQL)
  • Unity Catalo
• Strong experience with data modelling, including:
  • Relational
  • Dimensional
  • Lake house approaches
• Proven experience designing enterprise integration patterns, including:
  • REST APIs
  • ETL/ELT
  • Event streaming
  • Change data capture
• Experience with cloud data platforms, preferably Microsoft Azure, including:
  • Data Lake Storage
  • Data Factory
  • Event Hubs
  • Key Vault
• Experience with ServiceNow Integration.
• Experience in the public sector, ideally with government regulatory systems or programs.
• Experience integrating with geospatial platforms, and working knowledge of geospatial data concepts, formats, and standards.
• Working knowledge of geospatial data concepts, formats, and standards.
• Solid understanding of:
  • Data governance
  • Metadata management
  • Data quality
  • Data security principles
• Experience working in agile delivery teams, with experience in public sector in similar capacity.
• Excellent communication skills, with the ability to explain technical concepts to non-technical audiences.

Competencies

Systems Thinking

Understands how DRAS, the data platform, and the geospatial platform connect, and anticipates downstream impacts of design choices.

Creative Problem Solving

Finds practical, innovative solutions to complex integration and data challenges.

Agility

Adapts quickly to changing priorities and evolving technology in a fast-paced environment.

Drive for Results

Delivers high-quality architecture that produces measurable value for the program.

Build Collaborative Environments

Works effectively across teams, ministries, and disciplines to reach shared goals.

Develop Networks

Builds relationships with stakeholders and technical partners to advance the work.

Develop Self and Others

Shares knowledge, mentors colleagues, and keeps learning.