Budget Analyst/Senior Budget Analyst

City of Mesa•Mesa, AZ

16h

About The Position

This recruitment is for two vacancies in the Reporting and Data Modeling Specialization Assignment within the Office of Management and Budget. The position may be filled at either the Budget Analyst or Senior Budget Analyst level. Responsibilities may span across all specializations (Forecast, Operations, Projects, and Reporting) and incumbents may be reassigned based on office needs. This recruitment will also establish eligible lists for future vacancies. The Budget Analyst role involves assisting in the preparation and administration of the City's annual operating budget, five-year Capital Improvement Budget, and multi-year revenue/expenditure projections. This includes compiling and analyzing statistical and fiscal data, preparing budget documents, and analyzing specific City departments and funds with supervisor assistance. The Senior Budget Analyst role involves advanced budget preparation, analysis, and administration, serving in a leadership capacity with oversight, coordination, and process improvement responsibilities. This includes compiling and analyzing data, preparing budget documents, training City staff, surveying customers, performing site visits, preparing annual budgets, assisting departments with activity-based budgeting and costing, performance management, and providing staff support to management meetings. Senior Budget Analysts are responsible for the analysis of City departments and funds, testing, documentation, and training of the Performance Budgeting system, and Citywide training on financial structure, database, financial analysis techniques, and budgetary policy.

Requirements

Graduation from an accredited college or university with a Bachelor's Degree in Accounting, Finance, Data Analytics, Statistics, or closely related field.
Minimum of three years full-time, professional level employment in accounting, auditing, budget preparation, finance, statistical analysis, or closely related financial and/or fiscal activity (for Budget Analyst).
Minimum of five years full-time, professional level employment in accounting, auditing, budget preparation, finance, statistical analysis, or closely related financial and/or fiscal activity (for Budget Analyst).
Graduation from an accredited college or university with a Master’s degree in Accounting, Finance, Data Analytics, Statistics, Business or Public Administration, or closely related field will be considered as two years of qualifying work experience.
Minimum of five years’ full-time, professional-level employment in accounting, auditing, budget preparation, finance, statistical analysis, or closely related financial and/or fiscal activity (for Senior Budget Analyst).
Minimum of seven years full-time, professional level employment in accounting, auditing, budget preparation, finance, statistical analysis, or closely related financial and/or fiscal activity (for Senior Budget Analyst).
Two years of full-time employment with the City of Mesa as a Budget Analyst or three years’ full-time professional-level budget employment with the City of Mesa will be considered as qualifying experience (for Senior Budget Analyst).
Graduation from an accredited college or university with a Master’s Degree in Accounting, Finance, Data Analytics, Business or Public Administration, or closely related field will be considered as two years of qualifying work experience (for Senior Budget Analyst).

Nice To Haves

Graduation from an accredited college or university with a Master's Degree in Accounting, Finance, Data Analytics, Statistics, Business or Public Administrations, or closely related field (for Budget Analyst).
Three years full-time, professional level employment in accounting, auditing, budget preparation, finance, statistical analysis, or closely related financial and/or fiscal activity within a local, county, or state government (for Budget Analyst).
Workplace experience with data administration through Excel spreadsheets or databases such as SQL and Access (for Budget Analyst).
Possession of a Certified Public Accountant (CPA) or Certified Governmental Financial Manager (CGFM) (for Budget Analyst).
Graduation from an accredited college or university with a Bachelor’s or Master’s Degree in Accounting, Finance, Data Analytics, Business or Public Administration, or closely related field (for Senior Budget Analyst).
Five years full-time, professional level employment in accounting, auditing, budget preparation, finance, statistical analysis, or closely related financial and/or fiscal activity within a local, county, or state government (for Senior Budget Analyst).
Workplace experience with data administration through Excel spreadsheets or databases such as SQL and Access (for Senior Budget Analyst).
Possession of a Certified Public Accountant (CPA) or Certified Government Financial Manager (CGFM) (for Senior Budget Analyst).
Regression analysis experience, as well as work with statistical packages like SPSS and Forecast Pro (Forecast Specialization Assignment) (for Senior Budget Analyst).

