Senior Data Architect (Data Architect Senior) - Build the Blueprint for a Modern Justice Data WarehouseOverviewOur Client is seeking a Senior Data Architect to evolve an Enterprise Data Warehouse and its dependent data marts and views, bringing multiple disconnected reporting marts into a single, well-integrated architecture. You'll dig into existing data marts, profile and map complex datasets, shape dimensional models, and help ensure high-quality, trusted data products that support strategic, operational, and ad hoc reporting. The work is primarily remote, with occasional onsite sessions in Edmonton as needed, and all work must be completed within Canada due to security requirements.Advantages & PerksMostly remote work with onsite meetings/work sessions in Edmonton on reasonable notice (approximately 15% onsite)Work on an enterprise-scale data integration and modernization program with meaningful, public-facing impactOpportunity to influence standards, governance, quality practices, and future-state architectureClear expectations around required tools and access via Azure Virtual Desktop (your equipment required)ResponsibilitiesReview existing reporting data marts and contribute to their redesign into an Enterprise Data Warehouse ecosystemPerform detailed data profiling and analysis to understand source structures, quality, and relationshipsCreate design and mapping specifications to support implementation and long-term maintainabilityDefine Facts and Dimensions,



including identifying required Dimensions for Facts and profiling Fact-related tables in detailDevelop and test ETL processes and stage required data for downstream consumptionBuild Power BI reports for testing and validation of selected DimensionsExecute quality assurance testing for Dimensions and Facts to ensure accuracy, consistency, and usabilityUpdate as-is data models to support new attributes and evolving requirementsAddress minor fixes in delivered data marts and contribute lessons learned at project closeFacilitate and manage data architecture artifacts (principles, strategies, models, standards, guidelines, plans)Promote reusable modeling practices that reduce redundancy and improve sharing across initiativesIdentify and document enterprise data requirements, and encourage practices that improve data qualityDevelop and lead transition plans from current-state data to an ideal future stateProvide architecture guidance, consultancy, and participate in design/architecture reviews to ensure alignment and complianceSupport broader enterprise architecture activities as needed, including communication of data architecture directionQualificationsRequired (Must Haves)Training in structured query languages specific to Microsoft T-SQL and/or Oracle and/or PL/SQL,



plus database developmentCloud computing and Microsoft Azure / Azure Architecture training obtained within the past 5-10 yearsPost-secondary degree or diploma in Computer Science, Information Technology, Cybersecurity, or a related field (equivalent experience may be considered; formal education strongly preferred)Demonstrated experience defining data architecture and using Kimball architecture to develop data martsExperience working in or with public-sector environments, including awareness of public-sector constraints and privacy legislation (e.G., FOIP)Ability to work within Canada for the duration of the engagement, with availability for onsite meetings in Edmonton when requestedNice to Have (Beneficial, Not Mandatory)Willingness to complete a Criminal Records Check and Enhanced Security Clearance, including a credit check, prior to commencement (and eligibility for additional clearances if required)Experience with data modeling/design tools such as PowerDesigner, ERwin, Oracle Designer, SQL Developer Data Modeler, or Microsoft VisioFamiliarity with JOIN (Justice Online Information Network) and JIMS (Justice Information Management System) data structures and judicial business rulesExperience working in or with court environments, including awareness of the importance of judicial independenceExperience with information management and cybersecurity policies, directives, and guidelines within limited timelinesStrong communication skills - able to translate technical concepts for non-technical stakeholders and influence decisions #J-18808-Ljbffr

📌 Data Architect (Senior) (Edmonton)
🏢 Vantix Systems
📍 Edmonton