Public Utilities Specialist (Rates)

Western Area Power Administration

$68K — $129K *
Energy & Utilities
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • 5-7 years of related experience in public utilities and rate analysis
  • Proficiency in Microsoft Excel for data management and analysis
  • Experience with financial data management systems
  • Capability to perform complex data analysis on operational and financial data
  • Ability to collaborate with diverse stakeholders across various levels
  • Experience in preparing and presenting financial reports

Responsibilities

  • Assist in developing power repayment studies and annual rates
  • Analyze historical trends affecting rates and revenues
  • Prepare allocations for ancillary service charges
  • Ensure financial data consistency for project obligations
  • Estimate future financial trends based on historical data
  • Collaborate with teams to address data-related inquiries

Benefits

  • Access to comprehensive federal benefits package
  • Eligibility for reasonable accommodation for medical or religious needs
  • Potential for recruitment or relocation incentives
  • Creditable service for annual leave based on previous experience
  • Opportunity for promotion without further competition up to GS-12 level
Full Job Description
Summary

This position is part of the Western Area Power Association. As a Public Utilities Specialist (Rates), you will be responsible for assisting in the development and preparation of power, transmission, and ancillary service rates, service charges and fees, rate adjustment proceedings, project repayment studies, and related forecasts, allocations, strategies, and industry evaluations.

Duties

Help

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


Requirements

Help

Conditions of employment

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


Qualifications

SPECIALIZED EXPERIENCE REQUIREMENTS: A qualified candidate's 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.


OR

Substitution of Education for Experience: Two (2) years of progressively higher-level graduate education leading to a master's degree or master's or equivalent graduate degree, if related.

OR

Combination of Education and experience: I possess a combination of specialized experience and graduate education beyond the first year of graduate study that together meet the requirements for this position. The total percentages must equal at least 100 percent to qualify for the grade level.

GS-11 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:

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


OR

I have successfully completed a Ph.D. or equivalent doctoral degree or at least three full years of progressively higher-level graduate education leading to such a degree in a field related to the work of this position as described in the vacancy announcement.

OR

I possess a combination of specialized experience and graduate education beyond the first two years of graduate study that together meet the requirements for this position. The total percentages must equal at least 100 percent to qualify for the grade level.

GS-12 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:

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


"Experience" refers to paid and unpaid experience. Examples of qualifying unpaid experience may include volunteer work done through National Service programs (such as Peace Corps and AmeriCorps); as well as work for other community-based philanthropic and social organizations. Volunteer work helps build critical competencies, knowledge, and skills; and can provide valuable training and experience that translates directly to paid employment. You will receive credit for all qualifying experience, including volunteer experience.

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.

Working Conditions: The work is primarily sedentary with minimal physical exertion

Physical Effort: The work is performed principlally in an office setting, with occassional travel

Education

For this position, education cannot be substituted for experience at the GS-12 level.

If you are relying on your education to meet qualification requirements:

Education must be accredited by an accrediting institution recognized by the U.S. Department of Education in order for it to be credited towards qualifications. Therefore, provide only the attendance and/or degrees from schools accredited by accrediting institutions recognized by the U.S. Department of Education.

Foreign education must be reviewed by an organization recognized by the U.S. Department of Education. For special instructions pertaining to foreign education and a list of organizations that can evaluate foreign education, see the Department of Education website. DO NOT email or mail in any of your application documents. Documents will not be accepted outside of the online application system.

Failure to provide all of the required information as stated in this vacancy announcement may result in an ineligible rating or may affect the overall rating.

Additional information

  • This job opportunity announcement may be used to fill additional similar vacancies across DOE.
  • For general information on government-wide Telework polices visit: www.telework.gov.
  • Applicants may request Reasonable Accommodation (RA) when applying or competing for a job due to a medical condition or to exercise religious beliefs. If you need reasonable accommodation in the application or selection process, please contact the Agency Contact listed on this vacancy announcement.
  • If selection is made at a lower grade, promotion up to the full performance level may be made without further competition. However, promotion(s) will depend on the performance of the incumbent and are not guaranteed.
  • Promotion Potential: Full performance level is GS-12.
  • The selectee for this position may be eligible to receive a recruitment or relocation incentive. You will need to sign an employment agreement to be eligible for this incentive.
  • Permanent Change of Station (PCS) costs are not authorized.
  • This position may be eligible for creditable service towards annual leave. Federal Employees earn annual leave at a rate (4, 6 or 8 hours per pay period) which is based on the number of years they have served as a Federal employee. DOE may offer newly-appointed Federal employee's credit for their job-related non-federal experience or active duty uniformed military service. This credited service can be used in determining the rate at which they earn annual leave. Such credit must be requested and approved prior to the appointment date and is not guaranteed.
  • Salary negotiation may be available for those candidates who are new to Federal service.
  • Salary: The salary range indicated in this announcement will be adjusted to include locality payment for selected duty location. General Schedule locality pay tables may be found under Salaries & Wages.
  • Pay Tables
    • Billings, MT $61,722 to $116,362
    • Phoenix, AZ $64,564 to $121,720
    • Loveland, CO $68,819 to $129,742


Expand Hide additional information

Candidates should be committed to improving the efficiency of the Federal government, passionate about the ideals of our American republic, and committed to upholding the rule of law and the United States Constitution.

Benefits

Help

A career with the U.S. government provides employees with a comprehensive benefits package. As a federal employee, you and your family will have access to a range of benefits that are designed to make your federal career very rewarding. Opens in a new windowLearn more about federal benefits.

Eligibility for benefits depends on the type of position you hold and whether your position is full-time, part-time or intermittent. Contact the hiring agency for more information on the specific benefits offered.

Similar Jobs

More Jobs at Western Area Power Administration

More Energy & Utilities Jobs

Find similar Public Utilities Specialist (Rates) jobs: