Senior Data Migration & Salesforce Analyst

Department of Customer Service; Parramatta; Hybrid; AUD 133,000 - 147,000; Full time

Job summary

Department of Customer Service in Parramatta is seeking a Senior Business Data Analyst (Data Migration & Salesforce) to lead data migration activities within a Salesforce-led transformation for NSW Government. The role combines data analysis leadership with hands-on migration planning and governance to ensure accurate mapping, cleansing, and validation.

Based in NSW with hybrid work, the successful candidate will partner with business stakeholders, technical teams, and implementation partners to

Qualifications

• Experience delivering data migration workstreams in large-scale digital transformations.
• Strong business analysis including requirements elicitation and stakeholder engagement.
• Hands-on with data profiling, cleansing, transformation, validation, and migration planning.
• Experience with source-to-target mappings, data dictionaries, and data quality artefacts.
• Experience with Salesforce data models and migrations; Salesforce Data Loader and ETL tools.
• SQL and Excel proficiency.

Responsibilities

• Lead data discovery, assessment, and analysis activities across multiple legacy systems and data sources.
• Elicit, document, and validate business and data migration requirements with business stakeholders and SMEs.
• Develop and maintain source-to-target mapping documents, data dictionaries, transformation rules, migration specifications, and reconciliation artefacts.
• Analyse legacy data structures and define mapping approaches to Salesforce objects, fields, and relationships.
• Identify data quality issues and work with business stakeholders to establish remediation and cleansing strategies.
• Collaborate with Salesforce architects, implementation partners, and technical teams to support migration design and delivery activities.
• Support data governance, retention, archival, privacy, and compliance requirements throughout the migration lifecycle.
• Develop migration readiness assessments, migration plans, cutover activities, and deployment support processes.
• Support migration testing, dress rehearsals, defect management, data validation, and post-migration reconciliation activities.
• Produce reporting, analysis, and management information to support program governance, decision-making, and risk management.
• Identify andescalate migration-related risks, dependencies, and constraints in a timely manner.
• Work closely with business SMEs, vendors, and project teams to ensure successful delivery of migration outcomes.

Skills

Data migration

Data analysis

Stakeholder management

SQL

Excel

Data profiling

Requirements elicitation

Business analysis

Tools

Salesforce Data Loader

MuleSoft

Informatica

Talend

Azure Data Factory

Job description

Department of Customer Service in Parramatta is seeking a Senior Business Data Analyst (Data Migration & Salesforce) to lead data migration activities within a Salesforce-led transformation for NSW Government. The role combines data analysis leadership with hands-on migration planning and governance to ensure accurate mapping, cleansing, and validation.

Based in NSW with hybrid work, the successful candidate will partner with business stakeholders, technical teams, and implementation partners to