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.