Data Migration Consultant

Mtx Apac; Melbourne; Hybrid; AUD 110,000 - 150,000; Full time

Benefits offered by this job

Hybrid work in Melbourne

Health benefits

Professional development

Flexible working hours

Job summary

MTX APAC is seeking a Data Migration Consultant to partner with clients on complex Salesforce data transformations. You will profile, map, and load data across the source and target models, ensure data quality, and support validation and cutover activities.

The role is based in Australia with hybrid work in Melbourne, offering opportunities to own data domains and drive issues to resolution across migration cycles.

Qualifications

• Experience in data migration, conversion, ETL, analysis or data engineering.
• Experience with Salesforce data loading or comparable CRM migration activities.
• Working SQL knowledge and ability to manipulate, validate and reconcile structured data.
• Experience producing source-to-target mappings and transformation rules.
• Strong attention to detail and systematic approach to data issues.
• Clear communication within a multidisciplinary delivery team.

Responsibilities

• Profile source data to identify structure, quality issues and referential integrity.
• Develop or support ETL routines and load processes for Salesforce targets.
• Prepare load files and sequence objects while preserving relationships and external IDs.
• Execute controlled migrations across development, test, and production environments.
• Maintain run logs, reconciliation reports and defect evidence.

Skills

Data migration

ETL

SQL

Data analysis

Stakeholder comms

Python

Education

Bachelor's degree in CS/IS

Tools

Salesforce Data Loader

Workbench

Bulk API

Python

Mulesoft

Informatica

Azure Data Factory

Job description

MTX is looking for a Data Migration Consultant who is comfortable getting into the detail. You will work across source data, business rules and the Salesforce target model to profile, map, transform, load and reconcile data through each migration cycle. You will own the data domains assigned to you, keep the evidence clear and raise issues while there is still time to act on them.

MTX APAC is a global cloud technology consulting firm that enables organisations to modernise through digital transformation. With expertise in the government and public sector, MTX APAC provides proprietary designs and innovative concept accelerators around a multitude of programs, including strategic blueprinting, licensing and permitting, inspections, grants management, case management, and program management. We are a Salesforce Summit partner with specialist expertise in Sales, Service and Experience Cloud, Health Cloud, Public Sector Solutions (PSS), Tableau, Mulesoft, Marketing Cloud.

Location:

Australia hybrid, Melbourne preferred

What you will own

Data analysis and mapping

• Profile source data to identify structure, volume, quality, anomalies and referential integrity issues.
• Support workshops to confirm data definitions, mappings, transformation rules and ownership.
• Maintain source-to-target mappings, data dictionaries, rule catalogues and issue logs.
• Work with data owners to resolve duplicates, invalid values, gaps and quality concerns.

Migration build and execution

• Develop or support extraction, transformation and load routines using approved tools and scripts.
• Prepare load files and sequence Salesforce objects while preserving relationships and external identifiers.
• Execute controlled loads across development, test, rehearsal and production environments.
• Investigate failed records, correct defects and maintain repeatable rerun processes.

Validation and delivery support

• Complete record-count, field-level, relationship and exception reconciliation after each cycle.
• Familiarity with the common checksum approaches including MD5.
• Maintain run logs, reconciliation reports, defect evidence and migration outcomes.
• Support mock migrations, cutover planning, production migration and hypercare.
• Provide accurate progress updates and communicate data, access or environment blockers early.

What we are looking for:

Experience and capability

• Practical experience in data migration, conversion, ETL, analysis or data engineering.
• Experience with Salesforce data loading or comparable CRM migration activities.
• Working SQL knowledge and confidence manipulating, validating and reconciling structured data.
• Experience producing source-to-target mappings and transformation rules.
• Strong attention to detail and a systematic approach to investigating data issues.
• Clear communication skills and the ability to work effectively within a multidisciplinary delivery team.

Useful additional experience

• Experience with Salesforce Data Loader, Workbench, Bulk API or comparable tools.
• Experience with Python, PowerShell, MuleSoft, Informatica, Talend or Azure Data Factory.
• Knowledge of Salesforce relationships, external IDs, automation and security.
• Consulting or regulated-industry experience in Australia.

Certifications

• Salesforce Administrator is preferred or should be actively pursued; Platform App Builder or relevant data credentials are advantageous.

How we expect you to work

• Take ownership of your work and follow it through. If something is at risk, raise it early.
• Work as one team with our clients and delivery teams, with no ambiguity around who owns what.
• Use sound judgement and keep the documentation and evidence needed to support delivery decisions.
• Share what you know and help us improve the way we deliver.

What good looks like

• Assigned mappings, scripts and migration tasks are delivered accurately and on time.
• Data defects and exceptions are identified, documented and progressed to resolution.
• Migration runs are repeatable and supported by complete reconciliation evidence.
• The consultant grows in capability and works increasingly independently across migration cycles.

Working with us

You will join an experienced Salesforce delivery team working on complex transformation programs. We give people room to own their work, contribute to how we deliver and continue building their capability. The role is permanent and offers flexible hybrid working, with Melbourne as our preferred location.

Additional requirements

• Full Australian working rights and flexibility to attend client or team locations when required.
• Willingness to complete background, police or security checks where required by an engagement.
• A current Australian Government Baseline security clearance is required.

What we offer:

• Flexibility of remote work, enabling you to operate from the sanctuary of your home.
• Exclusive corporate discounts for Gold Standard Health Insurance provided by our trusted Health Partner.
• Benefit from our Employee Assistance Program
• Invest in your growth with paid training and development opportunities, including online courses and certifications.
• Engage in monthly All Hands company meetings featuring open discussions with our Leadership Team, encouraging transparency and collaboration.
• Thrive in a fast-paced setting alongside seasoned industry leaders, seizing opportunities for professional advancement.

MTX is an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, colour, religion, sex, sexual orientation, gender identity or expression, pregnancy, age, national origin, disability status, or any other characteristic protected by law.