Lead Data Migration Architect

Snowflake Inc.; Melbourne; On-site; AUD 180,000 - 260,000; Full time

Job summary

Snowflake Inc. in Australia seeks a Technical Architect, Migrations to lead end-to-end migrations from legacy platforms to Snowflake, shaping target architectures and guiding deployments across Australia and New Zealand.

You will collaborate with customers, partners, and Snowflake teams to design scalable data pipelines, perform assessments, and ensure successful go-lives with high quality and governance.

Qualifications

• 8+ years of experience in data engineering, data warehousing or database architecture.
• 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.

Responsibilities

• Lead the technical design of migrations from 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.

Skills

Data engineering

Data warehousing

Database architecture

SQL

Programming (Python/Java/Scala)

Cloud platforms (AWS/Azure/GCP)

Communication

Travel readiness

Tools

Informatica

DataStage

Talend

dbt

SnowConvert

Job description

Snowflake Inc. in Australia seeks a Technical Architect, Migrations to lead end-to-end migrations from legacy platforms to Snowflake, shaping target architectures and guiding deployments across Australia and New Zealand.

You will collaborate with customers, partners, and Snowflake teams to design scalable data pipelines, perform assessments, and ensure successful go-lives with high quality and governance.