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.