# Technical Architect, Migrations

**Company**: Snowflake
**Location**: Melbourne, Victoria
**Work arrangement**: hybrid
**Experience**: senior
**Job type**: full-time
**Category**: Engineering
**Industry**: Technology

**Apply**: https://jobs.ashbyhq.com/snowflake/527f30a7-edf5-43f4-b573-7df77987e5d8?utm_source=yubhub.co&utm_medium=jobs_feed&utm_campaign=apply
**Canonical**: https://yubhub.co/jobs/job_b618dd8c-5cb

## Description

At Snowflake, we are powering the era of the agentic enterprise. To usher in this new era, we seek AI-native thinkers across every function who are energized by the opportunity to reinvent how they work.

As a Technical Architect, Migrations at Snowflake, you will be the hands-on technical lead on migration projects. You will design the target architecture and guide customers and partners from assessment through to go-live.

Responsibilities:

- Lead the technical design of migrations from Teradata, Oracle, Netezza, SQL Server, Hadoop and other legacy platforms to Snowflake, covering data, code, pipelines and security.

- Run migration assessments, analyse legacy code and workloads, and produce clear migration plans, estimates and target architectures.

- Use SnowConvert and Snowflake migration accelerators to automate SQL, stored procedure and ETL conversion, and guide teams on the parts that need manual work.

- Modernise data pipelines with Snowpark, Dynamic Tables, Snowpipe, and Streams and Tasks, and design for performance, cost and governance on Snowflake.

- Plan and run data validation, performance testing and cutover so customers move to production with confidence.

- Act as the trusted technical advisor to customer architects, engineering leaders and SI partners, and solve complex technical issues on site and remotely.

- Support Professional Services sales by scoping migration work, reviewing code assessments and shaping Statements of Work.

- Turn lessons from the field into reusable migration patterns, accelerators and best practices, and share 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, dbt or similar, 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).

- 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 to speed up code conversion, testing or data validation.

- Background in Teradata, Oracle Exadata or Hadoop administration or development.

- Experience working with SI partners on large delivery programs.

## Skills

### Required
- data engineering
- data warehousing
- database architecture
- SQL
- ETL/ELT tools
- Python
- Java
- Scala
- cloud computing

### Nice to have
- SnowPro Core
- SnowPro Advanced Architect
- SnowConvert
- GenAI
- Snowflake Cortex AI
- Teradata
- Oracle Exadata
- Hadoop administration

---

Source: [Apply at jobs.ashbyhq.com](https://jobs.ashbyhq.com/snowflake/527f30a7-edf5-43f4-b573-7df77987e5d8?utm_source=yubhub.co&utm_medium=jobs_feed&utm_campaign=apply)
