Public Utilities Specialist (Rates)

Be concise. Avoid Federal jargon. Write one duty per bullet. Do not list minor duties (limit to 6-8 major duties). Use plain language.

As a Public Utilities Specialist (Rates) you will:

• Assists with the development and preparation of power repayment studies annual rate charge and fee calculations strategies or other analysis for the Region by gathering compiling and formatting cost revenue and load data.
• Analyzes historical costs revenues loads industry trends or other factors that may affect power transmission and ancillary services rates repayment or methodologies. Estimates future costs revenues loads or other factors utilizing historical trends and future plans for forecasts.
• Prepares revenue distribution allocations for annual ancillary services and other charge and fee updates using appropriate project expense splits.
• Ensures consistency of repayment data budget data and financial records including transfers between power systems to ensure that revenues are sufficient to meet project repayment obligations and that rates are fair and equitable.

• Must be a U.S. Citizen or National.
• This employer participates in the e-Verify program.
• Males born after 12/31/1959 must be registered for Selective Service.
• Suitable for Federal employment as determined by a background investigation.
• May be required to successfully complete a probationary/trial period. Employees serving on a probationary or trial period may be terminated at any time during the probationary or trial period for performance conduct or business-related reasons in the interest of Federal service.
• In accordance with Executive Order 14170 applicants are encouraged to respond to the four short free-response essay questions in the questionnaire. Answers to these questions are not scored or rated. Your answers will be reviewed by the hiring manager and agency leadership if you are referred for selection consideration.
• Limit your resume to no more than two (2) pages. If more than two pages are submitted only the first two pages will be reviewed to determine your eligibility and qualifications.
• Security clearance and associated requirements- Moderate Risk.
• Total salary varies depending on location of position.

SPECIALIZED EXPERIENCE REQUIREMENTS: A qualified candidates online application and resume must demonstrate at least one year of specialized experience equivalent to the next lower grade level in the Federal service.

GS-09 Level
Specialized experience - one year (52 weeks) of specialized experience at the GS-07 grade level or equivalent pay band. This experience MUST include all the following:

• Using automated financial and data management systems to query research and answer functional questions.
• Utilizing Microsoft Excel capabilities to build maintain manipulate spreadsheets and manage quantitative data.
• Collecting organizing and cleaning structured data from large spreadsheets relational databases or information management systems.
• Performing initial quantitative calculations and standard data validations on multi-variable data sets to identify trends outliers or discrepancies.

• Extracting querying and analyzing data from automated financial and data management systems to research issues and answer functional questions.
• Using Microsoft Excel functionality and capabilities to build maintain and manipulate spreadsheets and manage large data sets. Examples may be using pivot tables graphs vlookups or visual basic macros.
• Collaborating across a wide variety of professional contacts and customers to provide information resolve problems and address disputes.
• Extracting synthesizing and analyzing large complex operational or financial data sets to evaluate historical performance cost structures or organizational metrics and identify key trends or variations.

• Utilizing and managing automated financial and data management systems and advanced computer applications to query extract and perform in-depth data analysis on high-volume data sets.
• Collaborating across a wide variety of professional contacts stakeholders and customers to provide information and resolve complex problems and disputes.
• Analyzing and tracking historical data (such as generation sales revenues purchases or operating costs) to prepare specialized studies used to analyze and evaluate impacts.
• Developing building and presenting complex financial repayment or analytical models in both oral and written formats to internal and external leadership using spreadsheets presentations and technical reports.