Senior Data Analyst – Data Migration & ETL (Hybrid, 6m)

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

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