Data Architect

Role: Data Architect (REMOTE/CANADA) - JP869

! STRICTLY DO NOT APPLY IF YOU'RE NOT IN CANADA AND HAS NO WORK AUTHORIZATION !

! PLEASE READ BELOW ENTIRE MESSAGE !

(NOTE: We are considering Canadian Citizen and PR holders. For the candidate who are on Work Permits and awaiting PR invitation, we don’t provide T4 because this is contract job and the rate we provide is for incorporation. Hence, PR points are not applied, for example: if you’re applying PR under CEC class.)

Client: Government of Alberta

Incorporation Rate: $80 CAD/hr (Canada or Provincial incorporation is a MUST)

Respond by: 26 - March - 2026

Anticipated Interviews dates

• will be held between April 7-10 2026. this is an estimate only.

Scoring Methodology:

Financial/Pricing: 20%

Resource Qualifications: 20%

Interview Process: 60%

SKILL MATRIX:

Certification in The Open Group Architecture Framework (TOGAF).

Active Azure certificates: AZ-305. Please attach to the bottom of the resume

7+ years of Experience as a Data Architect planning, designing, documenting and implementing enterprise data architectures for large complex cloud-based application development projects in an environment equivalent in size and complexity to the Government of Alberta.

7+ years of Experience designing solutions that enable complex reporting and analytics in Power BI

7+ years of Experience developing and presenting complex data concepts, recommendations and decisions in an easy-to-understand manner to non‑technical stakeholders and senior leadership.

7+ years of Experience developing conceptual, logical, and physical data models aligned with enterprise data policies including within Microsoft Dataverse.

7+ years of Experience implementing data management platforms/solutions and applying enterprise architecture principles, methods, standards, tools and best practices.

7+ years of Experience leading the definition of detailed data mapping and data migration activities for large enterprise implementations.

7+ years of Experience with data transformation and data orchestration techniques

7+ years of Experience working with Microsoft Dynamics 365, including how data is managed across the Dynamics platform and in the Microsoft Cloud ecosystem

7+ years of Experience applying enterprise data architecture principles, methods, standards, tools and best practices.

7+ years of Experience as a Data Architect planning, designing, documenting and implementing enterprise data architectures for large complex cloud-based application development projects in an environment equivalent in size and complexity to the Government of Alberta.

7+ years of Experience defining data architecture for large/complex Financial enterprise solutions/systems.

7+ years of Experience developing and presenting complex data concepts, recommendations and decisions in an easy-to-understand manner to non‑technical stakeholders and senior leadership

7+ years of Experience developing conceptual, logical, and physical data models aligned with enterprise data policies including within Microsoft Dataverse.

5+ years of Experience in Agile Projects

5+ years of Experience in performing security, threat and risk assessments including defining mitigations.

7+ years of Experience leading and coaching data and project teams through large-scale implementations including data readiness, data quality, data storage.

7+ years of Experience leading and designing data migration activities for large-scale implementations from legacy application to cloud in Azure.

7+ years of Experience with data transformation and data orchestration techniques and tools, including ETL/ELT, data quality and metadata management

5+ years of Experience with enterprise business intelligence products such as Microsoft Power BI

7+ years of Experience with Microsoft tools to create a modern data warehouse (e.g. Azure Services such as Azure Data Lake Storage, Azure Synapse Analytics, and Azure Databricks, Microsoft Fabric for big data processing, analytics, and data warehousing)

5+ years of Experience working in or for the public sector.

7+ years of Experience working with implementing a SQL data warehouse.

7+ years of Experience working with Microsoft Dynamics 365, including how data is structured, stored, integrated and managed across the Dynamics platform and in the Microsoft Cloud ecosystem (Power Platform, Azure, Microsoft Fabric).

Job Description:

OPGT Public Trustee Information System Replacement

GoA’s Office of the Public Guardian and Trustee (OPGT) provides services for personal/financial matters to vulnerable Albertans. Financial services use comprehensive case management and financial systems for trust administration. This project replaces their legacy system with Microsoft Dynamics' Customer Relationship Management and Financial components.

