Snowflake

Technical Architect, Migrations

Snowflake
Apply
6 hours ago
Sydney, Australia or Melbourne, AustraliaSenior

Responsibilities

  • Lead the technical design of migrations from Teradata, Oracle, Netezza, SQL Server, Hadoop, and other legacy platforms to Snowflake.
  • Run migration assessments, analyze legacy code and workloads, and produce migration plans, estimates, and target architectures.
  • Use SnowConvert and Snowflake migration accelerators to automate SQL, stored procedure, and ETL conversion.
  • Modernize data pipelines with Snowpark, Dynamic Tables, Snowpipe, and Streams and Tasks while designing for performance, cost, and governance.
  • Plan and run data validation, performance testing, and production cutover.
  • Advise customer architects, engineering leaders, and systems-integration partners and resolve complex technical issues onsite and remotely.
  • Support Professional Services sales by scoping migration work, reviewing code assessments, and shaping Statements of Work.
  • Develop reusable migration patterns, accelerators, and best practices and share field feedback with Snowflake Product and Engineering.

Requirements

  • 8+ years of experience in data engineering, data warehousing, or database architecture, including customer-facing consulting or delivery work.
  • Hands-on experience leading at least one large data warehouse or database migration to a cloud data platform.
  • Deep SQL skills and strong knowledge of data modeling, performance tuning, and data warehouse design.
  • Experience with ETL/ELT tools such as Informatica, DataStage, Talend, or dbt and with orchestration and pipeline design.
  • Programming experience in Python, Java, or Scala.
  • Working knowledge of at least one major cloud provider: AWS, Azure, or Google Cloud.
  • Ability to communicate with technical teams and business stakeholders, lead workshops, and present recommendations.
  • Ability to travel to customer sites within Australia and New Zealand as needed.
  • SnowPro Core or SnowPro Advanced Architect certification is a bonus.
  • Experience with SnowConvert, automated code conversion tools, GenAI, Snowflake Cortex AI, Teradata, Oracle Exadata, Hadoop, or systems-integration partners is a bonus.

Benefits

  • Work on complex, high-impact migrations for major organizations across Australia and New Zealand.
  • Learn from a global community of migration experts and help shape Snowflake's migration tools and methods.
  • Location: Melbourne or Sydney, Australia, with travel to customer sites in Australia and New Zealand as needed.

Tech Stack

Apache HadoopAWSAzuredbtGoogle CloudInformaticaJavaMicrosoft SQL ServerPythonScalaSnowflakeSQLTalend

Categories

Solutions Engineering
Snowflake

About Snowflake

10,000+ employees

Snowflake builds a cloud-native data platform used by enterprises to store, integrate, share, and analyze data across AWS, Azure, and Google Cloud. Its core products span data warehousing, data lakes, data engineering, and governed data sharing, sold via consumption-based subscriptions. Founded in 2012 and publicly traded on the NYSE (SNOW) following a 2020 IPO, Snowflake supports analytics and data application workloads across industries.

Contact me