What are the responsibilities and job description for the Budget Analyst 1 or 2 position at City of Madison, WI?
General Description
The City of Madison's Finance Department is seeking a qualified Budget Analyst to join our team. The Finance Department’s Budget and Program Evaluation section is responsible for developing the City’s annual capital and operating budgets, conducting ongoing budget monitoring, and analyzing the fiscal impact of local legislation and policies. The team consists of four (4) Budget Analysts and a Manager. Each Budget Analyst works with a portfolio of City agencies as a liaison to the budget process and other fiscal analysis projects. We are seeking team-oriented candidates who thrive in a collaborative, fast-paced environment. In addition to our primary responsibility of developing the City's annual operating and capital budgets, the Budget and Program Evaluation section is focused on process improvement, collaboration, and supporting City-wide initiatives to align financial resources with City values and priorities. The Analyst selected for this position will have the opportunity to participate in work related to these exciting initiatives, such as efforts to integrate racial equity and social justice in budget development.
The Analyst selected for this position will be assigned a portfolio of City agencies and will lead all phases of the budgeting process for these agencies, including budget development, monitoring, and fiscal analysis of proposed legislation. Analysts may also be assigned ad-hoc projects, such as developing budget transparency tools and modeling budget scenarios for long-range planning.The position is posted as a Budget Analyst 1 or 2. The selected candidate will be hired based on their qualifications and experience. A Budget Analyst 1 is an entry-level position. A Budget Analyst 2 would perform the same duties as a Budget Analyst 1 with more independence and will be responsible for more complex analysis projects.
Starting salary range for Budget Analyst 1 is $70,899.40 - $83,478.98
Starting salary range for Budget Analyst 2 is $76,903.32 - $91,258.70
IMPORTANT: A COMPLETE APPLICATION WILL INCLUDE RESPONSES TO TWO (2) SUPPLEMENTAL QUESTIONS.
A COVER LETTER IS NOT REQUIRED.
**APPLICATIONS RECEIVED WITHOUT RESPONSES TO THE SUPPLEMENTAL QUESTIONS WILL IMMEDIATELY BE ELIMINATED FROM CONSIDERATION.**
Employees may be eligible for loan forgiveness through the Public Service Loan Forgiveness Program.
Examples of Duties and Responsibilities
Key responsibilities will include:
- Collaborating with agency staff to establish budget targets
- Reviewing agency budget requests and evaluating fiscal and operational impacts of scenarios
- Communicating budget development guidelines and policies to agency stakeholders
- Providing technical assistance to agencies on budget development and monitoring, including assistance using the City’s enterprise resource planning (ERP) software (training will be provided)
- Preparing budget documents for publication using multiple software applications (including Microsoft Word, Excel, Adobe Acrobat, and other applications)
- Writing memos that communicate complex financial information in a clear, concise manner for a general audience
- Analyzing budget data and forecasting expenditures, using Microsoft Excel and other analysis tools; interpreting data and presenting findings to stakeholders
- Analyzing and preparing fiscal notes outlining financial implications of proposed legislation
- Performing ad-hoc fiscal research and analysis, in order to improve the effectiveness and efficiency of City services
Minimum Qualifications
Budget Analyst 1
- One (1) year of experience in any of the following fields: budget development and monitoring, accounting, business administration, data analysis, non-profit or grants management, operations, public policy, or a related field; AND
- Basic proficiency in Microsoft Excel or similar software, including the ability to use basic formulas
- Associate's, Bachelor's, or Master's degree with coursework and/or internships demonstrating basic training in relevant topics (e.g. accounting, business administration, economics, finance, public administration, public policy)
- Two (2) years of experience in any of the following fields: budget development and monitoring, accounting, business administration, data analysis, non-profit or grants management, operations, public policy, or a related field; AND
- Intermediate proficiency in Microsoft Excel or similar software, including the ability to use formulas, format large datasets, and conduct analysis
- Familiarity with database systems or ERP software preferred.
The City of Madison strives to provide exceptional customer service to all its residents and visitors. Therefore successful candidates will have demonstrated ability to effectively work with multicultural communities.
For the complete list of the knowledge, skills, and abilities, please reference the Administrative Analyst classification specification.
Special Requirements
- Ability to meet the transportation requirements of this position.
- Employment will be contingent on background check and screening.
- The Finance Department has a hybrid workplace, with staff in the office at least two (2) days per week.
- Analysts will be expected to attend public Finance Committee meetings (approximately two per month) and Common Council budget hearings (three (3) meetings in November); staff will receive compensatory time for hours worked outside of regular business hours.
Work is sedentary in nature, generally performed in an office environment using office equipment such as telephone, computer, copier, etc., requiring the ability to sit/stand at a desk, work on a computer, and use a monitor for extended periods of time.
- Payroll Title for this position is Administrative Analyst 1 or 2
Salary : $70,899 - $83,479
