Data Migration Specialist

AlphaSys Pty Ltd; City of Melbourne; On-site; AUD 120,000 - 160,000; Full time

Job summary

AlphaSys Pty Ltd is seeking an experienced Data Migration Specialist to deliver end-to-end data migration projects for nonprofits, charities and professional associations in Australia. This hands-on, client-facing role shapes designs, guides discovery, and ensures successful handover.

You will collaborate with Solution Architects, Developers, Designers and PMs to deliver scalable, high-quality solutions across varied client environments.

Qualifications

• 8–10 years hands-on experience delivering data solutions with the Microsoft data stack.
• Salesforce Migration: end-to-end data migration including Bulk API and sandbox models.
• SQL mastery: design, write and optimise complex queries, views and stored procedures.
• Deep data expertise across ETL, data modelling, governance and pipelines.
• Experience leading data teams and delivering multiple projects end-to-end.
• Nonprofit CRM experience with ThankQ, NPSP, Nonprofit Cloud, Penelope or Carelink.

Responsibilities

• Lead and facilitate client data workshops to gather requirements and define strategies.
• Design and deliver fit-for-purpose data migration solutions across environments.
• Hands-on data migration into Salesforce, with planning, design, build, test and deploy.
• Perform data analysis and develop clear migration approaches and designs.
• Lead data team members to ensure successful project delivery and capability uplift.
• Collaborate with Project Managers on timelines, risks and budgets.
• Build strong client relationships and provide consultative data guidance.
• Ensure data quality, referential integrity and data governance across deliverables.

Tools

MSSQL

SSIS

SSDT

Visual Studio

Job description

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:

• Leadand facilitate client data workshops to gather requirements and define data migration strategies.
• Designand deliver fit-for-purpose data migration solutions across varied client environments.
• Handsonend-to-end data migration into Salesforce, including planning, design, build, testing and deployment.
• Performdata analysis and develop clear, well-documented migration approaches and strategy designs.
• Leaddata team members to ensure successful project delivery and contribute to capability uplift within the team.
• Collaboratewith Project Managers on timelines, risks, budgets and stakeholder communication.
• Buildstrong client relationships and provide practical, consultative advice on data solutions.
• Ensuredata quality,datareferentialintegrity anddatagovernance 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).
• SalesforceMigration (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.
• SQLMastery (Crucial): Advanced ability to design, write and optimise complex SQL queries, views and stored procedures.
• DeepData Expertise (Crucial): Expert-level skills across the data domain, including data migration, ETL, data modelling and pipeline development.
• ProjectDelivery: Successfully delivered 5 or more complex data migration projects end-to-end.
• NonprofitCRM 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:

• StrongETL and data engineering capability, including pipeline development, transformation logic and optimisation.
• Accuracymindset with a strong focus on data quality, integrity and accuracy.
• Solidunderstanding of the full data lifecycle, including ingestion, transformation, data management, orchestration, security and pipeline deployment.
• Excellentcommunication skills, both written and verbal, with strong problem-solving, documentation and stakeholder management capability.
• Abilityto produce high-quality documentation, including data artefacts, mappings, process maps, architecture diagrams and requirements specifications.
• Experienceworking effectively across both Agile and Waterfall delivery methodologies.
• Demonstratedability to guide and mentor team members, supporting professional growth within project teams.
• Passionfor the for-purpose sector or prior experience delivering projects within nonprofit organisations.