Lead enterprise data architecture and modeling to consolidate legacy court reporting marts into a centralized EDW. Design data models, ETL processes, data governance, and Power BI reporting. Provide architecture alignment with GAEA, conduct risk assessments, mentor teams, and support migration and implementation activities.
This is a remote position.
Role Overview
This is a Senior Data Architect engagement for the client Justice Information Management System (JIMS) 3.0 initiative. The project focuses on consolidating multiple legacy court-reporting data marts into a centralized Enterprise Data Warehouse (EDW) with modern reporting and analytics capabilities.
The architect will lead data architecture, data modeling, ETL design, data warehouse implementation, data governance, reporting enablement, and enterprise architecture alignment.
Key Responsibilities
Data Architecture & Modeling
- Review existing JIMS, CFO, CCM, Courtroom Utilization, Courtroom Activity, and Case Adjournment data marts.
- Perform detailed data profiling and source system analysis.
- Design Enterprise Data Warehouse architecture.
- Create conceptual, logical, and physical data models.
- Define Facts and Dimensions for star/snowflake schemas.
- Develop data mapping specifications.
- Update JOIN source system data models.
- Develop transition plans from current to future-state architecture.
Data Warehouse Development
- Design and implement SQL-based data warehouse solutions.
- Stage and transform source data.
- Develop ETL processes.
- Validate data quality and integrity.
- Support data mart enhancements and fixes.
Reporting & Analytics
- Develop Power BI reports for testing and validation.
- Support enterprise reporting architecture.
- Improve reporting performance and governance.
- Enable historical data preservation and self-service reporting.
Enterprise Architecture
- Define data architecture standards, principles, and governance.
- Conduct architecture reviews.
- Align solutions with Government of Alberta Enterprise Architecture (GAEA).
- Promote data quality and data-sharing practices.
- Provide architectural guidance across projects.
Leadership
- Lead design sessions and architecture reviews.
- Present recommendations and solution options.
- Mentor project teams.
- Participate in project planning and estimation activities.
Requirements
Mandatory Requirements
- Enterprise solution design, planning, implementation, and support - 8+ Years
- Enterprise database architecture documentation - 8+ Years
- Enterprise architecture principles and best practices - 8+ Years
- Threat and Risk Assessments (TRA)- 3+ Years
- Leadership, planning, estimation, presentations Required
- Bachelor's Degree or College Diploma in Computer Science or related field - Required
Nice-to-Have Requirements
- Enterprise architecture database plans/models - 5+ Years
- Power Designer, ER Studio, ERwin, or similar tools - 2+ Years
- Agile Project Management - 3+ Years
- Cloud Computing / Big Data Platforms - 5+ Years
- BI & Performance Management Tools - 5+ Years
- Data Architect in Enterprise Environment - 5+ Years
- SQL Database Development - 5+ Years
- SQL Data Warehouse Implementation - 5+ Years
- Transact-SQL (T-SQL) - 5+ Years
- TOGAF Certification - Preferred
Similar Jobs
Software
As a Data Architect, you will architect data solutions, ensure data integrity, collaborate with stakeholders, and mentor junior team members, driving data value and management strategies.
Top Skills:
AIApache NifiAWSAzureDatabricksFivetranGCPHadoopHdfsHiveInformaticaJavaMlNoSQLPower BIPysparkPythonScalaSnowflakeSparkSQLStormTableauTalend
Software
Design and deliver enterprise-scale EDW and BI solutions, ensuring performance and scalability, while mentoring teams and engaging stakeholders.
Top Skills:
.Net C#Amazon RedshiftAws GlueDatastageEltETLInformaticaJavaMicrosoft Sql ServerPower BIPythonSsisTableau
Consulting
Lead strategic architecture for front-office investment technology and data solutions, advising on platform selection and implementation (Aladdin, Charles River, Bloomberg, etc.), guiding data architecture, governance and quality, managing small-to-medium implementation teams, and ensuring delivery across portfolio management, trading, and reporting domains.
Top Skills:
AWSBlackrock AladdinBloomberg AimCharles River ImsData GovernanceData ModellingData Quality ManagementDatabase ManagementDatabricksFis Front ArenaMarkit ThinkfolioSnowflakeSQL
What you need to know about the Ottawa Tech Scene
The capital city of Canada and the nation's fourth-largest urban area, Ottawa has proven a rapidly growing global tech hub. With over 1,800 tech companies, many of which are leaders in their sectors, the city's tech talent now makes up more than 13 percent of its total workforce. This growth is driven not only by the big players like UL Solutions and Dropbox, but also by a thriving startup ecosystem, as new businesses emerge to follow in the footsteps of those that came before them.
