Technical ArchitectPay Rate: (adaptable)Location: Toronto ONContract Length: 12 monthsWork Type: HybridWe at Raise are hiring right now for one of our Government Sector Clients. If you're interested, apply below for your chance to join a great place to work.Key ResponsibilitiesLead data migration activities from legacy systems to a new COTS platform.Perform data profiling, data quality assessments, and legacy data analysis.Develop source-to-target data mapping documentation.Design, develop, and execute ETL (Extract, Transform, Load) processes.Analyze complex datasets to identify trends, inconsistencies, and data quality issues.Validate migrated data for completeness, accuracy, and integrity.Create and maintain Data Profiling Reports and Legacy Landscape Reports.Develop conceptual data models and data flow diagrams.Create Entity Relationship Diagrams (ERDs) using UML/BPMN.Collaborate with Business Systems Analysts to gather and document business and reporting requirements.Develop data transformation specifications and migration strategies.Ensure compliance with enterprise data governance policies and standards.Perform root cause analysis for data-related issues and recommend corrective actions.Develop scripts and workflows to automate data collection, cleansing, reconciliation, and validation.Support vendor fit-gap analysis and COTS implementation activities.Participate in Data Quality Assurance (DQA), testing,



and validation activities.Contribute to data architecture discussions and enterprise data management initiatives.Prepare project documentation and technical deliverables.Work closely with cross-functional teams throughout the project lifecycle.Perform additional project duties as assigned.Required QualificationsUniversity degree in Computer Science, Data Science, Information Systems, or a related discipline.Minimum 7+ years of experience working on large-scale enterprise IT projects.Minimum 7+ years of experience in legacy system data migration projects.Extensive experience with:Data ProfilingData MappingData TransformationData ValidationData MigrationMinimum 5+ years of hands-on SQL experience.Minimum 5+ years of ETL design, development, and execution experience.Strong understanding of:Data GovernanceData QualityData IntegrityExperience working on enterprise modernization projects.Experience working within Government or Public Sector environments is highly preferred.Excellent analytical, documentation, communication, and stakeholder management skills.Technical SkillsSQLETL DevelopmentData MigrationData ProfilingData MappingData ValidationData Quality ManagementData GovernanceData AnalysisData ModelingUMLBPMNEntity Relationship Diagrams (ERD)Metadata DocumentationLegacy System ModernizationCommercial Off-The-Shelf (COTS)



ImplementationsSDLCData ArchitectureNice to HaveExperience supporting Accessibility for Ontarians with Disabilities Act (AODA)Experience supporting Security Threat Risk Assessment (STRA)Experience supporting Privacy Impact Assessment (PIA)Experience working on municipal or public sector modernization initiatives.DeliverablesData Profiling ReportLegacy Landscape ReportData Quality Assessment ReportData Mapping DocumentsMetadata DocumentationETL SpecificationsETL ScriptsData Migration StrategySummary Dashboards and PresentationsKnowledge Transfer (KT) DocumentationProject MaterialsWe strive to build teams that reflect the diversity of the communities we work in. We encourage all qualified applicants to apply, including people from traditionally underrepresented groups such as women, visible minorities, Indigenous peoples, people identifying as LGBTQ2SI, veterans, and people with visible/nonvisible disabilities.We have a dedicated webpage for accommodations where you can learn more about what we offer, and request accommodation: accommodations/In order to submit candidates for roles, our clients will sometimes require personal information to confirm the identity of applicants and their legal status to work. Raise will never ask you for personal or banking information unless you have been selected for a job. If you are ever unsure about the legitimacy of this or another job posting by Raise (or have any other questions), please contact us at or #J-18808-Ljbffr

📌 Technical Architect (Toronto)
🏢 Raise
📍 Toronto