Senior SAP IS-U Data Migration Consultant

EY; Los Angeles (CA); Remote; USD 103,000 - 188,000; Full time

Benefits offered by this job

Medical and dental coverage

Pension and 401(k)

Paid time off

Job summary

EY is seeking an SAP IS-U Data Conversion Senior Consultant to support data migration activities for SAP IS-U implementations. You will analyze legacy data, define conversion requirements, and manage mock conversions, reconciliation, cutover, and post-load validation with business and technical teams.

The role requires frequent collaboration with client stakeholders across SAP IS-U modules and may involve travel to client sites; strong analytical and communication skills are essential to

Qualifications

• Bachelor’s degree required.
• Typically, 3–4 years of SAP IS-U or SAP Utilities experience.
• Hands-on experience delivering functional requirements, solution design, testing and production support in a utility environment.
• Experience with source-to-target mapping, data profiling, transformation rules, value translations, validation rules, mock loads, reconciliation, and data-defect resolution.

Responsibilities

• Analyze legacy data structures, source extracts, business rules, and target SAP IS-U requirements for master and transactional data objects.
• Define and maintain source-to-target mappings, transformation rules, value translations, validation rules, and load dependencies with business and functional owners.
• Support conversion of utility data such as business partners, contract accounts, contracts, premises, connection objects, installations, devices, meter readings, billing history, and FI-CA balances.
• Perform data profiling and support data cleansing, mock conversions, data loads, validation, and reconciliation using approved migration tools.
• Coordinate staging and ETL activities with technical data teams and use SAP IS-U Migration Workbench/EMIGALL or other approved tools.
• Analyze load errors, rejected records, duplicate or incomplete data, referential-integrity issues, and sequencing dependencies; drive defects to resolution.
• Develop and maintain object counts, control totals, balance checks, exception reports, and evidence for data conversion validation and sign-off.
• Support multiple conversion cycles and mock loads to validate mapping, transformation, sequencing, data quality, and load results.
• Coordinate data dependencies across SAP IS-U Customer Service, Device Management, meter reading, Billing and Invoicing, FI-CA, and connected systems.
• Prepare functional conversion documentation, source-to-target mappings, validation rules, test scenarios, reconciliation results, defect documentation, and other project deliverables.
• Support cutover rehearsals, production conversion activities, post-load validation, issue triage, and post-go-live stabilization.
• Collaborate with client stakeholders, business users, functional teams, technical data teams, and project leadership to resolve conversion issues.

Skills

SAP IS-U

Data conversion

Data migration

Business analysis

Stakeholder collaboration

Travel readiness

Education

Bachelor's degree

Tools

SAP IS-U Migration Workbench/EMIGALL

ETL tools

Job description

EY is seeking an SAP IS-U Data Conversion Senior Consultant to support data migration activities for SAP IS-U implementations. You will analyze legacy data, define conversion requirements, and manage mock conversions, reconciliation, cutover, and post-load validation with business and technical teams.

The role requires frequent collaboration with client stakeholders across SAP IS-U modules and may involve travel to client sites; strong analytical and communication skills are essential to