Manager, Finance Systems & Data Governance

vaco; Markham; Hybrid; CAD 130,000 - 150,000; Full time

Job summary

Randstad Canada is seeking a Senior Data Analyst in Toronto with hybrid work options. The role focuses on data profiling, transformation, quality governance, and ETL execution for major legacy modernization efforts.

The candidate will own data from discovery and mapping to ETL execution and target validation, collaborating with analysts, vendors, and governance teams to shape future-state reporting structures.

Qualifications

• 7+ years of progressive technical experience on large-scale IT and data engineering projects.
• 7+ years leading system and data migrations, moving legacy systems to COTS platforms.
• 5+ years hands-on SQL queries, ETL scripts, and data transformation/reconciliation pipelines.
• 5+ years authoring technical artifacts (Data Profiling, Data Mapping, Data Quality) and UML models.
• Strong data governance, quality rules, and anomaly identification during migration.

Responsibilities

• Provide data-related expertise across the SDLC, performing profiling, mapping, quality checks, and schema updates.
• Execute exploratory data analysis to uncover trends, anomalies, and structural patterns, producing reports.
• Partner with Business Systems Analysts to define conceptual data models and data flow diagrams.
• Design, build, and execute ETL specifications, scripts, and workflows to migrate data between legacy and modern systems.
• Conduct root-cause analysis on data discrepancies and develop automated workflows for cleansing and reconciliation.
• Support fit-gap analysis and technical data discussions with vendor teams during onboarding.
• Ensure data integrity and governance by establishing automated validation rules.
• Create ERDs and process maps using UML, BPMN notations; deliver data insights and dashboards.

Skills

SQL

ETL

Data profiling

Data governance

Data mapping

UML

BPMN

Analytical thinking

Education

University degree in Computer Science / Data Science / Information Systems

Tools

UML

BPMN

Job description

Senior Data Analyst

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.

Full-time

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

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.

Summary

If you'r e interested in the "Senior Data Analyst" role based in North York, we encourage you to apply online at www.randstad.ca. Only qualified candidates will be contacted for the next steps. We look forward to hearing from you!

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.