Senior Business Data Analyst
the original
Get a reply from this employer
Your resume and cover letter, tailored to exactly what they’re hiring for.
Benefits offered by this job
Job summary
NSW Department of Customer Service in Parramatta is seeking a Senior Business Analyst (Data Migration & Salesforce) to lead data migration activities within a Salesforce-led transformation program in 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.
Qualifications
- Demonstrated experience delivering datamigration 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 DataLoader 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 pivottables.
- 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 datamigration 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 elevate 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
Tools
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
BCNSW is seeking a Senior Business Analyst (Data Migration &Salesforce) to support a major Salesforce-led transformation program withina NSW Government regulatory environment.
The role will provide data analysis leadership for all data migrationactivities, 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 implementationpartners, the role will drive data readiness and support delivery of one of theprogram's most critical workstreams.
This is a Data Analyst role with hands-on experience in datamigration. The successful candidate will combine strong business analysiscapabilities with hands-on experience in data migration planning, data qualityassessment, 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.
- Lead data discovery, assessment, and analysisactivities across multiple legacy systems and data sources.
- Elicit, document, and validate business and datamigration requirements with business stakeholders and SMEs.
- Develop and maintain source-to-target mappingdocuments, data dictionaries, transformation rules, migrationspecifications, and reconciliation artefacts.
- Analyse legacy data structures and define mappingapproaches to Salesforce objects, fields, and relationships.
- Identify data quality issues and work withbusiness stakeholders to establish remediation and cleansing strategies.
- Collaborate with Salesforce architects,implementation partners, and technical teams to support migration designand 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 reconciliationactivities.
- Produce reporting, analysis, and managementinformation to support program governance, decision-making, and riskmanagement.
- Identify and elevate migration-related risks,dependencies, and constraints in a timely manner.
- Work closely with business SMEs, vendors, andproject teams to ensure successful delivery of migration outcomes.
- Demonstrated experience delivering datamigration workstreams as part of large-scale digital transformationprograms.
- Strong business analysis experience, includingrequirements elicitation, process analysis, stakeholder engagement, anddocumentation.
- Hands-on experience in data profiling, cleansing,transformation, validation, reconciliation, and migration planning.
- Strong experience developing and maintaining source-to-targetmappings, migration specifications, data dictionaries, business rules, anddata quality artefacts.
- Experience analysing and working with complexdatasets from multiple source systems.
- Strong understanding of Salesforce data models,object relationships, field mapping, data dependencies, and migrationimpacts.
- Hands-on experience with Salesforce DataLoader and data migration or ETL tools such as MuleSoft,Informatica, Talend, Azure Data Factory, or equivalent.
- Experience using SQL and database query tools toextract, analyse, validate, and reconcile data.
- Advanced Microsoft Excel skills, including largedataset analysis, reconciliation, reporting, lookup functions, and pivottables.
- Experience supporting migration testing, cutoverplanning, post-migration validation, and reconciliation activities.
- Strong communication and stakeholder managementskills, with the ability to work effectively across business and technicalteams.
- Experience delivering Salesforce implementationor transformation programs.
- Experience with Salesforce Public SectorSolutions (PSS) preferred but not mandatory
- Experience within government, regulatory,compliance, enforcement, or public-sector environments preferred
- Experience working with data migration tools andframeworks in large enterprise environments required
- Relevant Salesforce, Business Analysis, DataManagement, or related professional certifications.
This is a Senior Business Analyst role with a strong focus on datamigration, data quality, and Salesforce data readiness. The role isresponsible for defining, analysing, governing, and supporting migrationactivities from business discovery through to implementation and post-go-livevalidation.
The role does not perform solution development or Salesforceconfiguration activities, which will be delivered by the implementationpartner. Instead, the focus is on ensuring that migration requirements,mappings, data quality activities, testing, and reconciliation processes areeffectively planned and executed to support a successful Salesforceimplementation.
- Successful profiling, cleansing, and preparationof legacy data for migration.
- Delivery of complete and accuratesource-to-target mappings and migration artefacts.
- Reduction of data quality risks impactingimplementation and operational readiness.
- Successful completion of migration testing,validation, and reconciliation activities.
- High-quality migration of data to Salesforce withminimal business disruption.
- Effective stakeholder engagement and alignmentacross business, technical, and vendor teams.
Salary Grade 9/10, with the base salary for this role startingat 133,348 base plus superannuation
For enquiries relating to recruitment please contact Afrah Saied via afrah.ahmedsaied@customerservice.nsw.gov.au.
Visit the Capability Application Tool to prepare for the recruitment process by accessing practice application and interview questions based on the focus capabilities listed in the role description.
A talent pool may be created as part of this recruitment process and will be valid for up to 18 months. The talent pool may be used to fill future ongoing or temporary vacancies of the same or similar role.
A career at the Department ofCustomer Service (DCS) gives you the opportunity to help improve government services and be part of reformthat benefits people across NSW. We are focused on delivering excellent customer service, digitaltransformation, and regulatory reform. Come join us and influence the future of our great state.
The strength of our workforce lies in its diversity and embracingdifference, while the key to our success is leveraging the contributions of employees with differentbackgrounds and perspectives.
You can view our full diversity and inclusion statement here.
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 csrecruitment@customerservice.nsw.gov.au.
Informationon some of the different types of disabilities
Information on adjustmentsavailable for the recruitment process
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
