Please send your resume at [email protected] if you are interested in this 12 months (09/01/2026 to 08/31/2027) contract role. Please feel free to forward if you are not interested. This is with Govt of Alberta.

Senior Data Architect (GOAPRDJP00000995)

Work Status: Remote - May be required to attend meetings or work sessions in Alberta on reasonable notice from the Province

Work Location: 9820 - 106 ST NW, Edmonton, Alberta

Must Have: Education

- Completed training with structured Query Languages specific to Microsoft T-SQL and/or Oracle and/or PL/SQL, and database development.
- Obtained training within the past 5-10 years relating to Cloud Computing and Microsoft Azure and Azure Architecture
- Post-secondary degree or diploma in Computer Science, Information Technology, Cybersecurity, or related field (equivalent experience may be considered; formal education strongly preferred).

Must Have: Work Experience

- 2 years e xperience working in or with public-sector environments with awareness of public-sector constraints, privacy legislation (e.g., FOIP).
- 5 years demonstrated experience defining data architecture and using Kimball architecture to develop data marts.

Nice to Have: Other

- Criminal Records Check and Enhanced Security Clearance including a credit check prior to commencement.

Nice to Have: Travel/Flexible Schedule

- Able to attend onsite meetings when requested

Nice to Have: Work Experience

- 5 years experience developing using software such as SAP/Sybase's PowerDesigner, or ERWin, or Oracle Designer, or SQL Developer Data Modeler, or Microsoft Visio, etc.
- 3 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
- 2 years experience working in or with Court environments, with awareness of the importance of judicial independence.
- 1 years experience working with information management and cybersecurity policies, directives, and guidelines within limited timelines.
- 5 years strong communication skills with the ability to convey technical concepts to non-technical stakeholders and influence decision-making.

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. The following advantages 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.

Duties:





- 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

Location of Work:

- Resource(s) will primarily work remotely; however, may be required to attend meetings or work sessions in Edmonton on reasonable notice from the Province.
- Work MUST be done within Canada.

Evaluation:

- Pricing: 20%
- Resource Qualifications: 20%
- Interview Process: 60%

Submission Must Include:

- All required experience must be described in the resume under the job/project where experience was attained.
- Each job/project must contain the term of the job/project in the format mmm/yyyy to mmm/yyyy.
- Three references, for whom similar work has been performed, must be provided. The most recent reference should be listed first. Reference checks may mor may not be completed to assist with scoring the proposed resource.

📌 Senior Data Architect (GOAPR995) (Alberta)
🏢 Amyantek
📍 Alberta