Revenue Analyst

City of Boise - Boise, ID

Full-time - Entry Level

Boise, ID

Executive, Legislative, and Other General Government Support

About the position

The Revenue Analyst position at the City of Boise involves preparing complex financial and statistical data analyses to support the Public Works utilities. The role requires developing and implementing financial strategies, managing data reporting, and conducting advanced financial research to inform strategic planning decisions. The analyst will work under general supervision, utilizing independent judgment to provide insights and recommendations based on data analysis.

Responsibilities

• Conduct advanced financial research and analysis of the department's multiple funding sources and budgets for all five Public Works funds.
• Develop, maintain, and modify complex financial and analytical models to support critical and high-profile rate and strategic department planning decisions.
• Prepare verbal and written information for presentations to the Public Works Commission and City Council.
• Provide analysis that includes asset tracking, life cycle cost analysis, rate affordability, customer profile, usage, budget to actual cost and revenue comparisons, debt analysis, cash flow analysis, and cost of service studies.
• Review financial models and calculations made throughout Public Works to seek improvement and correlation of all related analyses and models.
• Consult with department managers to determine trends or changes in operations, capital needs, staffing, processes, and technologies that will have a financial impact.
• Partner with other teams and city departments to gather data required for analysis and coordinate with the IT department to incorporate data sets into financial models.
• Work with utility billing to provide analysis and modeling for collections, bill delinquency, and generate reimbursement requests, rate schedule maintenance, and other tasks.
• Assist the PW Enterprise Revenue Manager and other Public Works staff in interpreting policies, procedures, and ordinances, calculating complex rates and connection fees, and conducting public outreach on policies.
• Plan and develop complex reporting tools in coordination with department administration, IT, and other city departments.
• Develop dashboards that portray real-time data using tables, graphs, and analysis to allow users to understand vital data for each utility.
• Create a variety of other reports and analytics as needed.

Requirements

• Bachelor's degree with 3 years of experience in financial and business analysis, accounting, economics, public utility administration, or related field, or an equivalent combination of education and/or experience.
• Knowledge of financial and business analysis, dashboard and reporting approaches, advanced spreadsheet capabilities, research methods, and communication of complicated financial, statistical, and modeling concepts.
• Ability to critically evaluate and improve financial analysis, create clear reporting tools and dashboards, and develop complicated financial tools.

Nice-to-haves

• 5 years of progressive experience in advanced financial and business analysis, accounting, economics, public utility administration, or related field.
• Demonstrated experience in critically evaluating and improving financial analysis, creating reporting and dashboards, and developing complex financial tools.
• Demonstrated knowledge of statistical analysis tools, database platforms, and dashboard utilities.

Benefits

• 457(b) retirement plan
• Commuter assistance
• Dental insurance
• Disability insurance
• Employee assistance program
• Employee discount
• Flexible spending account