Public Utilities Specialist (Rates)

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

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

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

Requirements

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.

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.

How to apply

Please read the entire announcement and all the instructions before you begin an application. To apply for this position, you must complete the initial online application, to include submission of the required documentation specified in the Required Documents section. A complete application package must be submitted by 11:59 PM (EST) on the announcement closing date to receive consideration. The application process is as follows: You must have a login.gov account to sign into USAJOBS: https://www.usajobs.gov/Help/how-to/account/. To begin the application process in USAJOBS, click the Apply Online button. Answer the questions presented in the application and attach all required and supporting documentation. You must click the Submit Application button prior to 11:59 pm (ET) on the announcement closing date. You may update your application, including supporting documentation, at any time during the announcement open period by returning to your USAJOBS account, select Update Application: https://my.usajobs.gov/Account/Login. This option will no longer be available once the announcement has closed. To verify the status of your application, during and after the announcement open period, log into your USAJOBS account; applications will appear on the Welcome screen. The Application Status will appear along with the date your application was last updated. For information on what each application status means, visit: https://www.usajobs.gov/Help/how-to/application/status/. If you need help with login.gov or USAJOBS (e.g., account access, Resume Builder) visit the USAJOBS Help Center: https://www.usajobs.gov/Help/ If you experience difficulty applying on USAJOBS, after clicking the Apply Online button, or you are experiencing a significant hardship hindering your ability to apply online, the Agency Contact listed in the announcement can assist you during normal business hours. If you receive any system error messages, take screenshots if possible, to aid technical support.