SAP SD OTC Data Analyst

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.