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:
- Initial interview with Corrie
- Second interview with Kyle
- 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.
