Town of Queen Creek
Receive alerts when this company posts new jobs.
Senior Financial Services Analyst
at Town of Queen Creek
This recruitment will remain open until filled with the first review of applications occurring on 9/30/20 and weekly thereafter. This recruitment may close at any time after 9/30/2020 without notice.
This is a full journey-level professional class. Incumbents are required to fully understand, interpret and apply the principles, standards and practices of governmental accounting, auditing, budgeting, financial reporting and financial forecasting. Incumbents prepare projections and conduct forecasting and must understand governmental accounting systems and the flow of transactions between systems in order to extract and manipulate data for required reports. Duties also include preparing monthly financial reports and formal budget documents including CIP, revenue and expense projections, final reports, presentations and other specialized reports and analysis for management, Town Council, and outside agencies.
When assigned as the CIP Analyst, incumbent also performs accounting and analysis work in the areas of capital projects and long-term debt, utilizing knowledge and understanding of Generally Accepted Accounting Principles (GAAP), Governmental Accounting Standards Board (GASB) pronouncements, and industry standards and best practices.
When assigned as the Revenue Forecast Analyst, develops and maintains financial models to monitor and forecast Town non-utility revenues, such as sales tax, state shared revenue and property tax, and performs complex analysis and develops forecasts related to the Town's residential and commercial growth.
Work requires considerable initiative and independent judgment in applying financial principles and analysis concepts specific to budgeting, accounting and financial systems.
- Examples of Duties
TYPICAL CLASS ESSENTIAL DUTIES: (These duties are a representative sample; position assignments may vary.)
When assigned to General Budget Duties:
1.Collects, compiles and reviews town-wide budget submissions for accuracy, completeness and compliance with pre-determined targets, goals and policies, updates organizational charts, goals, and performance measures; prepares formal budget documents including capital improvement program, revenue and expense projections, and other specialized financial reports and analysis for management, Town Council and outside funding agencies; prepares monthly and annual closing of financials and corresponding budget reports;
2.Participates in the planning, implementation and evaluation of the budget process and develops strategies and alternatives that focus on continuous improvement, innovation and change;
3.Prepares budget to actual variance analysis for revenues and expenditures for operating and capital budgets;
4.Develops and updates forecasting models for revenues, expenditures and capital improvement projects (CIP) for short-term and long-term planning; prepares multi-year financial forecasts for operating and capital; provides estimates related to ongoing operating impacts for proposed capital projects;
5.Designs and conducts training seminars for staff, external attendees (Citizen Leadership, etc.) related to finance, accounting, budgeting, performance measures, and capital project management;
6.Analyzes and prepares economic impacts of proposed and final funding legislation; analyzes all components of the general formula calculations for the Town in coordination with the state funding units;
7.Presents financial analyses to council committees and at council meetings; presents policy analysis or other financial feasibility studies to senior management;
8.Assists Town departments in developing, evaluating and updating performance measures and benchmarks;
9.Prepares, with Human Resources assistance, annual salary and benefit projections for organization;
10.Maintains existing reports; creates new reports for departments, management and Town Council;
11.Performs other duties of a similar nature or level.
When assigned to CIP Analyst duties:
1. Monitors and analyzes capital project budget spending and forecasts, encumbrance and change-order processing, and project close-out; ensures accounts are properly funded and allocations are managed appropriately; collaborates with Procurement, Contracts, Accounting, Budget, and Project Management.
2. Develops and updates forecasting models for capital improvement projects for short-term and long-term planning; prepares multi-year financial forecasts for capital budgets; provides estimates related to ongoing operating impacts for proposed capital projects;
3. Prepares and records journal entries in the Town's accounting system; uses knowledge of accounting to ensure compliance with GAAP;
4. Maintains current debt repayment schedules for budgetary and financial reporting; ensures debt payments are paid on time and are tracked by funding source; provides related debt information and reports for Continuing Disclosure requirements.
5. Assists with preparation of the Town's Comprehensive Annual Financial Report (CAFR); prepares audit schedules relating to capital assets and long-term debt as needed.
6. Maintains and reviews CIP process controls; identifies opportunities for improvement and implements approved modifications; develops and maintains desktop procedures and documentation for areas of responsibility.
7. Performs other duties of a similar nature or level.
When assigned to Revenue Forecast Analyst duties:1. Creates financial models to use for forecasting revenues related to sales tax, state shared revenues, building permitting revenues, and property tax revenues; performs retrospective and predictive data modeling;
2. Forecasts residential and commercial growth and resulting effects to town revenues; develops and updates build-out estimates based on land use assumptions included in the General Plan; tracks developed commercial square footage inventories and valuations within town limits;
3. Analyzes sales tax records and historical data to provide input on revenue trends for the town; monitors the performance of new retail establishments; tracks various categories of taxpayers to identify trends and develop forecasts; performs budget-to-actual monitoring of sales tax receipts and reports monthly on results and drivers;
4. Monitors, analyzes and forecasts property tax; analyzes the impact of changes to County assessor data; develops new construction property tax estimates;
5. Analyzes annexation applications for fiscal impact to town revenues and expenses; prepares formal reports with results;
6. Works closely with other Town departments on annexations, building permits and business licenses; verifies that all annexed properties are included on property tax rolls and are collecting the appropriate sales taxes;
7. Analyzes the economic impact on local revenues of proposed legislation, regulations and policies;
8. Analyzes socio-economic factors to develop population/migration trends and forecasts, demographic trends, and various economic indicators and their effects on town revenues;
9. Establishes methodologies and concepts for collecting and processing data using knowledge of available sources of information and econometrics;
10. Performs ad-hoc and automated reporting to provide insight into revenue results;
11. Performs data cleaning and manipulation; data sorting, filtering, joining, and merging of large amounts of revenue data;
12. Performs other duties of a similar nature or level.
- Typical Qualifications
Training and Experience (positions in this class typically require):
Bachelor's Degree in Accounting, Finance or Business Administration and four years journey level experience related to area of assignment; or, an equivalent combination of education and experience sufficient to successfully perform the essential duties of the job such as those listed above. Master's Degree preferred.
- Supplemental Information
Knowledge (position requirements at entry):
- Public sector accounting, budgeting, and finance principles;
- Fiscal analysis and research principles in relation to municipal budgeting;
- Financial statement preparation techniques;
- Customer service principles;
- Accounting procedures, including general ledger, budget, capital assets, and long-term debt;
- Statistical analysis, research techniques, and forecasting;
- Demonstrated expertise and experience in economic trends and forecasting;
- Economic impact studies;
- FLSA laws and regulations;
- Arizona sales tax laws and collection practices; Arizona property tax laws;
- Computer software including word processing, spreadsheets, financial and database applications including high level proficiency in Microsoft Office Suite, especially Excel and Access; statistical software.
Skills (position requirements at entry):
- Research methodologies and techniques;
- Developing financial data into useful reports and presentations;
- Forecasting and recognizing, following and analyzing trends;
- Tabulating, recording, and balancing transactions;
- Preparing financial statements and reports;
- Performing complex accounting calculations;
- Managing projects and contributing to or leading part of a multi-functional team;
- Working independently;
- Ability to effectively analyze, synthesize and draw conclusions from complex data;
- Using multiple computer and related software applications;
- Arranging information into report format and for the preparation of graphical establishments of research results;
- Providing customer service;
- Operating standard office equipment;
- Communication, interpersonal skills as applied to interaction with coworkers, supervisor, the general public, etc. sufficient to exchange or convey information and to receive work direction.