Job#: 3042284

Job Description:

Client: Top 5 Bank

Duration: 15-Week Contract

Potential Extension/Conversion: Possible, though not guaranteed

Work Location: Hybrid – 1 day/week onsite (Mondays) at 81 Bay Street, Toronto

Hours: 37.5 hrs/week; Monday-Friday, 9:00 am - 5:00 pm (flexible)

Start Date: Early August

The Risk Reporting team is responsible for supporting retail credit risk reporting, regulatory reporting, data validation, and system testing initiatives. The team provides reporting and analytics used by business stakeholders, executives, and regulators.

Our client is seeking an experienced Data Analyst to support a high-profile enterprise system migration within the Retail Credit Risk Reporting team. The project involves transitioning from a legacy mortgage origination platform to a new FICO-based system and conducting parallel testing to ensure reporting accuracy and data integrity throughout the transition.

The successful candidate will act as the analytical bridge between reporting, data, and project teams, investigating discrepancies, tracing data lineage, validating outputs, and identifying root causes of data issues. This is a highly analytical role focused on SQL, UAT, data validation, and stakeholder collaboration—not report development or report distribution.

This opportunity offers exposure to a large-scale system integration project with significant visibility across business and technology teams.

• Support parallel testing efforts between legacy and new mortgage origination systems.

• Validate data accuracy, completeness, and consistency across multiple systems and reporting layers.

• Investigate data discrepancies and perform root cause analysis to determine whether issues originate from source systems, ETL processes, data feeds, or reporting outputs.

• Review mapping documentation and data lineage artifacts to understand end-to-end data movement.

• Translate business and functional logic into SQL queries to analyze and validate data.

• Execute complex SQL queries, including window functions, to trace data sources and confirm expected results.

• Work closely with reporting, data, ETL, and project teams to resolve defects and data quality issues.

• Escalate findings to upstream project teams and participate in issue resolution discussions.

• Document testing results, analysis findings, risks, and recommendations.

• Participate in stakeholder meetings and provide insights into data inconsistencies, system behavior, and testing outcomes.

• Support UAT activities and ensure reporting outputs remain accurate throughout system migration efforts.

• Analyze impacts of system changes on risk, operational, and regulatory reporting outputs.

• Collaborate with cross-functional teams throughout the migration lifecycle.

• 8+ years of Data Analysis, Business Analysis, Reporting Analysis, or related experience

• Advanced SQL expertise with recent hands-on experience using SQL on a daily basis

• Strong understanding of SQL window functions

• Experience performing UAT and system testing activities

• Experience analyzing data lineage, data flows, and mapping documentation

• Strong root cause analysis and troubleshooting capabilities

• Data validation and reconciliation experience across multiple systems

• General reporting and analytics experience

• Experience working with stakeholders across business and technology teams

• Strong communication and documentation skills

• Ability to work independently and manage multiple priorities

• Banking or financial services experience

• Retail Credit Risk experience

• Mortgage or lending domain knowledge

• Regulatory reporting experience

• Cognos experience

• Business Analysis experience

• Experience supporting large-scale data migrations or system conversion initiatives

• Experience working within Risk Management environments

• Excellent communication and stakeholder management skills

• Strong attention to detail

• Ability to multitask in a fast-paced environment

• Strong investigative and analytical mindset

• Collaborative team player

• Adaptable and comfortable working through change

• Proactive problem solver

A top performer for this role is someone who combines advanced SQL expertise with strong data validation and investigative skills. They can independently trace issues through data lineage, understand complex mapping documentation, identify root causes quickly, and work effectively with upstream teams to resolve discrepancies.

Successful candidates are comfortable operating in ambiguity, communicating findings to both technical and non-technical stakeholders, and driving analysis initiatives with minimal oversight. Experience supporting UAT, system migrations, and banking-related reporting environments will be highly valued.

1 Interview (60–90 Minutes Total)

Part 1 – Behavioural & Project Discussion

• Past project experience
• UAT/testing experience
• Stakeholder management
• Data analysis and troubleshooting scenarios

Part 2 – Live SQL Assessment

• Screen sharing required
• Camera on
• SQL technical evaluation
• Focus on query writing, data analysis, and problem-solving

Candidates must demonstrate strong current SQL proficiency and be capable of contributing immediately with minimal ramp-up time.

• High-visibility enterprise transformation initiative

• Opportunity to gain experience supporting a major system integration and migration project

• Significant exposure to Risk Reporting, Data Analytics, and Banking Operations

• Collaboration with multiple business and technology stakeholder groups

• Potential pathway to future full-time opportunities as openings become available

Apex pay scales are determined by role, experience, skill set, and location. For this new position, the estimated hourly range is provided below as a guideline; however, total compensation may vary based on individual circumstances.

• Role Type: Current Opening

• Location: Ontario

• Hourly Range: $63.00 - $68.00/hour

EEO Employer

Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at [email protected] or 844-463-6178.

Everforth Apex is a world-class IT services company that serves thousands of clients across the globe. When you join Everforth Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRateds Best of Staffing® in Talent Satisfaction in the United States and Great Place to Work® in the United Kingdom and Mexico.

Everforth Apex Benefits Overview: In terms of professional development, Everforth Apex hosts an on-demand training program, provides access to certification prep and a library of technical and leadership courses/books/seminars once you have 6+ months of tenure, and certification discounts and other perks to associations that include CompTIA and IIBA.