Job description:
Our client, the government of Alberta, has an immediate requirement for one (1) Senior Data Architect - primarily remote. The successful sub-contractor(s) will start in September for an twelve (12) month contract. There is a possible 24 month extension available.
NOTES ON LOCATION:
Primarily Remote
We will pay the successful candidate(s) $115 per hour for an independent sub-contractor.
If you meet ALL of the mandatory requirements and would like to be submitted, please email your resume and we will contact you to discuss in more detail. We thank all candidates for applying, however only those candidates whom we feel meet all the mandatory requirements will be contacted.
Location: Primarily remote
4TH FL - OXBRIDGE PLACE (BEDOXB5984)
Work Location:
9820 - 106 ST NW
Edmonton
Alberta
CAN
T5K 2J6
Business Unit
Justice (CA14)
Category
IT Job Posting
Labor Type
Technical
Positions Requested
1
Respond by Date
2026-08-24
Travel Time
0.000 %
Time Sheet Type
Standard
Time Sheet Frequency
Monthly
Start Day of Week
First day of the month
Hours per Day
7.25
Hours per Week
36.25
Total Hours
1,805.25
Estimated Additional Spend
0.000 %
Estimated Expenses
0.000 %
Flat Adjustments
0.00
Description:
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 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.
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
Facilities and Equipment:
- Resource(s) shall be responsible for providing all of their equipment, including computers, software, printers, supplies, desks and chairs. The computer's OS must be a modern version of Windows or MacOS compatible with Azure Virtual Desktop (AVD) and related software for remote access. Windows is preferred due to better compatibility. AVD/remote-related software will be installed on the resource's computer. The Province shall ensure that resource(s) have the necessary access and credentials to the GoA system.
- In the event that resource(s) are directed to work in-person, the Province shall provide the requisite office space, furniture and office supplies. However, the resource(s) shall continue to be responsible for providing computers and software and the Province shall continue to ensure that resource(s) have the necessary access and credentials to the GoA system.
- The virtual meeting tool for the Province is Microsoft Teams. Zoom may sometimes be used when needed, however, Zoom accounts are not provided by the Province.
- The fixed rate quoted must be inclusive of all overhead, office space and equipment, including supplies, administrative burden, mark-up and all other costs to perform the Services for the duration of the Contract.
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. At the time of providing such notice, the Province will advise of the expected duration of any such meetings or work sessions. However, time to travel and any associated expenses to and from Edmonton will be at no cost to the Province. Onsite meetings will be approximately 15% of total hours.
- The Province reserves the right to alter this work arrangement on reasonable notice to the resource(s). The Supplier(s) and the resource(s) will be consulted about the alteration in work arrangement; however, the Province retains ultimate discretion as to the appropriate work arrangement.
- Work MUST be done within Canada.
Criminal Records Checks:
- The Supplier shall, at no cost to the Province, provide a criminal record check. A candidate may be rejected if, in the opinion of the Province, the criminal record is unacceptable.
- Should a candidate be assigned to a team working for Justice, prior to performing services, the candidate must provide the Province with an Enhanced Security Clearance. A candidate may be rejected if, in the opinion of the Province, the Enhanced Security Clearance or equivalent is unacceptable. The Province does not receive any information specific to the reason an Enhanced Security Clearance may be rejected. Participating law enforcement agencies only identify if an applicant’s clearance is not accepted.
- Candidate(s) should be aware that over the course of the WO, resource(s) may be required to complete higher-level security clearances, such as the Royal Canadian Mounted Police Top Secret Clearance. Please ensure applicants are eligible to apply if required by the ministry.
- Acceptance by the Province of all candidate(s) requires written approval from the Province following acceptable security clearances.
Evaluation:
The evaluation criteria will be distributed within the following categories. Subject to the requirements of Protection of Privacy Act (POPA) and Access to Information Act (ATIA), the evaluation of Responses shall be confidential, and not released to any party.
Pricing: 20%
Resource Qualifications: 20%
Interview Process: 60%
Incumbency:
Anticipated Interviews Dates:
- Interviews are expected to happen approximately 2 weeks after the posting closes.
Mandatory Training Courses:
- Once hired the resource will be required to complete all mandatory training which includes, but not limited to, Protection of Privacy Act (POPA) and Access to Information Act (ATIA), Security/Cybersecurity, Information Management, and Respect in the Workplace. There may also be other mandatory and/or optional training.
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.
Must Have
Attestation
Yes/No - Attestation - Conflict of Interest
Yes
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).
Work Experience
Demonstrated experience defining data architecture and using Kimball architecture to develop data marts. Must have 5 years
Experience working in or with public-sector environments with awareness of public-sector constraints, privacy legislation (e.g., FOIP). Must have 2 years
Proposed resource has agreed to a Criminal Records Check and Enhanced Security Clearance including a credit check prior to commencement.
Per the job description, is the job seeker able to attend onsite meetings when requested?
Nice to Have (Bonus points awarded for meeting or exceeding)
Experience developing using software such as SAP/Sybase's PowerDesigner, or ERWin, or Oracle Designer, or SQL Developer Data Modeler, or Microsoft Visio, etc.
Minimum 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
Minimum 3 years
Experience working in or with Court environments, with awareness of the importance of judicial independence.
Minimum 2 years
Experience working with information management and cybersecurity policies, directives, and guidelines within limited timelines.
Minimum 1 year
Strong communication skills with the ability to convey technical concepts to non-technical stakeholders and influence decision-making.
Minimum 5 years
Maximum Extension Term (Months): 24
Pay: $115.00 per hour
Benefits:
Ability to commute/relocate:
- Edmonton, AB: reliably commute or plan to relocate before starting work (required)
Education:
- Bachelor's Degree (preferred)
Experience:
- defining data architecture and using Kimball architecture : 5 years (required)
- develop data marts: 5 years (required)
- working in or with public-sector environments : 2 years (required)
- awareness of privacy legislation (e.g., FOIP).: 2 years (required)
- using software such as SAP/Sybase's PowerDesigner, or ERWin: 5 years (preferred)
- working in or with Court environments: 2 years (preferred)
- information management and cybersecurity policies: 1 year (preferred)
Work Location: Hybrid remote in Edmonton, AB
