SASSQL Developer

Overview

Adastra is looking for a SAS/SQL Developer to play a key role in delivering complex data migration and modernization initiatives. This position focuses on translating legacy data logic into efficient scalable solutions while ensuring data integrity and continuity across evolving platforms.

Youll work at the intersection of business and technologyinterpreting requirements refining data processes and helping teams move from legacy environments to modern streamlined data workflows. This is a hands-on role suited for someone who enjoys digging into existing systems improving them and seeing the direct impact of their work on business outcomes.

Primary Location: Toronto ON

Work Model: Hybrid 3-Days Onsite

Employment Type: Contractor

Vacancy Status: Backfill

RESPONSIBILITIES

• Modify and enhance SAS SQL and data integration processes to support migration from legacy systems to modern platforms
• Convert Datameer workflows to Dataiku and support related testing and validation activities
• Translate business requirements into SAS and SQL-based technical solutions
• Convert legacy stored procedures and database logic into optimized SQL scripts
• Create and maintain data mapping transformation logic and lineage documentation
• Perform data validation reconciliation and testing to ensure data accuracy and completeness
• Support business process verification and user acceptance testing (UAT) activities
• Collaborate with cross-functional teams including developers business analysts and project stakeholders
• Work independently to deliver assigned tasks within project timelines

QUALIFICATIONS SKILLS & EXPERIENCE

Required:

• Bachelors degree in Computer Science Information Technology or a related field
• 5 years of hands-on experience as an SAS/SQL Developer
• Strong SAS programming experience including Data Step Macros PROC and PROC SQL
• Advanced SQL development skills including query optimization and data manipulation
• Experience with data migration ETL processes and data integration
• Experience creating data mapping and lineage documentation
• Experience converting legacy database processes and stored procedures
• Working knowledge of Python for data processing or automation
• Ability to perform light Business Analyst activities including requirements gathering and documentation
• Strong analytical problem-solving and communication skills
• Proven ability to work independently and collaboratively in a fast-paced environment
• SAS certification required

Preferred:

• Demonstrated proficiency through technical assessment
• Experience working in large-scale data migration or modernization projects

NICE TO HAVE

• Experience with Hadoop Netezza Datameer and/or Dataiku
• Experience supporting analytics campaign management reporting scorecards or data curation processes
• Exposure to data warehousing concepts and large enterprise data environments

ABOUT ADASTRA

Adastra is a global leader in AI and data-driven transformation helping organizations lead with artificial intelligenceresponsibly strategically and at scale. With over 25 years of experience Adastra empowers enterprise clients to unlock business value through data innovation operational excellence and smart customer engagement.

Trusted by some of the worlds most prominent brands Adastra delivers end-to-end solutions grounded in thoughtful strategy robust governance and deep technical expertise. From defining vision to ensuring execution Adastra guides organizations through every stage of their AI data and cloud journeybuilding future-ready capabilities and delivering measurable lasting impact.

Adastra serves clients across key industries including financial services automotive manufacturing technology media and telecom (TMT) healthcare retail and professional services. The company employs more than 2000 professionals across North America Europe and Asia.

WHAT WE OFFER

• Opportunity for advancement and career progression
• Successful referral program
• The opportunity to work with one of Canadas 50 Best Managed Companies
• Satisfaction of working for a reputable company
• A flexible dynamic and diverse workplace

EQUAL OPPORTUNITY EMPLOYER

In our commitment to promote fair and equitable treatment of all employees and applicants Adastra Corporation provides equal employment opportunities for all individuals regardless of age sex disability race ethnic origin citizenship creed sexual orientation marital status or any other ground as described in the Ontario Human Rights Code.In addition accommodation will be provided during the hiring process. Adastra Corporations implementation and support of employment initiatives encourage diversified labour force participation and equal access to opportunities based on merit and performance.

AI Usage - Our hiring process includes the use of AI-enabled tools to screen applications (e.g. keyword matching qualification ranking). A human recruiter reviews all AI-generated shortlists to make informed hiring decisions.

There has been an increased instance of fraudulent job offers coming from people posing as Adastra HR employees. Please note that Adastra will never request fees as part of our recruiting process and any emails sent to you that are not from @ or @ are fraudulent. All employment offers are sent via DocuSign and if you receive an employment offer from a suspicious email and not via DocuSign it is fraudulent.

Contact to inquire about jobs at Adastra to report a suspicious request for money or personal information from external websites or suspicious employment offers.

Required Experience:

IC

Experience: years
Vacancy: 1