Data analyst with SAP

Role: Senior Data Analyst – Order-to-Cash & Functional Master Data
Client: Clear Sky LLP
End Date: 6+ months Could extend or convert
Location: Remote, ideally EST or CST
Hybrid: No, fully remote
Sponsorship: Must be able to convert without sponsorship / No sponsorship at this time
Hours: 40 hours per week
Employment Type: Contract

Job Description

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.
• The interview process consists of three rounds:

1. Initial interview with Corrie
2. Second interview with Kyle
3. Final interview with the technical team

• Interview time blocks have not yet been established.
• The anticipated offer timeline and start date have not yet been confirmed.

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:

• Customer and Business Partner master data
• Sales-area views
• Partner functions
• Account groups and classifications
• Customer hierarchies
• Material and sales master data
• Material Determination and product substitutions
• Pricing condition types and condition records
• Access sequences and pricing procedures
• Customer-Material Information Records
• Credit management
• Tax classification
• 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.