Technical Architect (Migrations)

Location: Hybrid in Melbourne or Sydney, Australia; travel to customer sites within Australia and New Zealand as needed.

Company

Snowflake provides the AI Data Cloud and helps enterprises modernize data workloads and achieve greater value from their data.

What you will do

• Lead technical design for migrations from Teradata, Oracle, Netezza, SQL Server, Hadoop, and other legacy platforms to Snowflake, covering data, code, pipelines, and security.
• Run migration assessments, analyze legacy code and workloads, and produce migration plans, estimates, and target architectures.
• Use SnowConvert and Snowflake migration accelerators for SQL, stored procedure, and ETL conversion, identifying work requiring manual implementation.
• Modernize pipelines with Snowpark, Dynamic Tables, Snowpipe, and Streams and Tasks, optimizing performance, cost, and governance.
• Plan data validation, performance testing, and production cutovers while advising customer architects, engineering leaders, and SI partners.
• Support migration scoping and Statements of Work, and turn field experience into reusable patterns, accelerators, and best practices.

Requirements

• 8+ years of experience in data engineering, data warehousing, or database architecture, including customer-facing consulting or delivery work.
• Hands-on leadership of 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, dbt, or similar, plus 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.
• Clear communication with technical teams and business stakeholders, including leading workshops and presenting recommendations.
• Ability to travel to customer sites within Australia and New Zealand as needed.

Nice to have

• SnowPro Core or SnowPro Advanced Architect certification.
• Experience with SnowConvert or other automated code conversion tools.
• Experience using GenAI or Snowflake Cortex AI for code conversion, testing, or data validation.
• Teradata, Oracle Exadata, or Hadoop administration or development experience.
• Experience working with SI partners on large delivery programs.

Culture & Benefits

• Work in a fast-moving, experimental environment focused on impact, innovation, collaboration, and practical use of AI.
• Contribute to complex, high-impact migration projects 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.
• Hybrid work based in Melbourne or Sydney, with customer-site travel required as needed.