Commercial Modeling Analyst at Golden Spread Electric Cooperative, Inc. in Amarillo, TX 79101

Job description

• Position Type
• Full Time
• Job Title: Commercial Modeling Analyst
• Department: Strategy
• Location: Amarillo, TX; in-office
• Employment Type: Full Time; Exempt
• We are seeking a Commercial Modeling Analyst to support the accuracy, validation, and reporting of energy market settlements, natural gas transactions, and member cost calculations. This position plays a critical role in analyzing market and operational data, developing settlement models, monitoring SPP and ERCOT market activities, and ensuring accurate financial reconciliation and reporting. Ideal candidates are detail-oriented problem solvers with strong analytical skills, a passion for data integrity, and the ability to collaborate across accounting, operations, engineering, and market-facing teams to support strategic decision-making and member value.

Responsibilities

• Ensure data collection software retrieves and accurately stores GSEC data which directly impacts precision of the commercial models.
• Populate and report on Daily cost and margin results from GSEC’s market interactions.
• Generate, analyze, and validate the settlement/accounting data for accuracy and reconciliation for the creation of the Fuel and Energy Purchase Power Rate (FEPPC), Direct Service Rates (DSR), and non-member margins.
• Build key settlement shadow models, while monitoring and identifying issues in the market settlement activities performed by ACES on behalf of GSEC. File disputes in coordination with ACES as appropriate, which directly impact member cost and non-member margin revenue
• Calculate and verify natural gas transactions; physical and financial, which directly impact member cost.
• Participate in daily strategy calls and provide feedback on results which impact the cost to the members.
• Monitor and report on happenings in key settlement focused stakeholder groups in SPP and ERCOT.
• Fully understand key policy issues in SPP and ERCOT stakeholder groups as it relates to GSEC’s overall portfolio.
• Provide analytical data to support various business functions, projects, and Member Cooperatives.
• Work with others to format, analyze, and validate meter data: Billing (MV-90 Data), Accounting (Financial Statement Data), Market Operations (Settlement Data), and Engineer Techs (SCADA Data), which drives accuracy of cost to the members.
• Participate in Resource Developer calls which assists in GSEC’s strategic planning work.
• Other duties and responsibilities as assigned.

Requirements

• Bachelor’s degree in finance, accounting, or economics required.
• 5 to 7 years of experience in energy market operations preferred.
• RTO/ISO settlement procedures and protocols.
• SPP and ERCOT experience highly desired but not required.
• Energy trading products, both electric and gas.
• Electric market operations.
• Functions of back-office, mid-office, and front-office trading operations.
• Electric transmission and gas transportation products.
• Counterparty energy checkout processes.
• High level accounting, finance, billing, data analysis, and current data analysis tools.
• Graphing and reporting techniques.
• Microsoft Excel, Visual Basic, Access Word, and PowerPoint.
• This position requires an advanced understanding and skillset in Excel.
• XML language.
• Electric industry principles and understanding.

Skills

Required

• Electric market operations
• Counterparty energy checkout processes
• Graphing and reporting techniques
• Basic understanding of XML language

Preferred

• SPP and ERCOT experience

Benefits

• Schedule Options
• Traditional Schedule: M-F, 8am-5pm; or
• Flex Schedule: M-TH, 7:30am-5:30pm, F, 7:30am-11:30am
• Benefits
• Comprehensive medical, dental, and vision coverage.
• 401k with employer match and retirement pension.
• Accrued PTO plus 9 paid holidays.
• Wellness program.
• Employee assistance resources.
• …and much more!