Data Migration Specialist (Sydney or Melbourne)

AlphaSys Pty Ltd; Melbourne; Hybrid; AUD 140,000 - 190,000; Full time

Job summary

AlphaSys Pty Ltd is seeking a Data Migration Specialist to lead end-to-end data migration projects in Australia, including Salesforce implementations. This client-facing role requires hands-on delivery, architecture input and mentoring of teammates.

You will run workshops, design scalable migration solutions, and ensure data quality and governance across multiple client environments, with a focus on nonprofits and associations.

Qualifications

• 8–10 years of hands-on data migration experience
• Salesforce Migration expertise including Bulk API
• Proficient in MSSQL, SSIS, SSDT, and Visual Studio
• Strong data modelling, ETL design and data governance
• Experience migrating nonprofit CRM data is a plus
• Based in Australia with right to work full-time

Responsibilities

• Lead and facilitate client data workshops to gather requirements and define data migration strategies.
• Design and deliver fit-for-purpose data migration solutions across varied client environments.
• Hands on end-to-end data migration into Salesforce, including planning, design, build, testing and deployment.
• Perform data analysis and develop clear, well-documented migration approaches and strategy designs.
• Lead data team members to ensure successful project delivery and contribute to capability uplift within the team.
• Collaborate with Project Managers on timelines, risks, budgets and stakeholder communication.
• Build strong client relationships and provide practical, consultative advice on data solutions.
• Ensure data quality, data referential integrity and data governance best practices are upheld across all deliverables.

Skills

ETL & data engineering

Data quality & governance

Strong communication

Documentation & stakeholder mgmt

Mentoring teammates

Agile & Waterfall

Nonprofit sector passion

Tools

MSSQL

SSIS

SSDT

Visual Studio

Salesforce Migration

Bulk API

Salesforce CRM

Job description

Data Migration Specialist (Sydney or Melbourne)

We are seeking an experienced Data Migration Specialist to deliver end-to-end data migration projects across a diverse client base, including nonprofits, charities, community service organisations and professional associations.

This is a hands-on, client-facing role where you will be responsible for shaping and delivering data migration projects, from discovery and design through to implementation and handover. You will work closely with cross-functional teams including Solution Architects, Developers, Designers and Project Managers to deliver high-quality, scalable solutions.

You will also play a key role in guiding clients through their data migration journey, acting as a trusted advisor to ensure solutions are practical, sustainable and aligned with project goals.

Responsibilities:

• Lead and facilitate client data workshops to gather requirements and define data migration strategies.
• Design and deliver fit-for-purpose data migration solutions across varied client environments.
• Hands on end-to-end data migration into Salesforce, including planning, design, build, testing and deployment.
• Perform data analysis and develop clear, well-documented migration approaches and strategy designs.
• Lead data team members to ensure successful project delivery and contribute to capability uplift within the team.
• Collaborate with Project Managers on timelines, risks, budgets and stakeholder communication.
• Build strong client relationships and provide practical, consultative advice on data solutions.
• Ensure data quality, data referential integrity and data governance best practices are upheld across all deliverables.

Qualifications:

• Experience: Typically 8–10 years' hands‑on experience delivering data solutions, with a strong track record in the Microsoft data stack (MSSQL, SSIS, SSDT, Visual Studio).
• Salesforce Migration (Crucial): Proven capability delivering full end-to-end data migration into Salesforce CRM, including familiarity with Bulk API, sandbox environments and the Salesforce object model.
• SQL Mastery (Crucial): Advanced ability to design, write and optimise complex SQL queries, views and stored procedures.
• Deep Data Expertise (Crucial): Expert-level skills across the data domain, including data migration, ETL, data modelling and pipeline development.
• Project Delivery: Successfully delivered 5 or more complex data migration projects end-to-end.
• Nonprofit CRM Experience: Experience migrating data from nonprofit systems such as ThankQ, NPSP, Nonprofit Cloud, Penelope or Carelink.
• Location: Must be based in Australia (preferably Melbourne) and have a valid permit to work full‑time and long‑term.

Skills:

• Strong ETL and data engineering capability, including pipeline development, transformation logic and optimisation.
• Accuracy mindset with a strong focus on data quality, integrity and accuracy.
• Solid understanding of the full data lifecycle, including ingestion, transformation, data management, orchestration, security and pipeline deployment.
• Excellent communication skills, both written and verbal, with strong problem-solving, documentation and stakeholder management capability.
• Ability to produce high-quality documentation, including data artefacts, mappings, process maps, architecture diagrams and requirements specifications.
• Experience working effectively across both Agile and Waterfall delivery methodologies.
• Demonstrated ability to guide and mentor team members, supporting professional growth within project teams.
• Passion for the for‑purpose sector or prior experience delivering projects within nonprofit organisations.