Sr. Data AnalystLocation: Toronto, ON_HybridDuration: 6
- months (extendable contract)Qualifications and Experience: University degree in Computer Science, Data Science, Information Systems or related discipline, and 7
- years of progressively more responsible experience working on large-scale information technology projects or the approved equivalent combination of education and/or experience.
7
- years extensive experience with Systems/Data Migration Projects especially involving legacy systems transitioning to COTS Platforms including data profiling, data mapping, transformation and validation processes.
5
- years hands-on experience with SQL and ETL including writing SQL queries and designing/executing ETL (Extract, Transfer and Load) processes to move and reconcile data between old and new system.
Working experience and familiarity with data governance principles, data profiling, and insuring data integrity during migration. Able to define quality checks, identify data anomalies, and support resolution strategies. Experience in a government/public sector setting on modernization and replacement legacy system projects.
Demonstrated ability to establish and maintain an effective working relationship with clients and projects stakeholders with a strong customer service orientation; have highly developed interpersonal skills and communication ability to interact and work effectively. Technical Capabilities: 7
- years of working experience in similar or larger initiatives with extensive usage of SQL and Unified Modeling Language (UML); 5
- years working experience in preparing project documentation such as Data Profiling, Data Mapping, Data Quality Documents and others data project related artifacts 5
- years working experience in designing, developing and executing ETL Specifications and Scripts
This revision: 25 April 2025 Working experience with technical and business teams in supporting Accessibility for Ontarians with Disabilities Act (AODA), Security Threat and Risk Assessment (STRA), Privacy Impact Assessment (PIA)
