Job Description 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