Sql data analyst Jobs in Richmond Hill, ON

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.

As a principal data authority, you will bridge the gap between legacy database structures and modern commercial off-the-shelf (COTS) software solutions. Operating within a hybrid work model, you will perform deep exploratory data analysis, build complex data mapping specifications, and enforce strict data integrity frameworks across multi-departmental workflows. This role demands an expert who can write advanced SQL queries, automate data reconciliation pipelines, and deliver actionable data insights to drive successful enterprise digital transformations.

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

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

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're 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 accessibility@randstad.ca to ensure their ability to fully participate in the interview process.