Senior Data Architect, Enterprise Data Warehouse (Remote)

S M Software Solutions Inc; Edmonton; On-site; CAD 120,000 - 160,000; Full time

Job summary

Government of Alberta seeks a Senior Data Architect to lead enterprise data architecture for the JIMS 3.0 data integration initiative. You will shape data models, governance, and ETL design across data warehouses and marts, aligning with IMT strategies and regulatory requirements.

In this role, you will drive architecture reviews, stakeholder collaboration, and transition plans to future-state data platforms, ensuring high quality, scalable reporting and governance for court-system data assets.

Qualifications

• Experience in public-sector environments with FOIP or similar privacy considerations.
• Proven ability to perform architecture risk assessments and architecture analyses.
• Experience capturing and implementing business rules and determining data mart content.

Responsibilities

• Define and manage data architecture, including standards, models, and plans.
• Document enterprise data requirements and promote reusable data models.
• Develop and test ETL processes and data mappings for DWH projects.
• Lead data governance and quality initiatives across the program.

Skills

Data architecture

Data modeling

Data integration

ETL processes

Data governance

Data profiling

SQL / BI tooling

Power BI

Stakeholder management

Public sector know-how

Tools

SAP PowerDesigner

ERwin

Oracle Designer

SSIS

SQL Developer Data Modeler

Microsoft Visio

Job description

Government of Alberta seeks a Senior Data Architect to lead enterprise data architecture for the JIMS 3.0 data integration initiative. You will shape data models, governance, and ETL design across data warehouses and marts, aligning with IMT strategies and regulatory requirements.

In this role, you will drive architecture reviews, stakeholder collaboration, and transition plans to future-state data platforms, ensuring high quality, scalable reporting and governance for court-system data assets.