Commercial Modeling Analyst

Job DescriptionJob Description

Scope of the Role

The Commercial Modeling Analyst (CMA) is responsible for maintaining commercial models and tools that are utilized by key stakeholders in the organization. These models are used for calculating and reporting the SPP and ERCOT cost to load for GSEC and its’ Member Cooperatives and calculating non-member margins generated by GSEC’s Resource Portfolio. This person is the point of contact with ACES settlements and leverages those resources to focus on key settlement charges which can highly impact cost to GSEC members. This position will also participate in managing the Load and Resource model while assisting in the development of other key models. The SMA is responsible for recognizing risk and communicating to the manager with recommended solutions.

The CMA may represent GSEC’s interests and brand at internal and external organizations and forums. Serves on internal committees and as a subject matter expert on matters of significance. While this role is an individual contributor, the CMA is responsible for cross training, taking initiative, finding solutions, and escalating when needed. This role is also responsible for exhibiting GSEC’s cooperative culture.

 

Essential Job Functions

• Ensure data collection software retrieves and accurately stores GSEC data which directly impacts precision of the commercial models.

• Populates and reports 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

• Calculates and verifies natural gas transactions; physical and financial, which directly impact member cost.

• Participates in daily strategy calls and provides feedback on results which impacts 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.

• Participates in Resource Developer calls which assists in GSEC’s strategic planning work.

• Other duties and responsibilities as assigned.

 

Complexity of Problems

This role demands meticulous attention to detail and accuracy to ensure the timely verification and provision of precise data necessary to meet daily, weekly, monthly, and annual deadlines. The individual must provide strategic advice and recommendations that directly impact the company's profitability and ability to achieve key market objectives. The data collected serves multiple purposes and is closely interconnected with other processes, meaning any unresolved issues could have a significant monetary impact on the company's market operations and overall financial performance. Moreover, the individual will serve as the primary expert in settlements, providing essential expertise in settlement protocols for both SPP and ERCOT, upon which the company relies heavily.

 

Internal and External Contacts

Internal Contacts: Employees at all levels within the organization.

External Contact: Member Cooperatives, SPP and ERCOT settlement personnel and stakeholder groups, bilateral counterparts, SPS, AEP, OGE, ACES.

 

Education, Knowledge, and Experience Required

• Master’s or bachelor’s degree in finance, Accounting or Economics.

• 5-7 years of experience in energy market operations is required

• This position requires a thorough knowledge of the following:

• 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.

• This position requires a basic understanding of:

• XML language.

• Electric industry principles and understanding.

 

Work location and conditions – Office, Amarillo, TX

 

Competencies

• Collaboration – Core Competency

• Ethics & Integrity – Core Competency

• Deliver Results – Core Competency

• Analysis/Reasoning – Competency

• Attention to detail – Competency

• Self-Management - Competency

 

FLSA Status

Exempt

Company DescriptionGolden Spread Electric Cooperative, Inc. is a tax-exempt, consumer-owned public utility, organized in 1984 to provide low cost, reliable electric service for its rural distribution cooperative members.

Its 16 Member systems provide service to approximately 248,000 member-consumers located in the Oklahoma Panhandle and an area covering 24 percent of Texas land area including the Panhandle, South Plains and Edwards Plateau Regions.

Golden Spread owns Mustang Station, a 480 megawatt, a gas-fueled, combined cycle generating plant located near Denver City, Texas, as well as Mustang Station Units 4, 5 and 6, two 150 megawatt combustion turbine-generators and one 163 megawatt combustion turbine-generator with inlet chilling located at the Mustang Station site. In 2011 Golden Spread added to its generating fleet Antelope Station, a 168 megawatt generating facility made up of 18 quick start engines located near Abernathy, Texas, and Golden Spread Panhandle Wind Ranch, a 78 megawatt wind facility made up of 34 wind turbines located near Amarillo, Texas. In 2014 and 2015 Golden Spread expanded its generation capacity further by adding 3 GE combustion turbines at Antelope Station, which was re-branded the Antelope Elk Energy Center with the installation of Elk Units 1, 2, and 3, capable of producing a combined 606 megawatts.Company DescriptionGolden Spread Electric Cooperative, Inc. is a tax-exempt, consumer-owned public utility, organized in 1984 to provide low cost, reliable electric service for its rural distribution cooperative members.\r
\r
Its 16 Member systems provide service to approximately 248,000 member-consumers located in the Oklahoma Panhandle and an area covering 24 percent of Texas land area including the Panhandle, South Plains and Edwards Plateau Regions.\r
\r
Golden Spread owns Mustang Station, a 480 megawatt, a gas-fueled, combined cycle generating plant located near Denver City, Texas, as well as Mustang Station Units 4, 5 and 6, two 150 megawatt combustion turbine-generators and one 163 megawatt combustion turbine-generator with inlet chilling located at the Mustang Station site. In 2011 Golden Spread added to its generating fleet Antelope Station, a 168 megawatt generating facility made up of 18 quick start engines located near Abernathy, Texas, and Golden Spread Panhandle Wind Ranch, a 78 megawatt wind facility made up of 34 wind turbines located near Amarillo, Texas. In 2014 and 2015 Golden Spread expanded its generation capacity further by adding 3 GE combustion turbines at Antelope Station, which was re-branded the Antelope Elk Energy Center with the installation of Elk Units 1, 2, and 3, capable of producing a combined 606 megawatts.

---