Data Migration Specialist

AlphaSys; City of Melbourne; On-site; AUD 130,000 - 170,000; Full time

Job summary

AlphaSys is seeking an experienced Data Migration Specialist to deliver end-to-end data migration projects across nonprofits, charities, community service organisations and professional associations. This is a hands-on, client-facing role shaping solutions from discovery through to handover.

You will collaborate with cross-functional teams including Solution Architects, Developers, Designers and Project Managers to deliver high-quality, scalable solutions and guidance through the data migration

Qualifications

• 8–10 years hands-on experience delivering data solutions with the Microsoft data stack.
• Proven capability delivering end-to-end Salesforce data migration including Bulk API and sandboxes.

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

SQL mastery

Salesforce migration

Data modelling

Data pipeline

Stakeholder management

Mentoring teams

Tools

MSSQL

SSIS

SSDT

Visual Studio

Job description

Job Overview:

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.