Sql data analyst • vaughan 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 wit... Voir plus
Clearsulting is a global consulting company with the motivation to deliver positive change through digital finance.Our team consists of finance specialists that bring experience and technical capab... Voir plus
Our client is a real estate management company.They are looking for a Senior Financial Analyst to join their team!.Comprehensive, world-class benefits package.Automatic 6% RRSP contribution.Profess... Voir plus
Allied is a leading owner-operator of distinctive urban workspace in Canada’s major cities.Our work is grounded in a clear purpose: to provide knowledge-based organizations with distinctive urban e... Voir plus
Westlake offers you the potential to enrich your work life and career experience in an entrepreneurial environment.We work together to enhance peoples' lives through our products and presence in th... Voir plus
We are looking for a detail-oriented.The ideal candidate will have strong attention to detail, good knowledge of payroll processes, and the ability to handle confidential employee information.Manag... Voir plus
At Grainger, We Keep the World Working® by serving more than 4.MRO) products and value-added solutions delivered through innovative technology and deep customer expertise.Known for its commitment t... Voir plus
Gunnebo Canada is a leading provider of integrated security solutions, protecting people, property, and assets across the country.With a national network of branches and a strong reputation for ser... Voir plus
At The Home Depot Canada, we want you to feel valued and supported.The pay range you see represents base salary only.In addition, your total rewards may include: semi-annual bonuses tied to busines... Voir plus
Role Title: Senior Data Engineer (Databricks Specialist & AWS).Location: Hybrid - 3 days onsite in Woodbridge.Contract Duration: 6-Month Contract to start.Our client is accelerating its digital... Voir plus
This job is currently not accepting applicants. Voir plus
Canada Rocket Company is developing Canada's first medium-lift launch vehicle.We are a team of veterans from SpaceX, Blue Origin, Rocket Lab, ArianeGroup, Pangea Propulsion, Tesla, MDA, and more, b... Voir plus
BMO is an organization driven by a shared Purpose: Boldly Grow the Good in business and life.It calls on members of its team, to create lasting, positive change for its customers, its communities, ... Voir plus
This job is currently not accepting applicants. Voir plus
About PureFacts Financial Solutions.PureFacts is the leader in the Revenue Performance Management category for wealth and asset management firms.The PureRevenue™ Platform helps organizations maximi... Voir plus
Terumo Medical Corporation (TMC) develops, manufactures, and markets a complete, solutions-based portfolio of high-quality medical devices used in a broad range of applications for numerous areas o... Voir plus
A position at White Cap isn’t your ordinary job.You’ll work in an exciting and diverse environment, meet interesting people, and have a variety of career opportunities.The White Cap family is commi... Voir plus
Are you passionate about shaping the future of automotive regulations, emissions compliance, and electric vehicle technologies?.This exciting opportunity is ideal for professionals with experience ... Voir plus
King International Advisory Group, a globally recognized private investigation and intelligence firm based in Toronto, Canada, is seeking an Intelligence Analyst to join our growing investigative t... Voir plus
Our client, a tier 1 real estate company in Vaughan, Ontario, is seeking a talented Senior Financial Analyst to provide advanced financial analysis, forecasting, modelling, and reporting across a c... Voir plus
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.
