Posting Title Financial Analyst IV
Job Requisition Number AE502958
Position Number 100484
Job Type Full-Time
Division Name Finance
Education and/or Equivalent Experience:
Graduation with a Bachelor’s degree from an accredited college or university with major course work in a field related to Finance, Accounting, or Economics plus five (5) years’ experience in a related field.
A Master’s degree in Finance, Accounting, Economics, Business or Public Administration or other relevant field may be substituted for 2 years’ experience.
A five (5) year accounting (MAcy) degree or CPA designation may be substituted for 1 years’ experience.
Licenses or Certifications:
Notes to Applicants
The Financial Analyst IV position serves a critical role for Austin Energy’s Capital Improvement Plan Budget group. Responsibilities include providing guidance and recommendations to management in the development of capital budgets, reviewing and analyzing current and historical budget data, preparing and reviewing budget variance reports, providing procedural and financial information and guidance with financial systems, preparing financial transactions by verifying documentation and accurately completing transactions, and coordinating with other financial groups to ensure
transactions are accurate and are processed in accordance with City policy
The ideal candidate will be an active problem-solver, has the ability to work cross-functionally and guide key decision makers.
40 hours a week (Monday-Friday, additional hours may be required), schedule flexibility – telework options available
Job Close Date 12/04/2022
Type of Posting External
Department Austin Energy
Grant Funded or Pooled Position Not Applicable
Location 4815 Mueller Blvd. Austin - telework options available
Experience with financial systems and applications, such as AIMS -Advantage 3, MicroStrategy, PowerPlan, eCOMBS, and eCAPRIS, or similar.
Proficiency with Microsoft Excel, PowerPoint, Word, and Outlook.
Experience working with capital ( CIP ) budgets, revenues, purchasing, capital purchases, and fixed assets.
Experience with financial reporting.
Experience with data analysis.
Experience developing/implementing financial-related processes and procedures.
Duties, Functions and Responsibilities
Essential duties and functions, pursuant to the Americans with Disabilities Act, may include the following. Other related duties may be assigned.
Develops and prepares reports, analyses, and models used in revenue and economic forecasts and budgets.
Develops and completes cost of service rate and structure recommendations, rate studies, and methodology analysis to comply with State regulatory requirements using multiple variables.
Primarily responsible for developing the operating or CIP budget for the department. Performs budget analysis by implementing the organization’s budget process system, providing guidance and recommendations to management in the development and completion of their budgets; finalizing the organizations budget; and monitoring the budget by preparing or reviewing current year estimates and budget variance reports, reporting on budget variances; reviewing budget forecasts; and reviewing current and historical budget information and data.
Prepares complex financial analysis, periodic and ad-hoc reports by researching, financial benchmark reporting, compiling, monitoring, and summarizing current and historical financial information and data, reporting on variances and trends, and compiling financial information from various financial systems.
Develops and prepares reports, analyses, and models to analyze debt issuances, bond issuance timing, Official Statement updates, calculate debt service requirements, equity financing ratios, cash reserve requirements, revenue bond debt refunding, rating agency presentations and other debt related requirements. Performs debt administration, impact analysis and monitors debt service schedules.
Provides financial support and monitors CIP projects. Processes and tracks task orders and other project requirements in eCAPRIS and other financial systems.
Develop and maintain complex databases to conduct comprehensive financial and technical analysis, and develop models and reports in Business Intelligence system to support and monitor performance and financial benchmarks.
Develop complex reports and documentation in compliance with local, State and Federal regulatory requirements. Conduct cost analysis, financial and performance benchmarking with other entities and assist in development of expert testimony.
Assists departments and other customers by providing procedural and financial information and guidance with financial systems.
Researches and provides information requested by City Council, City management, boards and commissions, vendors, the public, regulatory agencies and other City offices.
Monitors state and federal regulatory processes and provides guidance to the department regarding the financial impact of new and/or proposed legislation, regulations and standards.
Responsibilities – Supervisor and/or Leadership Exercised:
May be responsible for the full range of supervisory activities including selection, training, evaluation, counseling, and recommendation for dismissal
Knowledge, Skills and Abilities
Must possess required knowledge, skills, abilities, and experience and be able to explain and demonstrate, with or without reasonable accommodations, that the essential functions of the job can be performed.
Must possess required knowledge, skills, abilities and experience and be able to explain and demonstrate, with or without reasonable accommodations, that the essential functions of the job can be performed.
Knowledge of the processes and theories used for public budgetary and financial policies.
Knowledge of accounting practices and concepts.
Knowledge of utility ratemaking and cost of service study methodology.
Knowledge of debt instruments, cash management and utility financing methods.
Knowledge of forecasting models; econometric studies, analysis and forecasting; and estimating methods and techniques.
Knowledge of cost benefit analysis, feasibility studies and net present value analysis methods.
Knowledge of enterprise budgeting, financial planning or accounting.
Knowledge of research methods, survey techniques, statistical concepts and report writing.
Ability to complete detailed financial and economic analyses.
Ability to lead and/or facilitate meetings and workshops.
Ability to work independently.
Skill in generating and analyzing financial and statistical reports.
Skill in communicating effectively, orally and in writing.
Skill in using computers and related software applications.
Skill in performing quantitative analysis.
Criminal Background Investigation This position has been approved for a Criminal Background Investigation.
City of Austin is committed to compliance with the American Disabilities Act. If you require reasonable accommodation during the application process or have a question regarding an essential job function, please call ***** or TTY *****.
Required fields are indicated with an asterisk (*).
- This position requires graduation from an accredited four-year college or university with major course work in a field related to Finance, Accounting, or Economics plus five (5) years’ experience in a related field. A Master’s degree in Finance, Accounting, Economics, Business or Public Administration or other relevant field may be substituted for 2 years’ experience. A five (5) year accounting (MAcy) degree or CPA designation may be substituted for 1 years’ experience. Do you meet these requirements?
- Describe your experience developing and monitoring budgets, performing variance analysis, and preparing reports. Please include the size and type of budgets you have managed.
(Open Ended Question)
- Please describe your experience working with capital (CIP) budgets, revenues, purchasing, capital purchases, and fixed assets.
(Open Ended Question)
- Please describe your proficiency with Microsoft Office Suite, specifically with Outlook, Word, PowerPoint and Excel and in what capacity you have used these programs (e.g. creating, editing spreadsheets, presentations, etc.).
(Open Ended Question)
- Which of the following best describes your proficiency with Microsoft Excel?
Basic: create/edit simple spreadsheets, sort data, enter formulas
Intermediate: create/edit spreadsheets, create charts/graphs from spreadsheet data, hide and unhide rows/columns, use basic functions such as SUM, AVERAGE, and COUNT
Advanced: develop complex spreadsheets, create charts/graphs/tables, import data from external databases, use AutoFilter to analyze data, use complex functions/formulas for math & logic equations
Limited or no MS Excel experience, but proficiency with another spreadsheet application such as Lotus 1-2-3 or Apple Numbers
No experience with Microsoft Excel
- If selected as a top candidate, do you agree to a criminal background investigation?
Optional & Required Documents
Contact City of Austin Employment Services