Electric System Data Analyst

City of College Station, TX•College Station, TX

50d

About The Position

Under general supervision of the Director, the Electric System Data Analyst is responsible for administering and managing the work order system and performing accounting functions as they relate to the electric transmission, distribution, and general plant. This includes but is not limited to generating ad hoc reports for management to aid in budgeting, cost accounting, rate design, and regulatory requirements; reviewing and monitoring distribution and transmission expenditures; and working with power supply on a variety of forecasting, settlement, and bid/hedging.

Requirements

Bachelor's Degree and four (4) years of related work experience or an equivalent combination of education and experience
Must possess a valid Texas Driver's License
Advanced skills in Microsoft Word, Excel, PowerPoint, Copilot, Power BI, and Outlook

Nice To Haves

Experience with electric utility accounting software (specifically CPR, work orders, and line design)
Background in FERC Accounting
Background in analyzing and forecasting electric system load

Responsibilities

Work with power supply to track expenditures, create projections for future costs, estimate needs for shortages in contracted supply, and provide recommendations.
Participate in developing and updating system load analysis and power supply forecasts.
Participate in the development of auction strategies, projections, and tracking of COCS's participation in ERCOT's Congestion Revenue Rights (CRR) market.
Serve as the Subject Matter Expert (SME) for managing the Federal Energy Regulatory Commission (FERC) Chart of Accounts (COA) and work order accounting through the City's financial applications. Assign expenditures in accordance with FERC guidance on utility cost accounting.
Administer and manage the utility's fixed assets using work order systems to generate accurate values of the electric plant as defined in the FERC COA. Coordinate with the City's financial asset accounting staff to align FERC cost accounting with the City's financial policies. Maintain all necessary system asset records in accordance with FERC standards for an electric utility.
Responsible for job costing and plant accounting associated with all CIP and capital projects performed by the electric department, as well as tracking and monitoring capital and O&M expenditures and budgets.
Manage the Assembly Unit (AU) database for the Electric Utility. Conduct periodic reviews of AU standard costs related to labor, materials, and equipment. Assign the appropriate FERC plant account codes to the AUs.
Prepare detailed routine and special reports as needed by Electric administration or the City administration.
Process personnel-related changes for the Electric Utility in the City's HR application.
Perform other duties as assigned.