Job Description :-
The Client is seeking a Senior Data Analyst to support an SAP S/4HANA transformation focused on Order-to-Cash functional master data. This consultant will profile source data, establish validation rules, develop data-quality scorecards, and identify cleansing priorities and migration risks.
The Senior Data Analyst will partner with the Data Lead, Order-to-Cash process owners, functional subject-matter experts, and technical teams to translate business requirements into SQL-based profiling, exception reporting, validation criteria, and actionable remediation plans.
The role requires deep knowledge of SAP Customer/Business Partner, Material Determination, Pricing, Customer-Material Information Records, and related SAP Sales and Distribution data. Experience supporting a JDE-to-SAP S/4HANA transformation is preferred.
Additional Notes
• Previous experience with a major consulting organization such as Accenture, EY, Deloitte, PwC, or KPMG is strongly preferred.
• Pharmaceutical or medical-device manufacturing industry experience is required.
• Candidates must have experience supporting SAP ECC and/or SAP S/4HANA Order-to-Cash data programs.
• Strong functional master data and advanced SQL experience are essential.
Responsibilities
- Profile Customer/Business Partner, material, pricing, Material Determination, Customer-Material Information Records, and related Order-to-Cash data.
- Evaluate data for completeness, consistency, duplication, validity, and cross-object integrity.
- Develop advanced SQL queries, exception logic, reconciliations, and repeatable data-profiling outputs.
- Translate business requirements into data-quality rules, validation criteria, scorecards, and measurable readiness thresholds.
- Analyze Pricing and Material Determination records for missing data, duplicates, invalid key combinations, conflicting validity periods, inconsistent scales, and obsolete records.
- Partner with Order-to-Cash, Sales and Distribution, credit, tax, data migration, functional, and technical teams to resolve issues.
- Support source-to-target analysis, data cleansing, mock loads, validation cycles, defect triage, reconciliation, and cutover readiness.
- Develop dashboards, scorecards, exception reports, and status reporting that drive cleansing and migration decisions.
- Document data rules, assumptions, findings, risks, decisions, and remediation activities.
- Escalate critical issues by clearly outlining business impact, recommended actions, accountable owners, and next steps.
- Evaluate end-to-end Order-to-Cash dependencies involving sales orders, contracts, scheduling agreements, deliveries, billing, returns, settlement management, reporting, and migration readiness.
Qualifications Required Skills
- Minimum of five years of experience in data analysis, data quality, or data migration supporting SAP ECC and/or SAP S/4HANA Order-to-Cash programs.
- Pharmaceutical or medical-device manufacturing experience.
- Hands-on SAP functional master data experience, including:
- o Customer and Business Partner master data
- o Sales-area views
- o Partner functions
- o Account groups and classifications
- o Customer hierarchies
- o Material and sales master data
- o Material Determination and product substitutions
- o Pricing condition types and condition records
- o Access sequences and pricing procedures
- o Customer-Material Information Records
- o Credit management
- o Tax classification
- o Material sales views
- Strong understanding of SAP Sales and Distribution data structures.
- Knowledge of data dependencies across sales orders, contracts, deliveries, billing, returns, and settlement management.
- Expert-level SQL skills, including complex joins, aggregations, exception logic, data-quality rules, and reconciliations.
- Experience developing profiling outputs, scorecards, dashboards, and exception reports.
- Experience translating business requirements into measurable data rules and validation criteria.
- Experience with source-to-target mapping, mock loads, validation, defect triage, cutover preparation, and stakeholder reporting.
Preferred Skills
- Previous consulting experience with Accenture, EY, Deloitte, PwC, KPMG, or a comparable major consulting organization.
- JDE-to-SAP S/4HANA transformation experience.
- Experience analyzing JDE source data and mapping it to SAP S/4HANA target objects.
- Experience supporting complex enterprise transformation or data-migration initiatives.
Soft Skills
- Strong analytical and problem-solving abilities.
- Clear written and verbal communication skills.
- Strong stakeholder-management skills.
- Ability to communicate technical data findings to business and program stakeholders.
- Ability to work effectively across functional, technical, and business teams.
- Strong documentation and organizational skills.
- Ability to identify risks and recommend practical remediation actions.
- Comfortable working in a fast-paced, cross-functional transformation environment.