Project Name:
JIMS 3.0 (Justice Information Management System)

Scope:
The Data Unit requires the support of contingent labour to support a data integration project aimed to re-design and implement several reporting data marts, with conformed dimensions, containing court data into an Enterprise Data Warehouse (EDW) and a set of dependent views.

The position will be responsible for performing technical strategic functions, ensuring the architecture supports Justice data analytics and reporting needs.

Additionally, this role may support application of the Data Fabric architecture, data quality, data standards, and best practices to development as needed.

The successful candidate is expected to have a broad skill set and be capable of performing diverse functions and activities, including but not limited to:
• Understanding of data warehouse design principles, including dimensional modeling, star schemas, snowflake schemas, and the use of conformed dimensions to ensure consistency across data marts.
• Review both logical and physical data models that efficiently store data and support business processes.
• Support the development and adoption of best practices for data management, integration and common data management, and standardized methodologies.
• Contribute to development of individual data architectures, testing and data quality practices, as needed, to support business objectives.
• Work with datasets using ETL (Extract, Transform, Load) tools and techniques for integrating data from various sources into the EDW.
• Interact with clients/partners (GOA-internal and/or external).

Duties:
• A Quality Assurance Automation Developer designs and implements test automation to ensure service quality with a focus on iterative, continuous development, where requirements and solutions evolve through collaboration between Agile Teams and users.
• Works collaboratively in Agile Teams to improve services.
• Participates in project activities, including field work and user research.
• Works with Agile Teams and stakeholders to understand problems and leads the quality delivery piece of the solution.
• Participates in creating and prioritizing a backlog of work, estimates effort, and commits to scope of work for predictable delivery of features.
• Identify opportunities for process improvement within the data integration and quality assurance lifecycle, recommending and implementing solutions to enhance efficiency and effectiveness.
• Identifies quality related tasks for a backlog of work such as test case creation, system testing, and performance testing.
• Works with product owners to design test plans and strategies with a focus on automation to facilitate a continuous delivery approach.
• Develops automated tests and frameworks to support integration testing, system testing, acceptance testing, and performance testing.
• Works closely with Full Stack Developers to establish a high standard of quality across the Agile Team through quality metrics and best practices.
• Seeks out defects, investigates root causes, and supports informed categorization and triage of defects.
• Proactively identify opportunities for process improvement within the data integration and quality assurance lifecycle, recommending and implementing solutions to enhance efficiency and effectiveness.
• Other responsibilities as required or requested.

Equipment requirements:
• Resource will require own equipment.

Resource must provide their own computer and related equipment. The computer's operating system must be a modern version of Windows or MacOS that is 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.

In the event that the Contractor’s resources are directed to work remotely, the Contractor shall be responsible for providing all of its equipment, including computers, software, printers, supplies, desks and chairs. However, the Province shall ensure that the Contractor’s resources have the necessary access and credentials to the Government of Alberta’s system.

In the event that, the Contractor’s resources are directed to work in-person, the Province shall provide the requisite office space, furniture and office supplies. However, the Contractor shall continue to be responsible for providing computers and software and the Province shall continue to ensure that the Contractor’s resources have the necessary access and credentials to the Government of Alberta’s system.

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.

Working Hours:
• Standard Hours of work are 08:15 – 16:30 Alberta time, Monday through Friday excluding holidays observed by the Province
• Work must be done from within Canada, due to network and data security issues.
• The role will be remote, however in the event of an onsite meeting, the GoA does not pay for travel to attend on-site meetings, nor any expenses related to relocation, commuting, housing/accommodation, food/drink.

Notes on Location:
Resource will work remotely, though must be available for onsite meetings when required.

Onsite meetings include but are not limited to strategic, architectural, and technical discussions, meeting with team members, senior managers, directors, executive directors and business clients. Frequency of meeting could be up to once every 3-4 months.

Incumbency:
• Previously this role was filled by a contractor, however, for this and all other opportunities, the Ministry seeks the best person to fill the role.


Enhanced Background check required
• A standard criminal record check will be required before we start the Enhanced Security Clearance process.
• An Enhanced Security Clearance will be required for this position, which will be coordinated by GoA only for this position.

Mandatory Training Courses:
• Once hired the resource will be required to complete all mandatory training which includes but not limited to Freedom of Information and Protection of Privacy Act and Security awareness training. There may also be some optional courses as well.

Anticipated Interviews dates
• will be held between June 20- June 23
Refer to the Job Posting attachments for the proposed form of contract applicable to this Contingent Resource Request

Scoring Methodology:
Financial/Pricing: 10%
Resource Qualifications: 20%
Interview Process: 70%

SUBMISSION MUST INCLUDE:
• RESUME
• ALL REQUIRED EXPERIENCE MUST BE DESCRIBED IN 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.
• RESOURCE REFERENCES
Three references, for whom similar work has been performed, must be provided. The most recent reference should be listed first. Reference checks may or may not be completed to assist with scoring of the proposed resource.