Technical Architect 

·        Pay Rate: (flexible)

·        Location: Toronto ON

·        Contract Length:12 months

Work Type: Hybrid

We 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 Responsibilities

• Lead 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 Qualifications

• University 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 Profiling
  • Data Mapping
  • Data Transformation
  • Data Validation
  • Data Migration
• Minimum 5+ years of hands-on SQL experience.
• Minimum 5+ years of ETL design, development, and execution experience.
• Strong understanding of:
  • Data Governance
  • Data Quality
  • Data Integrity
• Experience 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 Skills

• SQL
• ETL Development
• Data Migration
• Data Profiling
• Data Mapping
• Data Validation
• Data Quality Management
• Data Governance
• Data Analysis
• Data Modeling
• UML
• BPMN
• Entity Relationship Diagrams (ERD)
• Metadata Documentation
• Legacy System Modernization
• Commercial Off-The-Shelf (COTS) Implementations
• SDLC
• Data Architecture

Nice to Have

• Experience 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.

Deliverables

• Data Profiling Report
• Legacy Landscape Report
• Data Quality Assessment Report
• Data Mapping Documents
• Metadata Documentation
• ETL Specifications
• ETL Scripts
• Data Migration Strategy
• Summary Dashboards and Presentations
• Knowledge Transfer (KT) Documentation
• Project Materials

 Looking for meaningful work? We can help

Raise is an established hiring firm with over 65 years of experience. We believe strongly in making the world a better place through work, which is why we’re a certified B Corporation and donate 10% of our profits to charity.

We 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: https://raise.jobs/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 +1 800-567-9675 or hello@raiserecruiting.com