What are the responsibilities and job description for the Electric System Data Analyst position at City of College Station?
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 the power supply group on a variety of forecasting, settlement, and bid strategizing activities.
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, and Outlook.
Preferred:
Experience with electric utility accounting software (specifically CPR, work orders, and line design). Background in FERC Accounting. Background in forecasting electric system load.
SPECIAL REQUIREMENTS:
Drug Screening: Due to the safety and/or security sensitive nature of this position, individuals shall be subject to pre-employment or pre-placement drug and/or controlled substance testing as outlined in City policy.
Position posted until filled or closing date.
- Work with the Power Supply group to track power supply expenditures, create projections for future power supply costs, estimate power supply needs for shortages in contracted supply, and provide recommendations.
- Participate in developing and updating system load 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 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 value 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.
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, and Outlook.
Preferred:
Experience with electric utility accounting software (specifically CPR, work orders, and line design). Background in FERC Accounting. Background in forecasting electric system load.
SPECIAL REQUIREMENTS:
Drug Screening: Due to the safety and/or security sensitive nature of this position, individuals shall be subject to pre-employment or pre-placement drug and/or controlled substance testing as outlined in City policy.
Position posted until filled or closing date.
Salary : $57,595 - $70,227