Senior Data Architect (Part-Time)

Tri-global Solutions Group Inc.; Edmonton; Hybrid; CAD 83,000 - 152,000; Part time

Job summary

Tri-global Solutions Group Inc. is seeking a Senior Data Architect to join the Service Delivery team for the JIMS 3.0 project. The role is part-time (0.5) with remote work primarily, within Canada, and a 12-month term with potential extension.

You will lead data architecture activities across data marts, EDW, and reporting layers. Responsibilities include profiling, design mapping, ETL development, and Power BI reporting for multiple dimensions.

Qualifications

• Post-secondary degree or diploma in Computer Science, IT, Cybersecurity, or related field.
• Experience in public-sector environments with awareness of privacy legislation (2+ years).
• Proven experience in architecture risk assessments and data mart content determination (5+ years).

Responsibilities

• Review existing data marts and profiling results.
• Analyze and design mapping specifications and data structures.
• Develop and test ETL processes for data integration.
• Develop Power BI reports for testing dimensions.
• Address data quality issues in data marts and provide feedback at closeout.

Skills

Public-sector experience

Architecture risk assessments

Data architecture

Data modeling

Education

Post-secondary degree or diploma in Computer Science / Information Technology / Cybersecurity

Tools

SSRS

Power BI

ER/Data modeling tools

Job description

SENIOR DATA ARCHITECT (JIMS 3.0) – PART-TIME (0.5) ROLE

Requisition #: R26-3575 (GOAPRDJP00000994)

Location: Primarily Remote (within Canada – See Work Model below)

Engagement Type: Contract

Number of Resources required: 1

Rate (CAD): Up to $110.00 per hour / Commensurate with related experience and market competitiveness

Term: 12-months (2026-09-01 to 2027-08-31) with 24-month extension available (up to 36-month contract)

Hours per day: 3.63 (Part-time role – 50%)

Security Screening: Enhanced Security Clearance (including credit check)

Tri-global Solutions Group Inc. is seeking one (1) Senior Data Architect (JIMS 3.0 – Part-Time) to join our Service Delivery team with the Ministry of Justice (Government of Alberta).

WORK MODEL: The successful candidate(s) will be working primarily remotely; however, may be required to attend meetings or work sessions in Edmonton on reasonable notice from the Province. At the time of providing such notice, the Province will advise of the expected duration of any such meetings or work sessions. Onsite meetings may be approximately 15% of total hours. Work must be done from within Canada, due to network and data security policies. Standard Hours of work are 08:15 – 16:30 Alberta time. Any travel will be at the contractor’s own expense and at no cost to the Province.

PROJECT OVERVIEW

Project Name: JIMS 3.0 (Justice Information Management System)

Scope: Justice Information Management System (JIMS) 3.0 is 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.

Benefits will be realized through the project:

• Integrated and dynamic architecture
• Interactive reporting
• Reporting lag
• Preservation of historical data
• Improved data governance

This Senior Data Architect role will:

• review existing data marts,
• perform detailed data profiling,
• analyze and create design and mapping specifications,
• identify Dimensions required for Facts,
• complete detailed data profiling of tables included in Facts,
• develop and test Extract Transform Load (ETL) processes,
• develop Power BI reports for testing for several Dimensions,
• testing of 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,provide feedback and lessons learned at project close out.

DESCRIPTION OF SERVICES

• Facilitate the effective definition and management of the data architecture (e.g. principles, strategies, architectures, methods, design principles, models, standards, guidelines, plans, etc.);
• Encourage data models and practices that reduce data redundancy by promoting reuse/sharing (in keeping with the IMT strategy);
• Identify and document enterprise data requirements;
• Encourage practices that improve data quality;
• Develop and lead the transition plans that will guide current data to its “ideal future state”.
• Lead or assist in communication activities surrounding the Sectors and Government of Alberta Enterprise Architecture (GAEA) data architecture;
• Contribute to the definition and development of the enterprise architecture framework, and associated corporate solution design and delivery methods, thus improving the “proactive alignment” of data architecture;
• Respond to requests for extensions to the scope of the data architecture;
• Provide information, advice, guidance, and consultancy to initiatives/projects that are defining or aligning to the data architecture – thus promoting compliance to the data architecture and IMT strategies;
• Establish and participate in design reviews, regular or ad‑hoc architectural reviews – ensuring correct interpretation of the data architecture, and IMT strategies; and
• Provide support to other members of the enterprise architecture team as required

MANDATORY SKILLS

• Post‑secondary degree or diploma in Computer Science, Information Technology, Cybersecurity, or related field (equivalent experience may be considered; formal education strongly preferred). (Yes or No)
• Experience working in or with public‑sector environments with awareness of public‑sector constraints, privacy legislation (e.g., FOIP). (2 years+)
• Proven experience providing architecture risk assessments AND, providing architecture analysis/assessment, AND capturing and implementing business rules, AND determining data mart content, data structures. (5 years+)

DESIRABLE / NICE TO HAVE SKILLS

• Completed training in database administration. (Yes or No)
• Completed training in SQL Server reporting services (SSRS). (Yes or No)
• Proposed resource has agreed to a Criminal Records Check and Enhanced Security Clearance including a credit check prior to commencement. (Yes or No)
• Data Warehousing certifications with one of the following: TDWI’s Certified Business Intelligence Professional (CBIP), or CFI’s Business Intelligence and Data Analyst (BIDA), Etc., or Completion of “Kimball Group” Data Warehouse training. (Yes or No)
• Per the job description, is the job seeker able to attend onsite meetings (in Edmonton, Alberta) when requested. (Yes or No)
• Experience developing using software such as SAP/Sybase’s PowerDesigner, or ERWin, or Oracle Designer, or SQL Developer Data Modeler, or Microsoft Visio, etc. (5 years+)
• Experience using JOIN (Justice Online Information Network) and JIMS (Justice Information Management System) data and data structures, and knowledge of business rules based on Judicial processes. (3 years+)
• Experience working in or with Court environments, with awareness of the importance of judicial independence. (2 years+)
• Experience working with information management and cybersecurity policies, directives, and guidelines within limited timelines. (1 year+)
• Strong communication skills with the ability to convey technical concepts to non‑technical stakeholders and influence decision‑making. (5 years+)
• Completed training specific to SQL Server Integration Services (SSIS). (Yes or No)

NOT FOR YOU?

We thank all candidates in advance. Only candidates selected for an interview will be contacted.

WHY WORK WITH TRI-GLOBAL?

• Empower positive change by enabling our clients to revolutionize innovation and technology, elevating them to a higher level of excellence and efficiency.
• Join an exceptional and committed team that redefines the landscape, forging a distinctive path towards success.
• Engage in stimulating and captivating projects that push boundaries and keep you constantly motivated.