Collection Specialist

Vaco LLC; Richmond Hill; Hybrid; CAD 130,000 - 150,000; Full time

Job summary

Randstad Canada is seeking a Senior Data Analyst for an enterprise-level contract in Toronto. You will lead data profiling, structural transformation, quality governance, and ETL execution for major legacy platform modernizations. Location: North York, Hybrid—3 days onsite, 2 days remote per week. Contract duration: 6 months with a possible extension.

Salary: CA$130,000–CA$150,000 yearly. Full-time. Collaborate with analysts, vendors, and governance teams to ensure data readiness and accurate

Qualifications

• University degree in Computer Science, Data Science, Information Systems, or related quantitative field.
• 7+ years of progressive technical experience on large-scale IT and data engineering projects.
• 7+ years data migration experience transitioning legacy systems to COTS platforms.
• 5+ years SQL, ETL experience and data transformation/reconciliation pipelines.
• 5+ years authoring technical artifacts (ERDs, data flow diagrams) and data quality docs.

Responsibilities

• Provide data expertise across the SDLC with profiling, mapping, quality checks, and schema updates.
• Conduct exploratory data analysis to uncover trends and anomalies; generate profiling reports.
• Collaborate with Business Systems Analysts on data models and functional requirements.
• Design, build and execute ETL specs and workflows to migrate data between legacy and modern systems.
• Perform root-cause analysis on data discrepancies and develop automated data cleansing workflows.
• Support compliance and governance initiatives, including PIA, STRA, and accessibility reviews.
• Produce ERDs and process maps; deliver data insights and dashboards to leadership.

Skills

SQL

ETL

Data profiling

Data governance

Data mapping

Data quality

Analytical problem solving

Education

University degree (CS/DS/IS)

Job description

We are seeking a highly accomplished \"Senior Data Analyst\" for an enterprise-level contract opportunity based in Toronto. In this role, you will take on a premier analytical and technical capacity within the enterprise data migration and analytics stream, specializing in data profiling, structural transformation, quality governance, and ETL execution for major legacy platform modernizations.

Location: North York (Hybrid - 3 days onsite, 2 days remote per week)

Contract Duration: 6 months (with a 6-month optional extension)

Salary: CA$130,000.00–CA$150,000.00 yearly

Full-time

Advantages

• High-Impact Modernization: Direct the data migration and profiling strategy for a mission-critical platform replacement.
• Modern Data Stack Execution: Advanced hands-on application of SQL, ETL workflows, and data profiling tools across enterprise systems.
• Full-Lifecycle Data Ownership: Own the complete data trajectory from legacy discovery and data mapping to ETL execution and target validation.
• Cross-Functional Influence: Collaborate closely with business systems analysts, COTS vendors, and enterprise data governance teams to shape future-state reporting structures.

Responsibilities

• Provide data-related expertise across the entire Software Development Life Cycle (SDLC), performing data profiling, mapping, quality checks, and schema updates.
• Execute exploratory data analysis to uncover trends, anomalies, and structural patterns, producing detailed Data Profiling and Legacy Landscape Reports.
• Partner with Business Systems Analysts to define conceptual data models, data flow diagrams, and functional data requirements.
• Design, build, and execute Extract, Transform, and Load (ETL) specifications, scripts, and workflows to migrate and reconcile data between legacy and modern systems.
• Conduct root-cause analysis on data discrepancies, developing automated workflows for data collection, cleansing, and reconciliation.
• Support fit-gap analysis and technical data discussions alongside software vendor teams during COTS solution onboarding.
• Ensure data integrity and quality control by establishing automated validation rules aligned with enterprise data governance policies.
• Create technical project artifacts, including Entity Relationship Diagrams (ERDs) and process maps using UML, BPM, and BPMN notations.
• Support compliance initiatives and technical assessments, including accessibility guidelines (AODA), Privacy Impact Assessments (PIA), and Security Threat and Risk Assessments (STRA).
• Deliver data insights, summary presentations, and analytical dashboards to project leadership and cross-functional teams.

Qualifications

• Core Experience & Technical Capabilities
• Education: University degree in Computer Science, Data Science, Information Systems, or a related quantitative discipline (or equivalent verified education and experience).
• Senior Project Experience: 7+ years of progressive technical experience working on large-scale IT and data engineering projects.
• Data Migration Expertise: 7+ years of extensive experience leading system and data migration initiatives, specifically transitioning legacy systems to COTS platforms.
• Advanced SQL & ETL Capabilities: 5+ years of hands-on experience writing complex SQL queries, building ETL scripts, and designing data transformation/reconciliation pipelines.
• Data Documentation & Modeling: 5+ years of experience authoring technical artifacts, including Data Profiling, Data Mapping, Data Quality documents, and UML models.
• Data Governance & Integrity: Strong background defining data quality rules, identifying data anomalies, and applying governance frameworks during migration.
• Public Sector & Compliance Capabilities
• Public Sector Modernization: Proven experience working on legacy replacement and digital modernization projects within public sector or municipal settings.
• Regulatory & Compliance Exposure: Practical experience supporting Accessibility for Ontarians with Disabilities Act (AODA), Privacy Impact Assessments (PIA), and Security Threat and Risk Assessments (STRA).
• Leadership & Soft Skills
• Consultative Articulation: Excellent verbal, written, and presentation communication skills, with confidence translating complex data trends into clear business insights.
• Analytical Problem Solving: Superior critical thinking, root-cause analysis, and data troubleshooting capabilities.
• Collaborative Relationship Building: Strong customer service orientation with a track record of building effective working relationships across cross-functional project teams.

Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.

Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to [e-mail] to ensure their ability to fully participate in the interview process.