Location
Hybrid (Oshawa, Canada)
Visa
Positions approved through LMIA in 12 months: 1 · for this role: 1
Employment
Contractor
First seen by Alion on Nov 16, 2026.
Overview
Company
Impact
Profile match
Randstad Canada is the Canadian subsidiary of the Dutch staffing group Randstad N.V., headquartered in Toronto, Ontario. It provides temporary and contract staffing, permanent placement, executive recruitment and managed workforce services in IT, engineering, finance and accounting, administration and industrial work. It advertises client positions such as SCADA engineers, Power Platform developers, civil engineering technicians and compliance analysts in Toronto, Quebec City, Montreal and other Canadian cities.
Our client, is seeking an experienced, highly analytical Syniti ETL Developer to join a critical enterprise data cleansing and SAP S/4HANA migration initiative in Oshawa, Ontario.
In this hands-on data engineering and migration role, you will drive end-to-end data profiling, cleansing, transformation, and conversion workflows scheduled to kick off in January 2027. Working across legacy enterprise asset management systems (such as Asset Suite 9 / Oracle) and modern SAP S/4HANA target architectures, you will configure core Syniti Knowledge Platform (SKP / DSP / ADM) modules—including Migrate, Catalog, Quality, Construct, and Match—to build data quality scorecards, design Construct enrichment web applications for business stewards, develop complex SQL transformation logic, and execute mock and cutover loads via the SAP S/4HANA Migration Cockpit.
Contract Duration: 8-Month Contract (Target Start Date: January 2027; full-time engagement)
Work Location: Oshawa, ON (Hybrid – 4 days per week on-site, 1 day remote)
Security Clearance Requirement: Candidates must be eligible to obtain the required nuclear security clearance
Advantages
Mission-Critical Energy & Nuclear Infrastructure Impact: Play a pivotal role cleansing, governing, and migrating foundational enterprise asset and supply chain data for a major power generation utility.
8-Month Full-Lifecycle Migration Mandate: Experience the complete data conversion lifecycle—from initial source profiling and rule configuration through mock loads, reconciliation, and production cutover.
Deep Syniti & SAP S/4HANA Tech Stack: Work hands-on across the full Syniti suite (Migrate, Catalog, Quality, Construct, Match) paired with SAP S/4HANA Migration Cockpit and enterprise SQL platforms.
Collaborative Business & Technical Alignment: Partner directly with Data Stewards, SMEs, and Data Migration Leads to replace manual spreadsheets with interactive Construct web applications and automated quality scorecards.
Responsibilities
Syniti Environment Setup & Source Connectivity: Configure Syniti projects, waves, process areas, objects, users, and roles aligned to release plans; establish system connections and data snapshots against legacy Oracle databases (Asset Suite 9), register metadata in Catalog, and manage object promotion across DEV, QA, and PROD tenants.
Data Profiling & Quality Scorecards: Profile source datasets to uncover completeness, validity, consistency, duplication, and referential integrity gaps; build and schedule rules in Syniti Quality and produce recurring object- and business-unit-level scorecards and dashboards.
Source Cleansing & Construct Applications: Build remediation reports and worklists routing errors to Data Stewards/SMEs; configure Syniti Construct web applications for interactive enrichment and approval, tune Match jobs for duplicate resolution/survivorship, and prepare audited write-back files for Asset Suite 9.
S/4HANA Conversion, Load & Reconciliation: Design target datasets aligned to SAP S/4HANA structures; build field/value mappings and cross-reference tables in Map, write SQL transformation/validation rules in Transform, generate staging outputs (plus BAPI/IDoc loads where required) for the SAP S/4HANA Migration Cockpit, and execute mock and cutover loads with full pre/post-load reconciliation reports.
Data Governance & Delivery Hygiene: Configure ongoing data quality monitoring between waves and post-go-live; maintain reusable rule libraries and specifications in Catalog, document runbooks, track defects/risks for the Data Migration Lead, and walk business SMEs through Syniti outputs.
Qualifications
Data Migration & Syniti Experience (4–8 Years): 4 to 8 years of progressive experience in enterprise data migration or data quality delivery, including at least 3+ years of hands-on configuration and development in Syniti (SKP, or legacy DSP / ADM platforms).
Full-Cycle SAP S/4HANA Migration: Proven track record delivering at least one full-cycle SAP S/4HANA or SAP ECC data migration on Syniti—spanning initial design, mock loads, error resolution, and production cutover.
Core Syniti Module Mastery: Demonstrated hands-on build experience across Migrate (ADMM) (waves, mapping, ETL/Transform rules, load files, reconciliation), Catalog (connections, snapshots, metadata, rule library), Quality (rules, thresholds, dashboards), and Construct (Full and Enrichment Construction web apps and worklists).
SQL & Database Proficiency: Strong hands-on SQL skills writing, debugging, and tuning transformation and validation logic in MS SQL Server, paired with solid working knowledge of Oracle SQL for source data extraction.
SAP S/4HANA Load Methods & Master Data: Practical experience using the SAP S/4HANA Migration Cockpit (staging table approach) and familiarity with BAPI/IDoc loads, alongside working knowledge of SAP master data structures for at least two domains: Plant Maintenance / EAM (Functional Location, Equipment, Maintenance Plan, Task List, Measuring Point), Material Master, BOM, or Business Partner / Supplier.
Stakeholder Communication & Security Eligibility: Comfortable walking business users through data errors to agree on remediation fixes, and eligible to obtain the required nuclear security clearance.
Preferred Assets & Nice-to-Haves
Syniti Certified Developer (Migrate learning path) certification (strongly preferred).
SAP S/4HANA certification (Data Migration, Plant Maintenance, or Materials Management).
Hands-on experience with Syniti Match (fuzzy, phonetic, and rules-based deduplication and survivorship), Syniti Replicate, Syniti Governance / MDM (SAP MDG integration), or Syniti AI classification/enrichment capabilities.
Summary
If you are a seasoned Syniti ETL Developer who pairs 3+ years of hands-on Syniti (Migrate, Catalog, Quality, Construct) and full-cycle SAP S/4HANA migration experience with strong MS SQL Server and Oracle SQL skills, this 8-month hybrid contract opportunity in Oshawa is an ideal next step. Bring your data quality rigor, conversion precision, and collaborative problem-solving skills to our client's enterprise transformation team today!
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 [email protected] to ensure their ability to fully participate in the interview process.
This posting is for existing and upcoming vacancies.
In this hands-on data engineering and migration role, you will drive end-to-end data profiling, cleansing, transformation, and conversion workflows scheduled to kick off in January 2027. Working across legacy enterprise asset management systems (such as Asset Suite 9 / Oracle) and modern SAP S/4HANA target architectures, you will configure core Syniti Knowledge Platform (SKP / DSP / ADM) modules—including Migrate, Catalog, Quality, Construct, and Match—to build data quality scorecards, design Construct enrichment web applications for business stewards, develop complex SQL transformation logic, and execute mock and cutover loads via the SAP S/4HANA Migration Cockpit.
Contract Duration: 8-Month Contract (Target Start Date: January 2027; full-time engagement)
Work Location: Oshawa, ON (Hybrid – 4 days per week on-site, 1 day remote)
Security Clearance Requirement: Candidates must be eligible to obtain the required nuclear security clearance
Advantages
Mission-Critical Energy & Nuclear Infrastructure Impact: Play a pivotal role cleansing, governing, and migrating foundational enterprise asset and supply chain data for a major power generation utility.
8-Month Full-Lifecycle Migration Mandate: Experience the complete data conversion lifecycle—from initial source profiling and rule configuration through mock loads, reconciliation, and production cutover.
Deep Syniti & SAP S/4HANA Tech Stack: Work hands-on across the full Syniti suite (Migrate, Catalog, Quality, Construct, Match) paired with SAP S/4HANA Migration Cockpit and enterprise SQL platforms.
Collaborative Business & Technical Alignment: Partner directly with Data Stewards, SMEs, and Data Migration Leads to replace manual spreadsheets with interactive Construct web applications and automated quality scorecards.
Responsibilities
Syniti Environment Setup & Source Connectivity: Configure Syniti projects, waves, process areas, objects, users, and roles aligned to release plans; establish system connections and data snapshots against legacy Oracle databases (Asset Suite 9), register metadata in Catalog, and manage object promotion across DEV, QA, and PROD tenants.
Data Profiling & Quality Scorecards: Profile source datasets to uncover completeness, validity, consistency, duplication, and referential integrity gaps; build and schedule rules in Syniti Quality and produce recurring object- and business-unit-level scorecards and dashboards.
Source Cleansing & Construct Applications: Build remediation reports and worklists routing errors to Data Stewards/SMEs; configure Syniti Construct web applications for interactive enrichment and approval, tune Match jobs for duplicate resolution/survivorship, and prepare audited write-back files for Asset Suite 9.
S/4HANA Conversion, Load & Reconciliation: Design target datasets aligned to SAP S/4HANA structures; build field/value mappings and cross-reference tables in Map, write SQL transformation/validation rules in Transform, generate staging outputs (plus BAPI/IDoc loads where required) for the SAP S/4HANA Migration Cockpit, and execute mock and cutover loads with full pre/post-load reconciliation reports.
Data Governance & Delivery Hygiene: Configure ongoing data quality monitoring between waves and post-go-live; maintain reusable rule libraries and specifications in Catalog, document runbooks, track defects/risks for the Data Migration Lead, and walk business SMEs through Syniti outputs.
Qualifications
Data Migration & Syniti Experience (4–8 Years): 4 to 8 years of progressive experience in enterprise data migration or data quality delivery, including at least 3+ years of hands-on configuration and development in Syniti (SKP, or legacy DSP / ADM platforms).
Full-Cycle SAP S/4HANA Migration: Proven track record delivering at least one full-cycle SAP S/4HANA or SAP ECC data migration on Syniti—spanning initial design, mock loads, error resolution, and production cutover.
Core Syniti Module Mastery: Demonstrated hands-on build experience across Migrate (ADMM) (waves, mapping, ETL/Transform rules, load files, reconciliation), Catalog (connections, snapshots, metadata, rule library), Quality (rules, thresholds, dashboards), and Construct (Full and Enrichment Construction web apps and worklists).
SQL & Database Proficiency: Strong hands-on SQL skills writing, debugging, and tuning transformation and validation logic in MS SQL Server, paired with solid working knowledge of Oracle SQL for source data extraction.
SAP S/4HANA Load Methods & Master Data: Practical experience using the SAP S/4HANA Migration Cockpit (staging table approach) and familiarity with BAPI/IDoc loads, alongside working knowledge of SAP master data structures for at least two domains: Plant Maintenance / EAM (Functional Location, Equipment, Maintenance Plan, Task List, Measuring Point), Material Master, BOM, or Business Partner / Supplier.
Stakeholder Communication & Security Eligibility: Comfortable walking business users through data errors to agree on remediation fixes, and eligible to obtain the required nuclear security clearance.
Preferred Assets & Nice-to-Haves
Syniti Certified Developer (Migrate learning path) certification (strongly preferred).
SAP S/4HANA certification (Data Migration, Plant Maintenance, or Materials Management).
Hands-on experience with Syniti Match (fuzzy, phonetic, and rules-based deduplication and survivorship), Syniti Replicate, Syniti Governance / MDM (SAP MDG integration), or Syniti AI classification/enrichment capabilities.
Summary
If you are a seasoned Syniti ETL Developer who pairs 3+ years of hands-on Syniti (Migrate, Catalog, Quality, Construct) and full-cycle SAP S/4HANA migration experience with strong MS SQL Server and Oracle SQL skills, this 8-month hybrid contract opportunity in Oshawa is an ideal next step. Bring your data quality rigor, conversion precision, and collaborative problem-solving skills to our client's enterprise transformation team today!
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 [email protected] to ensure their ability to fully participate in the interview process.
This posting is for existing and upcoming vacancies.
Free account
Stop reading job ads. Get the ones that fit.
One free account turns this page into a shortlist built around your stack, your level and your pay.
Match on every job. Stack, seniority, pay and location, scored against your profile.
2,353,337 open roles. Read straight off company career pages, refreshed every day.
Unlimited applications. Every one you send is tracked in one place, on-site or on a company board.
3 tailored CVs a month. Rewritten for the exact job you are applying to. Included free.
Free forever. No card. Under a minute.
Your match
How well do you fit this role?
Two answers are enough for a real match. No account needed.
Check my fit
Answers stay in this browser until you create an account.
Recommended for you based on this role
Data Science
Remote, many countries
Similar stack
Same company
Oshawa
Sr Data Engineer (Azure Databricks)
1 day ago
$132k – $146k per year · Hybrid · Contractor · Toronto
Python
SQL
Python
pySpark
Databases
Snowflake
Databricks
Oracle
AI/ML
Spark
DevOps
Azure DevOps
Azure
CI/CD
Analytics
Power BI
Azure Data Factory
QA
Rest-Assured
Pytest
Apply
Data Science Manager
1 day ago
Remote (Canada) · Full-Time · Canada
Python
AI/ML
TensorFlow
PyTorch
Machine Learning
DevOps
GCP
Apply
Azure Data Developer
3 hours ago
In office · Full-Time · Bachelor's Degree · Burnaby
Python
SQL
Databases
MS SQL
Azure SQL Database
DevOps
Rest API
Azure DevOps
Azure
CI/CD
GitHub
Analytics
Power BI
ETL/ELT
Azure Data Factory
Apply
Data Architect
4 hours ago
$84k – $112k per year · In office · 8+ years exp · Toronto
AI/ML
Machine Learning
Apply
Data Historian Specialist
1 day ago
$56k – $84k per year · Hybrid · Contractor · Calgary
SQL
DevOps
Windows
Analytics
Tableau
Power BI
IoT
MQTT
Apply
ETL разработчик
1 day ago
Remote (likely EAEU) · Moscow
SQL
Databases
PostgreSQL
DevOps
Git
Gitflow
Analytics
ETL/ELT
Apply
Remote (likely EAEU) · Moscow
Python
Go
Databases
ClickHouse
DevOps
Kubernetes
Analytics
ETL/ELT
Apply
Data Management Consultant
2 days ago
$132k – $176k per year · Remote (EMEA) · Full-Time
Python
SQL
Databases
Snowflake
Databricks
Google BigQuery
Microsoft Fabric
AI/ML
Copilot
Cursor
Claude
Model Context Protocol
dbt
AI Agents
OpenAI Codex
Agentic Workflows
DevOps
CI/CD
Git
Kubernetes
Game Dev
Unity
Analytics
Collibra
Alation
Apply
YR-15 Data Engineer
1 day ago
Remote (likely LATAM) · 5+ years exp
Python
SQL
Databases
SAP HANA
SAP BW
DevOps
Azure
Git
AWS
Analytics
ETL/ELT
Alteryx
Microsoft Excel
Apply
Senior Data Architect (remote from Europe)
2 days ago
Remote (Europe) · Freelance · Amsterdam
AI/ML
Synthetic Data
Management
Agile
Apply
In office · Full-Time · Bachelor's Degree · Oshawa
Python
Java
C++
DevOps
GCP
GitHub Actions
Azure
CI/CD
AWS
GitHub
Apply
$34k – $37k per year · In office · Oshawa · Pickering · Whitby
Apply
Apply
$24k – $60k per year · In office · Part-Time · Oshawa
Apply
Sessional Lecturer - BUSI 4710U - Information Privacy Law and New Technologies - Winter 2027
1 day ago
In office · Oshawa
Apply
This is one of many
2,353,337 more open roles from verified company boards, updated every day.

