Posted 2 months ago
SAS Data Engineer
@ Randstad Canada
Toronto, Ontario
SIGNALS
Overview
Randstad Canada is hiring a SAS Data Engineer on a 2-month contract, with possible extension, for a client's enterprise data warehouse modernization in banking. The role converts legacy SAS programs and macros into PySpark pipelines on Databricks and validates outputs against baseline results. The work is hybrid: 3 days per week on-site at the corporate office and 2 days remote.
Pay:
$46.43–$49.75 an hour
Responsibilities:
- Analyze EDW tables, structures, dependencies and usage patterns
- Review SAS programs, macros and datasets to extract transformation logic
- Convert SAS logic into scalable PySpark code on Databricks
- Trace source-to-target data flows, joins and lineage
- Validate and reconcile PySpark outputs against SAS and EDW baselines
Requirements summary:
- 6 to 9 years of data engineering experience, preferably in banking or financial services
- Deep proficiency reading and deciphering complex SAS programs and macros
- Strong hands-on PySpark and Databricks development and optimization
- Solid understanding of EDW concepts and relational data structures
- Track record of data validation, quality checks and reconciliation
Tools & skills
Source and dates
Employer career site / ATS feed · careerpage
- Employer posting date
- 2026-09-17
- First seen by our source
- 2026-10-10
- Source record updated
- 2026-10-10
These dates describe the source record, not a live verification that the employer is still hiring. Check the original posting.
Job details
| Seniority | Senior |
| Department | Software development |
| Experience | 6+ years |
| Travel | air: none · ground: none |
| Work setting | Office |
| Position | Mostly sitting |
| Physical demands | physical low · computer high |
| Languages | English |
| Encouraged to apply | Women, Indigenous peoples, People with disabilities, Racialized people, 2SLGBTQ+ |
Summary and details written by AI from the posting; the employer’s posting is the authority.
Randstad Canada
Saved company profile
Historical company information from a saved The Jobs API profile (LinkedIn/Crunchbase fields). It is not live-verified; figures may have changed. Missing values remain unknown.
partner for talent.
Full company description
As the Canadian leader in recruitment and HR, and one of Canada’s best places to work, we have a uniquely human approach to work. We deliver HR innovation with human interaction at its core. At the unique intersection of technology and humanity, we deliver data-driven insights coupled with a people-first experience that is inherently human. Human Forward. Learn more at www.randstad.ca.
- LinkedIn followers
- 455,966
- People associated on LinkedIn
- 1,207
- Reported office locations
- 777 Bay Street, Suite 2000, PO Box 128, Toronto, ON M5G 2C8, CA
- 525 Avenue Viger Ouest, Suite 501, Montréal, Quebec H2Z 1G6, CA
- 4295 King St E, Suite 401, Kitchener, Ontario N2P 0C6, CA
- 311 6 Ave SW, Intact Place, East Tower, Suite 1640, Calgary, AB T2P 3H2, CA
- 6345 Dixie Rd, Suite 6, Mississauga, ON L5T 2E6, CA
- 244 Pall Mall St, Suite 400, London, ON N6A 5P6, CA
- 4 Cedar Pointe Dr, Unit D, Barrie, Ontario L4N 5R7, CA
- 2456 Queen St E, Unit 201, Brampton, Ontario L6S 5X9, CA
- 10 Stanley St, Suite 4A, Brantford, Ontario N3S 7N4, CA
- 7055 Boulevard Taschereau, Suite 100, Brossard, Quebec J4Z 1A7, CA
- 1100 Walkers Line, Suite 105, Burlington, Ontario L7N 2G3, CA
- 10655 Southport Rd SW, Suite 1200, Calgary, Alberta T2W 4Y1, CA
- 495 36 St NE, Suite 140, Calgary, Alberta T2A 6K3, CA
- 321 6 Ave SW, Suite W940 (West Tower), Calgary, Alberta T2P 0B2, CA
- 415 Hespeler Rd, Unit 3A, Cambridge, Ontario N1R 6J1, CA
- 6001 60 Ave, Delta, British Columbia V4K 4E2, CA
- 787 Rue St-Pierre, Suite 303, Drummondville, Quebec J2C 3X2, CA
- 10025 102A Ave NW, Suite 1902, Edmonton, Alberta T5J 2Z2, CA
- 2305 111 St NW, Edmonton, Alberta T6J 5E5, CA
- 5 Boulevard Mountain, Granby, Quebec J2G 9M5, CA
- 450 Speedvale Ave W, Unit 103, Guelph, Ontario N1H 7Y6, CA
- 1809 Barrington St, CIBC Building, Unit 501, Halifax, Nova Scotia B3J 3K8, CA
- 275 James St N, Unit 2, Hamilton, Ontario L8R 2L4, CA
- 7655 Boulevard Newman, Suite 75, Montreal, Quebec H8N 1X7, CA
- 2530 Boulevard Daniel-Johnson, Laval, Quebec H7T 2R3, CA
- 2528 Boulevard Daniel-Johnson, Laval, Quebec H7T 2R3, CA
- 5410 Boulevard Guillaume-Couture, Suite 84, Lévis, Quebec G6V 4Z2, CA
- 460 Rue St-Charles O, Suite A, Longueuil, Quebec J4Z 1A7, CA
- 80 Tiverton Ct, Suite 400, Markham, Ontario L3R 0G4, CA
- 7357 Woodbine Ave, Suite 2, Markham, Ontario L3R 1A7, CA
- 4080 Confederation Pkwy, Suite 501, Mississauga, Ontario L5B 0G1, CA
- 6345 Dixie Rd, Suite 6, Mississauga, Ontario L5T 2E6, CA
- 809 Columbia St, New Westminster, British Columbia V3M 1B9, CA
- 20 York Mills Rd, Unit 208, Toronto, Ontario M2P 2C2, CA
- 1600 Carling Ave, Suite 410, Ottawa, Ontario K1Z 1G3, CA
- 2222 Carling Ave, Suite 2, Ottawa, Ontario K2A 1H3, CA
- 4810 Boul Saint-Jean, Montréal, Quebec H9H 4B2, CA
- 755 Boulevard Saint-Jean, Suite 130, Pointe-Claire, Quebec H9R 5M9, CA
- 815 Boulevard Lebourgneuf, Suite 201, Québec, Québec G2J 0C1, CA
- 2010 11th Ave, 7th Floor, Regina, Saskatchewan S4P 0J3, CA
- 208 Boulevard du Curé-Labelle, Sainte-Thérèse, Quebec J7E 2X7, CA
- 3500 Boulevard de la Côte-Vertu, Suite 175, Saint-Laurent, Quebec H4R 2X7, CA
- 6335 Rue Jean-Talon Est, Saint-Léonard, Quebec H1S 3E7, CA
- 310 Wall St, Saskatoon, Saskatchewan S7K 1N7, CA
- 124 Rue Wellington Nord, Suite 300, Sherbrooke, Quebec J1H 5X8, CA
- 701 W Georgia St, Suite 200, Vancouver, British Columbia V7Y 1C6, CA
- 730 View St, Suite 420, Victoria, British Columbia V8W 3Y7, CA
- 100 Regina St S, Suite 140, Waterloo, Ontario N2J 4P9, CA
- 114 Dundas St E, Unit 103, Whitby, Ontario L1N 2H7, CA
- 245 Portage Ave, Winnipeg, Manitoba, CA
- 1 Lombard Pl, Suite 1535, Winnipeg, Manitoba R3B 0X3, CA
- 386 Boulevard Charest E, Quebec, QC G1K 3H4, CA
- Other recorded names
- Randstad Canada
- Specialties
- HR Consulting
- IT Recruitment
- Engineering Recruitment
- Staffing and HR
- HR Services
- Recruitment
- HR Outsourcing
- Temporary Hiring
- Permanent Hiring
- Recruiting
- Permanent Jobs
- Temp Jobs
- Hiring Strategy
- Human Resources
- Staffing
- Finding Jobs
- Employer Branding
- Jobs
- and Contract Jobs
- Profile identifies a recruitment agency
- Yes
As the Canadian leader in recruitment and HR, and one of Canada’s best places to work, we have a uniquely human approach to work. We deliver HR innovation with human interaction at its core. At the unique intersection of technology and humanity, we deliver data-driven insights coupled with a people-first experience that is inherently human. Human Forward. Learn more at www.randstad.ca.
| Field | Value |
|---|---|
| Industry | Staffing and Recruiting |
| Company size | 501-1,000 employees |
| Headquarters | Toronto, ON |
| Organization type | Public Company |
| Year founded | 1997 |
| Specialties | HR ConsultingIT RecruitmentEngineering RecruitmentStaffing and HRHR ServicesRecruitmentHR OutsourcingTemporary HiringPermanent HiringRecruiting |
| Open jobs on Jobsy | 9,406 |
| View page |
Job description
Our client, is seeking an experienced, highly detail-oriented SAS Data Engineer to join their enterprise data platforms group to support a critical Enterprise Data Warehouse (EDW) modernization initiative.
In this high-impact technical role, you will be responsible for analyzing existing EDW data structures, assessing legacy SAS workloads, and converting complex SAS programs and macros into optimized PySpark pipelines running on a target Databricks data platform. Operating within a fast-paced banking environment, you will trace source-to-target data flows, map complex business logic, and conduct rigorous source-to-target data validation to ensure total functional equivalence and data reconciliation between legacy systems and the new cloud ecosystem.
Duration: 2-Month Contract (with potential for extension)
Work Arrangement: Hybrid (3 days per week on-site at the corporate office, 2 days remote)
Advantages
High-Impact Data Modernization: Direct the conversion of critical enterprise data pipelines from legacy SAS environments to modern Databricks and PySpark cloud architectures.
Top-Tier Financial Exposure: Gain valuable experience within a leading global banking institution's core data technology group.
Specialized Migration Scope: Leverage your niche expertise in both SAS legacy frameworks and modern PySpark code optimization.
Balanced Hybrid Model: Enjoy a predictable hybrid schedule combining remote work flexibility with 3 collaborative on-site days per week.
Responsibilities
EDW Technical Data Analysis: Analyze Enterprise Data Warehouse tables, underlying data structures, dependencies, data volumes, historical trends, and usage patterns.
SAS Workload Assessment: Conduct thorough code reviews of existing SAS programs, macros, datasets, and execution dependencies to extract core business and technical transformation logic.
SAS-to-PySpark Conversion: Translate and refactor legacy SAS transformation and processing logic into clean, scalable PySpark code on the Databricks platform while ensuring complete functional equivalence.
Data Mapping & Lineage: Trace and document source-to-target data flows, complex joins, filter conditions, and downstream dependencies across EDW and SAS workloads.
Data Validation & Reconciliation: Execute rigorous source-to-target data profiling and reconciliation to validate PySpark outputs against existing SAS and EDW baseline results.
Qualifications
Professional Experience: 6 to 9 years of dedicated data engineering experience, preferably within the banking or financial services industry.
Legacy SAS Mastery: Deep technical proficiency in reading, analyzing, and deciphering complex SAS programs, macros, datasets, and data processing pipelines.
PySpark & Databricks Expertise: Strong hands-on experience authoring, optimizing, and deploying PySpark code within a Databricks environment.
EDW & Data Architecture: Solid understanding of Enterprise Data Warehouse concepts, relational data structures, source-to-target mapping, and data lineage tracing.
Reconciliation & Quality Control: Demonstrated track record performing data validation, automated quality checks, and output reconciliation between legacy and target systems.
Summary
If you are a tech-savvy SAS Data Engineer who pairs 6 to 9 years of financial services experience with expert SAS legacy code analysis and hands-on PySpark/Databricks development skills, this 2-month hybrid contract opportunity is an ideal next step. Bring your pipeline conversion precision, data validation rigor, and collaborative mindset to our client's data modernization 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 high-impact technical role, you will be responsible for analyzing existing EDW data structures, assessing legacy SAS workloads, and converting complex SAS programs and macros into optimized PySpark pipelines running on a target Databricks data platform. Operating within a fast-paced banking environment, you will trace source-to-target data flows, map complex business logic, and conduct rigorous source-to-target data validation to ensure total functional equivalence and data reconciliation between legacy systems and the new cloud ecosystem.
Duration: 2-Month Contract (with potential for extension)
Work Arrangement: Hybrid (3 days per week on-site at the corporate office, 2 days remote)
Advantages
High-Impact Data Modernization: Direct the conversion of critical enterprise data pipelines from legacy SAS environments to modern Databricks and PySpark cloud architectures.
Top-Tier Financial Exposure: Gain valuable experience within a leading global banking institution's core data technology group.
Specialized Migration Scope: Leverage your niche expertise in both SAS legacy frameworks and modern PySpark code optimization.
Balanced Hybrid Model: Enjoy a predictable hybrid schedule combining remote work flexibility with 3 collaborative on-site days per week.
Responsibilities
EDW Technical Data Analysis: Analyze Enterprise Data Warehouse tables, underlying data structures, dependencies, data volumes, historical trends, and usage patterns.
SAS Workload Assessment: Conduct thorough code reviews of existing SAS programs, macros, datasets, and execution dependencies to extract core business and technical transformation logic.
SAS-to-PySpark Conversion: Translate and refactor legacy SAS transformation and processing logic into clean, scalable PySpark code on the Databricks platform while ensuring complete functional equivalence.
Data Mapping & Lineage: Trace and document source-to-target data flows, complex joins, filter conditions, and downstream dependencies across EDW and SAS workloads.
Data Validation & Reconciliation: Execute rigorous source-to-target data profiling and reconciliation to validate PySpark outputs against existing SAS and EDW baseline results.
Qualifications
Professional Experience: 6 to 9 years of dedicated data engineering experience, preferably within the banking or financial services industry.
Legacy SAS Mastery: Deep technical proficiency in reading, analyzing, and deciphering complex SAS programs, macros, datasets, and data processing pipelines.
PySpark & Databricks Expertise: Strong hands-on experience authoring, optimizing, and deploying PySpark code within a Databricks environment.
EDW & Data Architecture: Solid understanding of Enterprise Data Warehouse concepts, relational data structures, source-to-target mapping, and data lineage tracing.
Reconciliation & Quality Control: Demonstrated track record performing data validation, automated quality checks, and output reconciliation between legacy and target systems.
Summary
If you are a tech-savvy SAS Data Engineer who pairs 6 to 9 years of financial services experience with expert SAS legacy code analysis and hands-on PySpark/Databricks development skills, this 2-month hybrid contract opportunity is an ideal next step. Bring your pipeline conversion precision, data validation rigor, and collaborative mindset to our client's data modernization 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.
Journal
Only you can see this. Kept on this device, and in your account when you sign in.