Job Summary
Data Quality & Analysis Specialist shall support data preparation activities for a Salesforce migration program. The role will be responsible for assessing source data quality, performing detailed data analysis, identifying data issues, investigating root causes, and supporting remediation activities. Working closely with business stakeholders, data owners, Salesforce consultants, and migration teams, the successful candidate will help ensure that source data from SAP, Sprinklr, spreadsheets, and other systems is accurate, complete, and ready for migration into Salesforce. This role serves as the primary contributor for data profiling, issue identification, root cause analysis, and quality reporting.
Key Responsibilities
Data Quality Assessment
- Perform data profiling and quality assessments on source systems and files.
- Identify data quality issues such as:
- Missing or incomplete data
- Duplicate records
- Invalid values
- Inconsistent formats
- Obsolete or inactive records
- Referential integrity issues
- Execute predefined data quality rules and validation checks.
- Document findings and recommend remediation actions.
Data Analysis & Root Cause Investigation
- Analyse data quality issues to determine underlying causes.
- Investigate business processes, system behaviours, and data entry practices contributing to quality problems.
- Work with business and technical teams to understand issue origins.
- Quantify the impact and scope of identified issues.
Data Profiling & Discovery
- Profile source data from various system, for example:
- SAP
- Sprinklr
- Excel/CSV files
- Other operational systems
- Analyse data patterns, anomalies, distributions, and relationships.
- Produce profiling reports to support migration planning and readiness decisions.
- Assess legacy data structures against target Salesforce data models to flag structural or length mismatches early.
Data Quality Reporting
- Prepare data quality dashboards, scorecards, and issue summaries.
- Track quality metrics and remediation progress.
- Support readiness reporting for migration milestones.
Data Remediation Support
- Assist business teams in understanding identified data issues.
- Validate remediation outcomes.
- Re-run quality checks following data correction activities.
- Support issue closure and readiness sign-off activities.
Migration Readiness Support
- Support data validation activities during migration testing.
- Perform automated and manual data validation and reconciliation exercises across iterative Mock Migration cycles.
- Assist with reconciliation and data verification exercises.
- Help ensure migration data meets agreed quality thresholds.
- Participate in business data validation workshops.
Skill Requirements
Essential
- Data Quality
- Data Analysis
- Data Migration
- Business Data Management
- Experience working on CRM, ERP, or digital transformation projects.
- Experience analyzing large datasets and identifying data quality issues.