Senior Data Migration & Salesforce Analyst

the original; Sydney; Hybrid; AUD 133,000 - 147,000; Full time

Job summary

BCNSW is seeking a Senior Business Analyst with data migration and Salesforce expertise to support a major Salesforce-led transformation in a NSW Government regulatory environment.

The role leads data discovery, mapping, quality, and readiness across legacy systems, collaborating with business stakeholders, SMEs, and implementation partners to ensure a successful migration and governance throughout the program.

Qualifications

• Demonstrated experience delivering data migration workstreams as part of large-scale digital transformation programmes.
• Strong business analysis experience, including requirements elicitation, process analysis, stakeholder engagement, and documentation.
• Hands-on experience in data profiling, cleansing, transformation, validation, reconciliation, and migration planning.
• Strong experience developing and maintaining source-to-target mappings, migration specifications, data dictionaries, business rules, and data quality artefacts.
• Experience analysing and working with complex datasets from multiple source systems.
• Strong understanding of Salesforce data models, object relationships, field mapping, data dependencies, and migration impacts.
• Hands-on experience with Salesforce Data Loader and data migration or ETL tools such as MuleSoft, Informatica, Talend, Azure Data Factory, or equivalent.
• Experience using SQL and database query tools to extract, analyse, validate, and reconcile data.
• Advanced Microsoft Excel skills, including large dataset analysis, reconciliation, reporting, lookup functions, and pivot tables.
• Experience supporting migration testing, cutover planning, post-migration validation, and reconciliation activities.
• Strong communication and stakeholder management skills, with the ability to work effectively across business and technical teams.

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 and escalated 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

Business analysis

Stakeholder engagement

SQL

Excel

Data profiling

Data quality

Requirements elicitation

Salesforce concepts

Education

Bachelor’s degree in Information Technology or related field

Tools

Salesforce Data Loader

MuleSoft

Informatica

Talend

Azure Data Factory

Job description

BCNSW is seeking a Senior Business Analyst with data migration and Salesforce expertise to support a major Salesforce-led transformation in a NSW Government regulatory environment.

The role leads data discovery, mapping, quality, and readiness across legacy systems, collaborating with business stakeholders, SMEs, and implementation partners to ensure a successful migration and governance throughout the program.