Senior Data Architect - Hybrid

Overview

Location:

Calgary, Alberta

Employment Type:

Full Time – Permanent

Salary: SP4, Level
6. Final compensation will be determined based on education, qualifications, experience, and internal equity.

Senior Data Architect – Hybrid

The Alberta Energy Regulator (AER) is seeking a Senior Data Architect to join the Information Management & Technology branch. This role is responsible for guiding data architecture during regulatory platform development and analytics integration, managing data modeling and database design to align with business requirements, APIs, and Entity Framework models through modern database‑as‑code approaches.

The role ensures regulatory system data feeds into the bronze and silver layers of the Databricks‑based Lakehouse and supports downstream consumption, governance, lineage, consistency, and enterprise integration.

The Senior Data Architect collaborates with Product Owners, Solution Architects, Enterprise Data Modelling, and Data Engineering teams to transform business and regulatory needs into secure, scalable, and maintainable data solutions that meet enterprise standards and support long‑term architectural goals.

• Lead data architecture and modelling efforts for regulatory platform solutions, collaborating with Product Owners, Solution Architects, and delivery teams.
• Translate business and system requirements into conceptual, logical, and physical data models for transactional, integration, and analytical workloads.
• Collaborate with the Enterprise Data Modeller to align platform data models with enterprise business information models and oversee physical model implementation.
• Define and implement data architecture patterns supporting Entity Framework and database‑as‑code approaches, ensuring alignment between application domain models, APIs, and physical database design.
• Partner with the Data Engineering Practice Lead and teams to integrate regulatory platform data into the Databricks‑based medallion architecture (Bronze and Silver layers).
• Design secure and performant data access mechanisms, including APIs, views, materialized views, and data‑sharing patterns for internal and external consumers.
• Provide architectural leadership and guidance to Data Architects, Solution Architects, and Data Engineers to ensure consistency, interoperability, reusability, and adherence to enterprise standards.
• Support modernization initiatives such as legacy system transformation, cloud migration, master/reference data alignment, and integration of operational and analytical platforms.
• Establish and promote best practices for data architecture, modelling, governance, security, resiliency, metadata, and performance optimization.
• Ensure solutions support regulatory traceability, auditability, lineage, governance, and compliance requirements.
• Maintain architecture artifacts and documentation including data models, integration mappings, lineage, data flows, and architectural decision records.
• Participate in solution and platform architecture reviews, contributing to technology selection, implementation strategy, and long‑term evolution of enterprise data capabilities.

• Bachelor’s degree in Computer Science, Information Systems, or related field.
• 7+ years of progressive experience in enterprise data architecture, engineering, modelling, and solution design for large‑scale custom application platforms.
• Proven experience designing conceptual, logical, and physical data models for operational, integration, and analytical systems.
• Strong experience with Entity Framework and database‑as‑code approaches, aligning domain models, APIs, relational schemas, and application development practices.
• Experience supporting modern software delivery practices including source control, pull request reviews, CI/CD pipelines, automated deployments, and Agile models.
• Hands‑on experience designing and implementing cloud‑based data platforms and medallion architecture patterns (Bronze, Silver, Gold) using Databricks and Delta Lake technologies.
• Experience enabling enterprise analytics, AI, reporting, and data‑sharing capabilities through governed and scalable data hub architectures.
• Strong…