Responsibilities

Assisting in the overall process of preparing and administering the City's annual operating budget, five-year Capital Improvement Budget, and multi-year revenues/expenditures projections.
Compiling and analyzing both statistical and fiscal data as the basis for preparing specific schedules, tables, and narrative summaries for budget documents.
Analyzing one or many City departments and funds with assistance from a supervisor or Senior Budget Analyst.
Performing work independently with periodic supervisor review.
Performing duties across all specializations (Forecast, Operations, Projects, and Reporting) as needed.
Researching and identifying economic influences on the City’s revenues and expenditures (Forecast Specialization).
Performing statistical analysis and comprehensive review of forecast model variables through regression analysis and statistical software packages (Forecast Specialization).
Preparing summary presentations and reports for City management (Forecast Specialization).
Developing and testing the Forecast system (Forecast Specialization).
Assisting with preparation of major budget processes in support of the City’s budget preparation process and budget monitoring during the fiscal year (Operations Specialization).
Producing the annual Executive Budget Plan document (Operations Specialization).
Developing training for City staff (Operations Specialization).
Providing analysis of contingency requests, position costs, and other operational issues (Operations Specialization).
Providing analytical support for the Capital Improvement Program (CIP) (Projects Specialization).
Researching, compiling, analyzing, and summarizing multi-year CIP related data such as monthly expenditures, bond reconciliations, and project-based expenditure reporting (Projects Specialization).
Preparing tables, charts, and summaries used for the five-year CIP and seven-year forecast period (Projects Specialization).
Compiling, analyzing, and summarizing multiyear Lifecycle and Infrastructure plans (Projects Specialization).
Setting up and supporting projects in the City’s financial system (Projects Specialization).
Maintaining and providing assistance in the development of financial and budgetary reports and database administration using Microsoft Excel, Access, SQL, or Power BI (Reporting and Data Modeling Specialization).
Assisting with system reviews and testing for system or software upgrades and container releases for enterprise platforms (Reporting and Data Modeling Specialization).
Conducting timely analyses of centralized data models and preparing financial projections (Reporting and Data Modeling Specialization).
Reviewing the accuracy of the financial and budgetary system interfaces (Reporting and Data Modeling Specialization).
Producing reports for statutory requirements and other budget material adopted by the City Council (Reporting and Data Modeling Specialization).
Performing advanced budget preparation, analysis, and administrative work (Senior Budget Analyst).
Serving in a leadership role, including oversight, coordination, and process improvement responsibilities (Senior Budget Analyst).
Training City staff on budget procedures (Senior Budget Analyst).
Surveying customers (Senior Budget Analyst).
Performing site visits at City departments (Senior Budget Analyst).
Assisting departments with activity based budgeting and costing (Senior Budget Analyst).
Assisting departments with performance management, including the evaluation of budget requests based on related performance information (Senior Budget Analyst).
Providing staff support to quarterly management meetings (Senior Budget Analyst).
Testing, documentation, and training of the Performance Budgeting system (Senior Budget Analyst).
Designing and using data queries to analyze data integrity as well as content conformity to set standards (Senior Budget Analyst).
Spreadsheet design, analysis of data linking, and formula integrity (Senior Budget Analyst).
Citywide training for financial structure, database training, financial analysis techniques, and general budgetary policy (Senior Budget Analyst).
Producing and maintaining publications, presentations, and reference documents on the internet and intranet (Senior Budget Analyst).
Leading major budget processes in support of the City’s budget preparation process and budget monitoring during the fiscal year (Senior Operations Specialization).
Leading system reviews and testing for system or software upgrades and container releases for enterprise platforms (Senior Reporting and Data Modeling Specialization).
Conducting timely analyses of centralized data models and preparing financial projections (Senior Reporting and Data Modeling Specialization).
Producing reports for statutory requirements and other budget material adopted by the City Council (Senior Reporting and Data Modeling Specialization).
Displaying considerable initiative in meeting deadlines and target dates, as well as identifying ways to improve and/or streamline the process (Senior Budget Analyst).
Functioning as a lead on projects and with other employees with minimal supervision (Senior Budget Analyst).