System development is underway by an external vendor with go-live in late 2026. Agile sprint development is in place with a waterfall timeline for full release of the solution. The delivery team is supported by a GoA team (Manager, Product Owner, Change Manager/Trainer, Data Migration Team, Testers), vendor development team, and Technology and Innovation’s (T&I) technical/privacy/security teams, and business stakeholders/SMEs.

The Data Architect is critical in defining, executing and managing data architecture domain to ensure project, security, technical and strategic objectives are met. The role provides leadership and expertise across architecture design, governance, security, and modernization—ensuring alignment with GoA standards and business needs.

The role leads design/development of overarching data requirements and establishes principles, strategies, architectures, methods, models, standards and plans needed to provision data for the solution. They will establish a secure, high performing, analytics ready data architecture that supports operations, enterprise reporting and advanced analytics.

[DUTIES]: 

Responsibilities include but are not limited to:

Architecture Leadership

• Define/document data architecture (data requirements, strategies/plans, architecture, design principles, models, integration diagrams etc.)

• Lead solution architecture and design on cloud and key data platforms. Ensure alignment with business requirements

• Lead design and governance of schemas, tables, relationships, security roles and data access patterns

• Promote data models and practices to reduce redundancy

• Guide platform/infrastructure teams to configure data platform services to meet solution requirements.

• Participate in planning on implementation strategy, technology stack, design patterns and process

• Advise on configuration vs customization to support long term sustainability

• Review/approve vendor delivered data designs, strategies and implementations

• Advise and coach teams throughout project. Provide knowledge transfer

Enterprise Data Architecture

• Define end to end data architecture, including all integrated applications and systems; develop conceptual, logical and data models aligned with platform standards, enterprise data policies, including Dataverse data modeling

• Ensure architectural alignment across system modules, integrated applications, Power Platform components, Azure and downstream reporting environments

• Establish data architecture principles and standards consistent with GoA architecture frameworks

• Architect integrations between solution and external systems, including legacy platforms, document repositories, etc

• Ensure data exchanges meet security, privacy and auditability standards

• Work with Microsoft Dynamics to design how data is organized, stored, integrated and managed across Dynamics 365 ecosystem and broader Microsoft cloud environment (Power Platform, Azure, Fabric)

• Work with Microsoft Dynamics’ Finance & Operations for managing financial data

Data Migration

• Serve as GoA lead in data mapping from legacy platform to the new application, ensuring accurate lineage, transformations and alignment with new data models

• Collaborate with vendor to validate mapping logic, support build activities, and ensure mappings are technically feasible

• Work with business areas to define/confirm data rules, resolve data gaps, and ensure mappings support functional, operational, and reporting needs

• Lead data migration strategy. Define extraction, transformation, cleansing, and validation approaches aligned with business rules. Ensure data integrity, traceability, and reconciliation throughout migration activities

• Support parallel-run and cutover strategies to minimize business disruption

Data Lakehouse – Architecture & Design

• Define data warehouse/lakehouse approach and architecture and related requirements

• Define storage, archival and retrieval approach for legacy data and target data structures and storage solutions for new system data to ensure performance and long term maintainability

• Use Microsoft tools to create a modern data warehouse/lakehouse (e.g. Azure Services - Azure Data Lake Storage, Azure Synapse Analytics and Azure Databricks for big data processing, analytics, data warehousing)

Reporting

• Ensure new solution and data architecture enable effective reporting/analytics, including in solution dashboards and Power BI reports

• Define data flows into reporting platforms and downstream analytics environments

• Ensure consistency between operational and analytical data models

• Ensure architecture security, enforcing data/reports are only accessible to certain individuals/groups

• Implement anonymization, restricting access to sensitive data from certain individuals/groups

Working Hours:

• Standard Hours of work are 08:15 – 16:30 Alberta time, Monday through Friday excluding holidays observed by the Province

• Work must be done from within Canada, due to network and data security issues.

• It is anticipated the role will be 100% remote, however in the event of an onsite meeting, the GoA does not pay for travel to attend on-site meetings, nor any expenses related to relocation, commuting, housing/accommodation.

Notes on Location: 100% REMOTE