AS Migration SME / SAS Architect

Location: UK – Hybrid / On-site
Duration: ~8 weeks
Start: ASAP
Engagement: Contract

We are looking for a SAS Migration SME / SAS Architect to support an urgent SAS-to-Snowflake migration discovery project for a major UK financial services organisation.

The initial engagement will focus on assessing the existing SAS estate, determining migration complexity and effort, and defining the approach and migration waves into Snowflake.

Key Responsibilities

• Assess and catalogue a large enterprise SAS estate.

• Review Base SAS, SAS Macros, DATA Steps, PROC SQL, SAS DI Studio and SAS Grid/Viya workloads.

• Analyse code complexity, dependencies and migration suitability.

• Produce complexity scoring, effort estimates and migration wave plans.

• Identify opportunities and challenges in converting SAS workloads to Snowflake SQL / Snowpark Python.

• Support the use of automated migration tooling such as Snowflake AIM / SnowConvert.

• Provide technical guidance around SAS-to-Snowflake conversion and target-state architecture.

• Work closely with data engineering and architecture teams to establish migration priorities and approach.

• Document findings and provide recommendations to stakeholders.

Essential Experience

• Strong enterprise SAS background with significant hands-on experience across:

  • Base SAS

  • SAS Macros

  • DATA Steps

  • PROC SQL

  • SAS Data Integration Studio

  • SAS Grid and/or SAS Viya

• Previous experience delivering or supporting SAS migration / modernisation programmes.

• Strong understanding of SAS-to-Snowflake migration.

• Experience assessing a SAS estate and producing complexity, effort and migration-wave assessments.

• Knowledge of Snowflake SQL and/or Snowpark Python.

• Previous banking / financial services experience.

• UK-based and able to work on-site when required.

• Able to pass financial services security/vetting requirements.

Desirable Experience

• Experience with Snowflake AIM / SnowConvert or similar SAS conversion tooling.

• Experience migrating risk, regulatory or IFRS 9 models.

• dbt experience.

• Airflow experience.

• Experience working with large, regulated SAS estates.