Data Architect (part-time)
Back to All Jobs
[social_share]
Our client requires a part-time Data Architect to join the client’s Justice Information Management System (JIMS) 3.0 project, a data integration project aimed to amalgamate, re-design and implement several disjointed reporting data marts containing court data into an Enterprise Data Warehouse (EDW) and a set of dependent data mart and views. This project will replace the existing six stand-alone IBM Cognos BI data marts JIMS, Crown File Ownership (CFO), Court Case Management (CCM), Courtroom Utilization, Courtroom Activity, and Case Adjournment) with a well-integrated data warehouse. The existing data marts extract, process, re-structure and aggregate data required for strategic, operational and ad hoc reporting of court data stored in the Justice Online Information Network (JOIN) database. The goal of the project is to evolve availability, governance and reporting of court data by implementing a more efficient, user-friendly, faster and cost-effective reporting architecture.
The Data Architect will review existing data marts, perform detailed data profiling, analyze and create design and mapping specifications, identify Dimensions required for Facts, and complete detailed data profiling of tables included in Facts. The Data Architect will then develop and test Extract Transform Load (ETL) processes, develop Power BI reports for testing for several Dimensions, test Dimensions and Fact for quality assurance, update JOIN as-is data models for new Fact attributes, stage the required data, address minor fixes in delivered data marts, and provide feedback and lessons learned at project close out.
The role is part-time, with an estimated 3.63 hours/day and an estimated 18.13 hrs/week.
Resource will work remotely but must be available to be on-site when requested for meetings. Work must be done from within Canada, due to network and data security issues. Resource is responsible to pay for travel to on-site meetings.
Edmonton, Alberta (Remote within Canada)
Mandatory Requirements
- College or Bachelor degree in Computer Science or a related field of study.
- 8 years’ experience designing, planning, implementing and supporting enterprise solution databases in a large and complex environment.
- 8 years’ experience documenting enterprise solution databases in a large and complex environment.
- 3 years’ experience in performing threat and risk assessments and presenting recommendations for risk mitigation to senior management.
- 8 years’ experience with enterprise architecture principles and associated best practices, methods, standards, tools, policies, and processes.
- Experience providing leadership, planning, estimating, and presentations of ideas and solutions.
Desirable Requirements
- Certification in The Open Group Architecture Framework (TOGAF).
- 5 years’ 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 and complex enterprise IT environment.
- 2 years’ experience in using a tool for architecture models such as: PowerDesigner, ER Studio, Er-win, BPwin, Rational Rose.
- 3 years’ experience project managing application development projects using Agile sprint development.
- 5 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) or MicroStrategy.
- 5 years’ experience working as a Data Architect in a large and complex enterprise IT environment.
- 5 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.
- Ability to learn quickly, problem solve/troubleshoot, work independently and in a team.
- Ability to manage conflict.
- Ability to manage stress.
- Ability to work with minimum mentoring.
- Excellent verbal and written communication skills and ability to interact and collaborate professionally with a diverse group.
Job Posting ID: 56881
Location: Edmonton, Alberta (Remote within Canada)
Estimated Starting Date: Jul 1, 2026
Estimated End Date: till Jun 30, 2027 + up to 24-months pos. extension
Posting Closing Date: June 15, 2026
Apply for this Job Posting
Fill in the form below to submit your application for this position.