Data Analyst - Parallel Testing
Job Description
Data Analyst - Parallel Testing
Location: Toronto, ON
Onsite Flexibility: Hybrid — 1 day/week in office on Mondays
Contract Details
- Position Type: Contract
- Contract Duration: 16 months
- Pay Rate: C$85.00–C$90.00 / Hour (CAD)
- Shift / Schedule: 37.5 hours/week, 9:00 AM – 5:00 PM, Monday to Friday (Flexible)
- Travel Requirements: Not required
Job Summary
We are seeking a detail-oriented Data Analyst to support a large-scale system migration initiative. This role will focus on parallel testing of legacy and new systems to ensure a seamless transition with minimal impact to reporting and business operations. The successful candidate will play a critical role in identifying and resolving data issues, validating data integrity, and collaborating with project teams to investigate discrepancies.
Key Responsibilities
- Support parallel testing efforts between legacy and new systems
- Analyze and validate data to ensure consistency, accuracy, and completeness across both systems
- Investigate and troubleshoot data discrepancies, connection issues, and reporting gaps
- Review mapping documents and translate logic into SQL queries to assess data relationships and identify root causes of issues
- Execute queries using query tools to trace data sources and validate outputs
- Document findings, escalate issues, and collaborate with upstream project teams to drive resolution
- Participate in regular meetings to provide insights on data inconsistencies and system behavior
Required Skills
- Strong SQL knowledge (8 years)
- Understanding of window functions within SQL
- General reporting experience
- Able to multitask
- Change management skills
- Great communication skills
- Team player
- Attention to detail
Preferred Skills
- Understanding of mapping, UAT/ATL
- Business Analysis (BA) experience
- Cognos experience (reports are fully automated using Cognos)
- Retail credit risk experience
Work Environment / Physical Requirements
- Hybrid work model — in office 1 day per week on Mondays
- Regular participation in project calls and cross-functional team meetings
- Overtime potential: unlikely
Important Notes
- Interview process: 1 interview, approximately 60–90 minutes, conducted in person, consisting of two parts — (1) behavioral, scenario-based, and work experience questions; and (2) a SQL test conducted via the SQL Lite website, requiring the candidate to share their screen and have camera on (approximately 40 minutes)
- The candidate may begin work while employment history verification is being completed; suppliers have 30 days from the start date to complete verification
- Potential for contract extension: possible; potential for FTE conversion: possible
- Medical, Vision, and Dental Insurance Plans
- 401k Retirement Fund
About GTT
GTT is a minority-owned staffing firm and a subsidiary of Chenega Corporation, a Native American-owned company in Alaska. We highly value diverse and inclusive workplaces and support Fortune 500 organizations across banking, financial services, technology, life sciences, biotech, utilities, and retail sectors throughout the U.S. and Canada.
Job Number: 26-09056 Industry: Data & Analytics
#gttca