Job Posting Details

Data Architect

Back to All Jobs
[social_share]

Our client requires a Data Architect to join the Justice Information Management System (JIMS) 3.0, which 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.

Resource must be able to Criminal Records Check and Enhanced Security Clearance.

Resource will work remotely but must be available to be on-site when requested for meetings. Standard Hours of work are 08:15 – 16:30 Alberta time. 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)

Responsibilities

• 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.

Mandatory Requirements

• Post-secondary degree or diploma in Computer Science, Information Technology, Cybersecurity, or related field (equivalent experience may be considered; formal education strongly preferred).
• 5 years demonstrated experience defining data architecture and using Kimball architecture to develop data marts.
• 2 years’ experience working in or with public-sector environments with awareness of public-sector constraints, privacy legislation (e.g., FOIP).
• 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
• Must be able to pass a Criminal Records Check and Enhanced Security Check

Desirable Requirements

• 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 year 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.

Job Posting ID: 57008

Location: Edmonton, Alberta (Remote within Canada)

Estimated Starting Date: Sep 1, 2026

Estimated End Date: till Aug 31, 2027 + 2 pos. 1-year extensions

Posting Closing Date: August 24, 2026

Back to All Jobs

Apply for this Job Posting