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

• Bachelor's 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 View email address on navitasp.talentnest.com