City of Littleton · 18 hours ago
Budget Analyst
The City of Littleton is seeking a skilled and detail-oriented Budget Analyst to join the Finance Department. The role involves providing technical and analytical support in budget development, oversight, and monitoring of the city's annual budget.
CommunitiesGovernmentNon Profit
Responsibilities
Supports the Budget Manager in all aspects of the budget development process through analysis of revenue and expenditures, ensuring data accuracy, consistency and completeness
Develops and maintains advanced Excel models, templates, and tools for budget analysis, financial projections, and reporting purposes
Responsible for the creation and production of the annual budget document and capital improvement plan, compiling data and information provided by departments and the Budget Manager into professional, comprehensive publications that meet city standards
Creates budget-specific reports, spreadsheets, financial statements, and presentation materials for City Council, city management and the public
Maintains and updates budget records in Workday and other financial systems with a high degree of accuracy
Monitors current-year budgets by fund, department, division, and cost center in financial systems for the purpose of maintaining budget control; providing technical support and ad hoc reporting
Prepares fund summaries and financial projections using advanced analytical tools and models
Analyzes fiscal trends and develops financial projections
Ensures fiscal integrity and compliance with adopted budgets and appropriations through systematic monitoring
Meets periodically with departments as needed under the direction of the Budget Manager to gather budget information and provide technical assistance
Creates and maintains templates and workflows in collaboration software such as Smartsheet to enhance budget processes
Works proficiently in Workday and other authoritative budget systems to maintain budget data, run reports, and perform system functions related to budget management
Assists in development and maintenance of performance measures and related reporting, as needed
Maintains awareness of developments in budgeting technology, financial software, and public financial management best practices
Produces special analytical reports pertaining to specific areas of the city or local economy using a wide variety of current research tools
Periodic attendance outside regular working hours at council meetings and study sessions may be required
May support other Finance Department activities as necessary
Provides other related duties and responsibilities as required
Qualification
Required
Bachelor's degree in accounting, finance, public administration, business administration, or a related field
Two (2) years of related work experience in government or non-profit budgeting including: Advanced Excel experience with financial modeling, complex formulas, and pivot tables; Experience with ERP/financial systems (Workday experience preferred)
An equivalent combination of education, training and work experience that produces the knowledge, skill, and ability to perform the essential duties and responsibilities of the position may be considered
Must be able to pass a pre-employment criminal background check
Advanced proficiency in Microsoft Excel including complex formulas, pivot tables, VLOOKUP/XLOOKUP, data modeling, and financial analysis
Working knowledge of Workday or similar ERP systems with ability to navigate, maintain budget records, and run standard reports
Proficiency or ability to quickly learn collaborative software platforms such as Smartsheet
Solid understanding of financial management principles, government budgeting practices, and generally accepted accounting principles (GAAP)
Knowledge of Colorado local government budget law and compliance requirements
Knowledge of principles and methods of financial analysis in the public sector
Ability to design and develop professional reports, presentations, and budget documents
Strong analytical skills with ability to identify data discrepancies and ensure accuracy
Excellent attention to detail and organizational skills
Ability to work independently and manage multiple projects under tight deadlines
Strong written and verbal communication skills
Ability to establish and maintain positive working relationships with colleagues and stakeholders
Preferred
Public sector or non-profit budgeting experience
Experience with ERP/financial systems (Workday experience preferred)
Benefits
Excellent benefits and perks