Senior Utility Edi Engineer

Senior Utility EDI Engineer / PG&E 867 Specialist

Location: Little Elm, TX

Long Term Contract!

We are seeking a highly experienced Senior Utility EDI / PG&E 867 Specialist with strong hands-on expertise in ANSI X12 867 transactions and utility meter-usage data exchange.

The ideal candidate will have direct experience working with Pacific Gas & Electric (PG&E) or other California electricity utilities, with a deep understanding of utility EDI implementation guides, interval-level electricity usage data, meter identifiers, and historical transaction processing.

This role requires a hands-on technical subject matter expert (SME) who can analyze raw X12 867 files, define mapping specifications, validate parsed data, and establish reconciliation rules between PG&E 867 and SMUD CSV data.

Candidates with general EDI experience or IBM Sterling administration alone will not be a fit. Strong utility-domain and X12 867 technical expertise is mandatory.

Key Responsibilities

• Review PG&E X12 867 implementation guides and historical EDI sample files.
• Analyze ANSI X12 867 segments, loops, hierarchies, and utility-specific data structures.
• Define and validate segment/loop-to-interval mapping specifications.
• Understand and interpret hourly electricity usage, timestamps, time zones, daylight-saving transitions, and usage units.
• Define business rules for original, corrected, replacement, and superseded meter-usage transactions.
• Work with MCE stakeholders to clarify historical data-handling and correction requirements.
• Establish matching keys and reconciliation rules between PG&E 867 and SMUD CSV datasets.
• Review Python-based EDI parsing designs developed by the offshore engineering team.
• Validate parsed outputs, identify data discrepancies, and resolve utility-domain ambiguities.
• Support technical discussions, discrepancy investigations, and final POC validation.

Required Technical Skills

• 8 12+ years of experience in EDI, data integration, or related technical integration roles.
• Strong hands-on expertise in ANSI X12 867 transactions, preferably in the electricity utility domain.
• Direct experience with PG&E 867 or other California utility EDI integrations is highly preferred.
• Strong understanding of utility EDI implementation guides, transaction structures, segments, loops, and hierarchies.
• Experience handling interval-level electricity meter-usage data.
• Knowledge of meter identifiers, hourly usage intervals, timestamps, time zones, daylight-saving changes, and consumption units.
• Experience with original, corrected, replacement, and superseded EDI transactions.
• Strong knowledge of EDI mapping, parsing, validation, error handling, and data integrity.
• Experience with data reconciliation and investigation of meter-usage discrepancies.
• Ability to review raw X12 files, mapping specifications, and parsing outputs.
• Strong analytical, troubleshooting, and communication skills

.

Key Responsibilities

• Review PG&E X12 867 implementation guides and historical EDI sample files.
• Analyze ANSI X12 867 segments, loops, hierarchies, and utility-specific data structures.
• Define and validate segment/loop-to-interval mapping specifications.
• Understand and interpret hourly electricity usage, timestamps, time zones, daylight-saving transitions, and usage units.
• Define business rules for original, corrected, replacement, and superseded meter-usage transactions.
• Work with MCE stakeholders to clarify historical data-handling and correction requirements.
• Establish matching keys and reconciliation rules between PG&E 867 and SMUD CSV datasets.
• Review Python-based EDI parsing designs developed by the offshore engineering team.
• Validate parsed outputs, identify data discrepancies, and resolve utility-domain ambiguities.
• Support technical discussions, discrepancy investigations, and final POC validation.

Required Technical Skills

• 8 12+ years of experience in EDI, data integration, or related technical integration roles.
• Strong hands-on expertise in ANSI X12 867 transactions, preferably in the electricity utility domain.
• Direct experience with PG&E 867 or other California utility EDI integrations is highly preferred.
• Strong understanding of utility EDI implementation guides, transaction structures, segments, loops, and hierarchies.
• Experience handling interval-level electricity meter-usage data.
• Knowledge of meter identifiers, hourly usage intervals, timestamps, time zones, daylight-saving changes, and consumption units.
• Experience with original, corrected, replacement, and superseded EDI transactions.
• Strong knowledge of EDI mapping, parsing, validation, error handling, and data integrity.
• Experience with data reconciliation and investigation of meter-usage discrepancies.
• Ability to review raw X12 files, mapping specifications, and parsing outputs.
• Strong analytical, troubleshooting, and communication skills

Thanks &