Oracle Lodestar Consultant (37)

Oracle Lodestar ESSM Settlements Consultant

Strategic Staffing Solutions (S3) has an opening for an Oracle Lodestar ESSM Settlements Consultant in St. Louis, MO (Remote). This is a 12+ month contract role with opportunity to extend/convert to W2.

Job Summary

We are seeking an experienced Oracle Lodestar ESSM Consultant with expertise in utility settlement processes. The consultant will participate in the implementation, enhancement, testing, and production support of Oracle Lodestar Enterprise Settlement & Service Management (ESSM) solutions. The ideal candidate will have strong knowledge of deregulated utility markets, financial settlements, interval meter data, and Oracle database technologies.

Responsibilities

• Analyze utility settlement business requirements.
• Configure Oracle Lodestar ESSM settlement modules.
• Develop and support settlement calculations for:
• Wholesale settlements
• Retail settlements
• Transmission settlements
• Distribution settlements
• Configure:
• Settlement rules
• Pricing algorithms
• Tariffs
• Loss factors
• Time-of-use calculations
• Perform settlement validation and reconciliation.
• Troubleshoot settlement exceptions and data discrepancies.
• Integrate ESSM with:
• Meter Data Management (MDM)
• Customer Information Systems (CIS)
• Energy Trading and Risk Management (ETRM)
• Market operator interfaces
• ERP/Financial systems
• Create functional specifications and technical documentation.
• Execute SIT, UAT, and regression testing.
• Support production settlement cycles.
• Coordinate with business users and market operations teams.
• Assist with month-end and year-end settlement activities.

Required Skills

Oracle Technologies

• Oracle Lodestar ESSM
• Oracle Database
• PL/SQL
• SQL
• Oracle Unix/Linux environment
• Oracle Scheduler
• Shell scripting (Korn Shell/Bash)

Utility Industry Knowledge

Experience with:

• Electric utility settlements
• Gas utility settlements
• Wholesale electricity markets
• Retail choice markets
• Meter data processing
• Billing determinants
• Market reconciliation
• Financial settlements
• Regulatory compliance

Education

• Bachelor's degree in Computer Science, Engineering, Information Systems, or related field.

* Beware of scams. S3 never asks for money during its onboarding process