Senior Business Data 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

Senior Business Data Analyst (Data Migration & Salesforce) Full-Time (35hpw) Temporary to 30 June 2027 Salary Range $133,348 - $146,945pa + super + leave loading Parramatta location with hybrid working Program: End-to-End Compliance Program

About the role

BCNSW is seeking a Senior Business Analyst (Data Migration & Salesforce) to support a major Salesforce‑led transformation program within a NSW Government regulatory environment. The role will provide data analysis leadership for all data migration activities, ensuring legacy data is accurately analysed, cleansed, transformed, mapped, validated, and migrated to the future‑state Salesforce platform. Working closely with business stakeholders, technical teams, and implementation partners, the role will drive data readiness and support delivery of one of the program's most critical workstreams. This is a Data Analyst role with hands‑on experience in data migration. The successful candidate will combine strong business analysis capabilities with hands‑on experience in data migration planning, data quality assessment, source‑to‑target mapping, and Salesforce data migration activities. The role will ensure data migration requirements are understood, documented, governed, and successfully transitioned into delivery.

Key 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.

Required skills and experience

• Demonstrated experience delivering data migration workstreams as part of large‑scale digital transformation programs.
• 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.

Highly Desirable

• Experience delivering Salesforce implementation or transformation programs.
• Experience with Salesforce Public Sector Solutions (PSS) preferred but not mandatory
• Experience within government, regulatory, compliance, enforcement, or public‑sector environments preferred
• Experience working with data migration tools and frameworks in large enterprise environments required
• Relevant Salesforce, Business Analysis, Data Management, or related professional certifications.

Role Clarification

This is a Senior Business Analyst role with a strong focus on data migration, data quality, and Salesforce data readiness. The role is responsible for defining, analysing, governing, and supporting migration activities from business discovery through to implementation and post‑go‑live validation. The role does not perform solution development or Salesforce configuration activities, which will be delivered by the implementation partner. Instead, the focus is on ensuring that migration requirements, mappings, data quality activities, testing, and reconciliation processes are effectively planned and executed to support a successful Salesforce implementation.

Success Measures

• Successful profiling, cleansing, and preparation of legacy data for migration.
• Delivery of complete and accurate source‑to‑target mappings and migration artefacts.
• Reduction of data quality risks impacting implementation and operational readiness.
• Successful completion of migration testing, validation, and reconciliation activities.High‑quality migration of data to Salesforce with minimal business disruption.
• Effective stakeholder engagement and alignment across business, technical, and vendor teams.

Further Information

Salary Grade 9/10, with the base salary for this role starting at 133,348 base plus superannuation

For enquiries relating to recruitment please contact Bec Conquest via [e-mail].

Closing Date

Closing Date: 11:59pm Wednesday 21st October 2026

Careers at Department of Customer Service

A career at the Department of Customer Service (DCS) gives you the opportunity to help improve government services and be part of reform that benefits people across NSW. We are focused on delivering excellent customer service, digital transformation, and regulatory reform. Come join us and influence the future of our great state.

Belong in our diverse and inclusive workplace

The strength of our workforce lies in its diversity and embracing difference, while the key to our success is leveraging the contributions of employees with different backgrounds and perspectives.

We provide adjustments to the recruitment process for candidates, including individuals with disability. If you require an adjustment during the recruitment process, including alternate formats or have questions about the support available, please contact Talent Operations on 02 8276 8130 or [e-mail]. For more information, please visit Information on some of the different types of disabilities Information on adjustments available for the recruitment process