Job Title

SAS DeveloperClient: Canada's Largest Agricultural Term LenderDuration: 6 month contract (Possible extension)Location: Remote, Canada, hours flexibleHours per week: 37.5On behalf of our client, Affinity is looking for SAS Developer to support a large enterprise data migration initiative. This project involves converting existing SAS workloads to run against AWS Redshift, ensuring all existing logic and outputs remain consistent.Responsibilities: Convert SAS jobs to source data from AWS Redshift Update:o LIBNAME statementso SQL queries and data access logico Data Integration Studio jobs Ensure existing business logic and outputs remain unchanged Perform unit testing and support user acceptance testing Investigate and resolve data discrepancies Collaborate with business stakeholders to achieve sign-offQualifications: 47 years SAS experience Strong SQL and data processing skills Comfortable handling end-to-end development and testing Strong experience with SAS (Base SAS, PROC SQL) Solid SQL skills and experience working with relational databases Experience with data migration, ETL, or legacy system modernization Strong debugging and data validation skills Ability to work independently in a fast-paced environmentNice to Have Experience:o SAS Data Integration Studioo DS2o SAS Business Rules Manager Experience working with AWS Redshift or similar platforms (Teradata, Oracle, Snowflake) Familiarity with AWS environmentsAffinity Earn:Know someone whos great for this, or any of our open roles? Earn up to $4,000/year for each successful referral through Affinity Earn. You can also earn up to $50,000 for helping us find new clients. Learn about our referral program at https://affinity-group.ca/earn/ or browse our jobs & follow us at https://www.linkedin.com/company/affinity-staffing/jobs/About Affinity:Affinity Group is a technology and business consulting and services company. We believe in creating long term relationships between clients and consultants that foster a mutually beneficial partnership. Affinity is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. All employment is decided on the basis of qualifications, merit and business need.For more information on Affinity, please visit www.affinity-group.caAffinity Earn:Know someone whos great for this, or any of our open roles? Earn up to $4,000/year for each successful referral through Affinity Earn. You can also earn up to $50,000 for helping us find new clients. Learn about our referral program at https://affinity-group.ca/earn/ or browse our jobs & follow us at https://www.linkedin.com/company/affinity-staffing/jobs/About Affinity:Affinity Group is a technology and business consulting and services company. We believe in creating long term relationships between clients and consultants that foster a mutually beneficial partnership. Affinity is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. All employment is decided on the basis of qualifications, merit and business need.For more information on Affinity, please visit www.affinity-group.ca#LI-RemoteJob Number: 13320