Oracle Lodestar Consultant

STRATEGIC STAFFING SOLUTIONS (S3) HAS AN OPENING!

Oracle Lodestar Consultant
St. Louis, MO (Remote)
12+ Months with opportunity to extend/convert
W2 Contract role

Job Summary

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