Sr. Data Analyst
Location: Toronto, ON_Hybrid
Duration: 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)