Senior Data Architect 26-06910

Job Title: Senior Data Architect

Location: Edmonton Alberta Canada (Remote within Canada with occasional onsite meetings)
Contract Duration: 12 Months

Project Overview

The Senior Data Architect will support a large-scale Justice Information Management modernization initiative focused on consolidating multiple court-reporting data marts into a centralized Enterprise Data Warehouse (EDW). The project aims to improve data governance reporting efficiency historical data preservation and enterprise-wide access to court-related information.

The successful candidate will play a key role in data architecture data modeling ETL development data integration warehouse design and business intelligence reporting while supporting enterprise architecture standards and best practices.

Work Arrangement

• Primarily Remote (Work must be performed within Canada)
• Approximately 15% onsite attendance in Edmonton Alberta may be required
• Travel expenses are not reimbursable
• Candidate must provide their own computer software and office equipment
• Microsoft Teams utilized for collaboration and meetings

Key Responsibilities

Data Architecture & Strategy

• Define and manage enterprise data architecture principles standards frameworks and strategies.
• Design scalable enterprise data warehouse and data mart solutions.
• Develop future-state data architecture roadmaps and transition plans.
• Promote data governance data quality and data-sharing best practices.
• Identify and document enterprise data requirements.

Data Warehouse & Data Modeling

• Review and analyze existing legacy data marts.
• Perform detailed data profiling and source system analysis.
• Create conceptual logical and physical data models.
• Design dimensions facts and data mappings for enterprise reporting solutions.
• Update existing data models to support new business requirements.
• Develop enterprise database architecture documentation.

ETL & Data Integration

• Design develop and test ETL processes.
• Stage and transform source data into enterprise warehouse structures.
• Develop mapping specifications and transformation rules.
• Support data migration and integration activities.
• Perform quality assurance testing for facts and dimensions.

Business Intelligence & Reporting

• Support development and validation of reporting solutions.
• Create Power BI reports for testing and validation purposes.
• Support enterprise reporting architecture initiatives.
• Ensure reporting performance accuracy and usability.

Architecture Governance & Leadership

• Participate in architecture reviews and design governance processes.
• Provide guidance to project teams on architecture compliance.
• Present recommendations designs and risk mitigation strategies to leadership.
• Mentor project teams on enterprise architecture standards and methodologies.

Required Qualifications

Education

• Bachelors Degree or College Diploma in Computer Science or a related field

Mandatory Experience

Enterprise Database Architecture

• 8 years designing planning implementing and supporting enterprise database solutions in large complex environments

Data Architecture

• 8 years working as a Data Architect designing and implementing enterprise data solutions

Legacy System Documentation

• 8 years documenting and analyzing legacy database environments and as-built implementations

Enterprise Architecture

• 8 years of experience with:
  • Enterprise Architecture frameworks
  • Architecture principles and standards
  • Governance processes
  • Best practices and methodologies

Risk Management

• 3 years conducting threat and risk assessments and presenting mitigation strategies to senior leadership

Leadership

• Demonstrated experience providing:
  • Technical leadership
  • Project planning
  • Effort estimation
  • Executive presentations
  • Solution recommendations

Preferred Qualifications

Certifications

• TOGAF Certification

Data Warehouse & Database Technologies

• SQL Server
• Enterprise Data Warehousing
• Data Integration
• ETL Development
• Transact-SQL (T-SQL)
• Enterprise Reporting Solutions

Architecture Modeling Tools

• PowerDesigner
• ER/Studio
• ERwin
• BPwin
• Rational Rose

Business Intelligence Platforms

• IBM Cognos BI
• Microsoft Power BI
• SQL Server Reporting Services (SSRS)
• MicroStrategy

Cloud & Modern Data Platforms

• Cloud Computing Platforms
• Big Data Technologies
• Modern Data Architecture Solutions

Agile Project Experience

• Agile/Scrum delivery methodologies
• Application development project leadership

Desired Skills

• Enterprise Data Modeling
• Data Governance
• Data Quality Management
• Data Integration Architecture
• Analytical and Problem-Solving Skills
• Strong Documentation Skills
• Stakeholder Management
• Conflict Resolution
• Independent and Team-Based Work
• Excellent Written and Verbal Communication

Security & Compliance Requirements

• Criminal Record Check Required
• Enhanced Security Clearance may be required
• Eligibility for higher-level government security clearances is preferred
• Completion of mandatory privacy security information management and workplace training required upon onboarding

For more details reach at