Remote Senior Data Architect for JIMS 3.0 EDW

SereneAID; Edmonton; On-site; CAD 110,000 - 150,000; Full time

Job summary

Government of Alberta – Justice is embarking on JIMS 3.0, a major data modernization effort delivering an integrated EDW and reporting views. The Senior Data Architect will lead data architecture efforts, align with privacy and cybersecurity standards, and collaborate with enterprise teams to craft robust data models and governance across multiple data marts.

The role requires strong experience in data modeling, ETL/ELT with SSIS, and stakeholder communication to translate complex requirements

Qualifications

• 5+ years of experience in data architecture and enterprise data warehouse projects.
• Experience with data modeling, data governance, and data quality.
• Experience with ETL/ELT, SSIS, SQL Server or similar platforms.
• Ability to translate business requirements into data models.
• Strong communication with non-technical stakeholders.

Responsibilities

• Provide data architecture analysis, risk assessments, and leadership for JIMS 3.0.
• Define data structures, business rules, and data models for EDW and data marts.
• Ensure alignment with GA EAA and privacy and cybersecurity policies.
• Collaborate with enterprise architects, technical teams, and stakeholders.
• Develop transition plans from current to future-state architectures.
• Support testing and validation of data marts and reporting views.

Skills

Data architecture

Risk assessments

Business rules

Data modeling

ETL/ELT

Data profiling

JOIN/JIMS data

Education

Computer Science/IT/Cybersecurity/Data/Engineering

Equivalent experience considered

Tools

SSIS

SQL Server

BI tooling (SSRS/Power BI)

Job description

Government of Alberta – Justice is embarking on JIMS 3.0, a major data modernization effort delivering an integrated EDW and reporting views. The Senior Data Architect will lead data architecture efforts, align with privacy and cybersecurity standards, and collaborate with enterprise teams to craft robust data models and governance across multiple data marts.

The role requires strong experience in data modeling, ETL/ELT with SSIS, and stakeholder communication to translate complex requirements