Location: Edmonton, Alberta, Canada (Remote within Canada with occasional onsite meetings)
Contract Duration: 12 Months
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.
- 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
- 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.
- 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.
- 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.
- 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.
- 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.
- Bachelor's Degree or College Diploma in Computer Science or a related field
- 8+ years designing, planning, implementing, and supporting enterprise database solutions in large, complex environments
- 8+ years working as a Data Architect designing and implementing enterprise data solutions
- 8+ years documenting and analyzing legacy database environments and as-built implementations
- 8+ years of experience with:
- Enterprise Architecture frameworks
- Architecture principles and standards
- Governance processes
- Best practices and methodologies
- 3+ years conducting threat and risk assessments and presenting mitigation strategies to senior leadership
- Demonstrated experience providing:
- Technical leadership
- Project planning
- Effort estimation
- Executive presentations
- Solution recommendations
- SQL Server
- Enterprise Data Warehousing
- Data Integration
- ETL Development
- Transact-SQL (T-SQL)
- Enterprise Reporting Solutions
- PowerDesigner
- ER/Studio
- ERwin
- BPwin
- Rational Rose
- IBM Cognos BI
- Microsoft Power BI
- SQL Server Reporting Services (SSRS)
- MicroStrategy
- Cloud Computing Platforms
- Big Data Technologies
- Modern Data Architecture Solutions
- Agile/Scrum delivery methodologies
- Application development project leadership
- 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
- 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 [email protected]
