Data Migration Specialist

This is a fully remote position, open to applicants in Australia.

📋 Description

• Lead and facilitate workshops with clients to collect requirements and establish data migration strategies.

• Design and implement tailored data migration solutions across diverse client environments.

• Plan, design, construct, test, and deploy comprehensive data migrations into Salesforce.

• Conduct data analysis and create clear, well-documented strategies and approaches for migration.

• Guide data team members and contribute to enhancing team capabilities.

• Collaborate with Project Managers regarding timelines, risks, budgets, and stakeholder communications.

• Build robust client relationships and offer practical, consultative advice on data solutions.

• Maintain data quality, referential integrity, and adhere to data governance best practices across deliverables.

• Execute data migration projects for nonprofits, charities, community service organizations, and professional associations.

⛳️ Requirements

• Typically possess 8–10 years of hands-on experience in delivering data solutions.

• Strong history of working with the Microsoft data stack (MSSQL, SSIS, SSDT, Visual Studio).

• Proven expertise in delivering complete end-to-end data migrations into Salesforce CRM.

• Familiarity with Salesforce Bulk API, sandbox environments, and the Salesforce object model.

• Advanced skills in designing, writing, and optimizing complex SQL queries, views, and stored procedures.

• Expert-level proficiency in data migration, ETL, data modeling, and pipeline development.

• Successfully completed 5 or more intricate data migration projects from start to finish.

• Experience in migrating data from nonprofit systems such as ThankQ, NPSP, Nonprofit Cloud, Penelope, or Carelink.

• Must reside in Australia, preferably in Melbourne.

• Valid authorization to work full-time and long-term in Australia.

• Strong ETL and data engineering expertise, including pipeline development, transformation logic, and optimization.

• Emphasis on data quality, integrity, and accuracy.

• Comprehensive understanding of the entire data lifecycle, including ingestion, transformation, management, orchestration, security, and pipeline deployment.

• Excellent written and verbal communication skills.

• Strong problem-solving abilities, documentation skills, and stakeholder management capabilities.

• Ability to produce high-quality documentation, including data artifacts, mappings, process maps, architecture diagrams, and requirements specifications.

• Experience with both Agile and Waterfall delivery methodologies.

• Demonstrated capability to mentor and guide team members.

• Passion for the purpose-driven sector or previous experience in delivering projects for nonprofit organizations.

🏝️ Benefits

• Contract position.

• Opportunity to collaborate with nonprofits, charities, community service organizations, and professional associations.

• Opportunities for professional growth and skill enhancement through guiding and mentoring team members.