Data Engineer Senior (Remote)

Senior Data Architect

Government of Alberta – Justice

Project: Justice Information Management System (JIMS 3.0)

Role: Senior Data Architect

Primarily Remote within Canada; Contract: The Government of Alberta – Justice is seeking a Senior Data Architect to support the JIMS 3.0 (Justice Information Management System) initiative.

JIMS 3.0 is a data integration and modernization project focused on consolidating multiple court-data reporting marts into an integrated Enterprise Data Warehouse (EDW) and associated data marts and reporting views.

The Senior Data Architect will provide architecture leadership, conduct architecture risk assessments and analysis, define data structures and business rules, and support the design and implementation of data marts. The resource will work closely with enterprise architects, technical teams, business stakeholders, and Justice representatives to ensure that data architecture aligns with Government of Alberta standards, privacy requirements, cybersecurity policies, and business objectives.

Data Architecture & Analysis

Provide data architecture analysis, assessment, and risk assessments for JIMS 3.0.
Define and document data architecture principles, standards, models, guidelines, and strategies.
Analyze current-state data architecture and develop target-state architecture.
Identify architecture risks, dependencies, gaps, and opportunities for improvement.
Develop transition plans from current-state to future-state data architecture.
Provide architecture guidance and recommendations to project teams.
Data Mart & Data Warehouse Architecture

Determine appropriate data mart content and data structures based on business and reporting requirements.
Design and develop conceptual, logical, and physical data models.
Define Facts, Dimensions, attributes, measures, relationships, and data structures .
Apply dimensional modeling and data warehouse best practices.
Analyze existing reporting data marts and recommend improvements.
Promote data reuse, standardization, sharing, and reduction of data redundancy.
Support the integration of multiple existing data marts into the JIMS 3.0 EDW.
Business Rules & Data Requirements

Identify and document enterprise data requirements.
Translate business requirements into technical data structures.
Work with stakeholders to validate data definitions and business rules.
Ensure data models accurately represent business and judicial processes.
Data Profiling & Quality

Perform detailed data profiling and analysis .
Assess data quality, completeness, consistency, and integrity.
Identify data gaps, anomalies, duplication, and inconsistencies.
Establish practices that improve data quality and governance.
Support testing and validation of data marts and data warehouse structures.
Data Integration & ETL

Work with SQL Server Integration Services (SSIS) and related data integration technologies.
Define source-to-target mappings and transformation rules.
Support data staging, extraction, transformation, and loading.
Analyze and troubleshoot integration and data-processing issues.
SQL Server & Reporting

Work with SQL Server database technologies and data structures.
Support SQL Server Reporting Services (SSRS) environments where required.
Analyze database structures and reporting requirements.
Support Power BI and other BI/reporting solutions as needed.
Validate reporting data against business requirements.
Analyze JOIN (Justice Online Information Network) data and structures.
Work with JIMS (Justice Information Management System) data and data structures.
Support the development and modernization of court-data reporting structures.
Update and enhance existing data models where required.
Ensure data architecture complies with Government of Alberta policies and standards.
Apply knowledge of FOIP/privacy legislation and public-sector requirements.
Work within information-management and cybersecurity policies, directives, and guidelines.
Identify and mitigate data architecture and security risks.
Support secure and governed handling of Justice data.
Communicate complex technical concepts to non-technical stakeholders .
Provide advice and recommendations to business and technical teams.
Influence decision-making through clear technical analysis.
Collaborate with enterprise architects, developers, data engineers, business analysts, and Justice stakeholders.
Prepare architecture documentation and technical deliverables.
Computer Science
Information Technology
Cybersecurity
Data/Computer Engineering
Architecture risk assessments
Architecture analysis and assessments
Business rule analysis and implementation
Determining data mart content
Defining data structures
Data architecture and solution design
2+ years of experience working in or with public-sector environments , including awareness of:

Public-sector constraints
Database & Reporting Training

Training in Database Administration
Training in SQL Server Reporting Services (SSRS)
Training in SQL Server Integration Services (SSIS)
Data Warehousing Certification

Certification or formal training in data warehousing, such as:

TDWI Certified Business Intelligence Professional (CBIP)
CFI Business Intelligence & Data Analyst (BIDA)
Kimball Group Data Warehouse training
Equivalent data warehousing certification/training
Data Modeling Tools – 5+ Years

SAP/Sybase PowerDesigner
Oracle Designer
SQL Developer Data Modeler
Microsoft Visio
Similar enterprise data-modeling tools
JOIN data and structures
JIMS data and structures
Court-data reporting environments
Court data
Information Management & Cybersecurity – 1+ Year

Information-management policies
Cybersecurity policies
Explain technical concepts to non-technical stakeholders.
Present technical recommendations.
Influence business and technical decisions.
Produce clear architecture and technical documentation.