Electric System Data Analyst

Description

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.

Principal Duties

• 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 COCSs participation in ERCOTs 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 Citys financial applications. Assign expenditures in accordance with FERC guidance on utility cost accounting.
• Administer and manage the utilitys fixed assets using work order systems to generate accurate values of the electric plant as defined in the FERC COA. Coordinate with the Citys financial asset accounting staff to align FERC cost accounting with the Citys 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 Citys HR application.
• Perform other duties as assigned.

Qualifications

Required : Bachelors Degree and four (4) years of related work experience or an equivalent combination of education and experience

Must possess a valid Texas Drivers License

Advanced skills in Microsoft Word Excel PowerPoint Copilot Power BI and Outlook

Preferred : 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

Supplemental Information

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.

An Equal Opportunity and Military Friendly Employer

APPLICATIONS MAY BE FILED ONLINE AT :

Experience :

IC

Key Skills

Data Analytics,Microsoft Access,SQL,Power BI,R,Data Visualization,Tableau,Data Management,Data Mining,SAS,Data Analysis Skills,Analytics

Employment Type : Full-Time

Experience : years

Vacancy : 1

Yearly Salary Salary : 72006 - 104409