- Salary
- $49k – $59k/yr
- Location
- Boise City Hall, ID, ID, US
- Workplace
- Hybrid
- Source
- GovernmentJobs
Description
The City of Boise Department of Finance is looking for an Accounts Receivable (AR) Analyst to join our team in a hybrid-eligible role that combines financial analysis, data, project work, and collaboration across the City.
In this role, you’ll analyze revenue and financial trends, develop reports and dashboards, work with real-time data in the City’s ERP system, and help evaluate the impact of different revenue streams. You’ll also support Finance projects, interpret contracts and cost-recovery requirements, and partner with departments across the City to solve complex financial and data challenges.
We’re looking for a strong analytical thinker who enjoys working with data, improving processes, and turning financial information into meaningful insights. Experience with advanced Excel, Power BI, or other reporting and data visualization tools is a plus.
Required Knowledge, Experience, And Training
Bachelor’s degree in finance, economics or closely related field
Three years of experience in a financial field with an emphasis on financial analysis, and spreadsheet development
Or an equivalent combination of education and/or experience.
Special Requirements
Applicants must be able to pass:
- City of Boise background check processes which includes a criminal history check and reference checks in accordance with the City of Boise Hiring Process Regulation
- Hybrid Work Eligible
Why the City of Boise?
The benefits are real and among the best in the Treasure Valley:
- 100% Employer paid medical coverage for you and your family.
- PERSI retirement (11.96% Employer Contribution) plus employer-matched 401(k)/457b
- 10 hours vacation/month (grows with tenure), 12 paid holidays, and 8 hours sick leave/month
- 10 weeks paid parental leave
- $500 annual wellbeing incentive
- Tuition reimbursement and free local bus pass
- Basic life and long-term disability insurance at no cost
Maintains a high level of expertise with city regulations, guidelines, and allowable exceptions within AR. Provides guidance and ensures compliance with the city's accounts receivable and cash handling policy as it relates to assigned departmental transactions. Advises department business units on internal processes and procedures.
Researches and stays aware of industry best practices and new technology. Acts as a trusted advisor to both team and departmental business partners to recommend best practices and solutions.
Understands, interprets and advises on the fundamentals of fund, account string, financial statements, budget to actuals, and how to look up and find information in ERP and other systems of record. Partners with operations and or management to interpret and explain memorandums of understanding or resolutions, and other details affecting receivables. Ensures cost recovery methods and calculations align within the requirements and framework of the contract.
Runs reports and effectively extracts cost data from the financial system. Prepares complex calculations necessary for the billing process in order to recover costs or share costs with other entities, including complex payroll analytics of contract or regular employees, factor or overhead burden rate, and administrative costs to determine the amount needed for cost recovery. Completes internal cross charge calculations and journal entries based on activity coding through the payroll system, with revenue offset.
Partners with the contract coordinator and AR manager to simplify contract methods and language, while attaining the maximum cost recovery rate. Liaises with business and operating partners to field inquiries regarding forecast and budget to actual comparisons. Compiles, analyzes and interprets financial data regarding revenue trends upon request. Assists budget business partners with budget development analysis of revenue as needed.
Serves on project teams and provides input on development of reports and databases. Designs, develops and maintains a variety of queries, pivot tables, graphs, macros, vba coding etc., and advanced spreadsheets to meet user and finance staff needs. Develops and revises methods and procedures to reinforce data integrity and internal controls. Creates templates or other tools to streamline complex billing calculations for consistency and accuracy. Prepares clear, concise financial and fiscal reports, graphs and PowerPoint presentations as needed.
Act as a backup for other financial systems, including preparing cash receipts or conducting cash audit for transactions processed at point of sale and miscellaneous deposit transactions, determining account coding, identifying overages and shortages, complex credit card research using payment processor software to investigate, settlement issues and problem resolution, and other functions, as assigned.
Performs other duties as assigned. Nothing in this job description restricts management's right to assign or reassign duties and responsibilities to this position at any time.Additional Required Knowledge, Experience, And Training
Knowledge of:
- Governmental budgeting principles, practices, procedures and theory
- Techniques and methods used in financial analysis and sound business practices
- Computer software, especially Microsoft Excel
- Applying accounting principles with methodologies to resolve problems.
- Research, analyze and interpret financial data, draw sound conclusions, recommend solutions and correct problems
- Interpret and apply relevant policies, ordinances and regulations
- Prepare clear, concise financial and fiscal reports
- Perform complex mathematical calculations accurately
- Maintain accurate and detailed accounting records
- Reconcile complex, high-volume accounts
- Work independently or with minimal supervision
- Exercise good judgment
- Interpret and follow city code, policies, regulations and procedures
- Recommend solutions and correct problems
- Maintain confidentiality with sensitive documents or information
- Communicate effectively in the English language at a level necessary for efficient job performance
- Perform all essential and marginal functions as assigned by an authorized employee, supervisor and/or manager with or without a reasonable accommodation.
Preferred Knowledge, Experience, And Training
Associate’s or bachelor’s degree in Finance, Accounting or related field or four years experience in revenue analytics.
Experience with contract analysis and complex spreadsheets, forecasts, trend analysis, graphs, and power point presentations.
Working knowledge of database and data visualization tools including database query languages such as SQL, VisQL, and or DAX.
Governmental accounting experience.
The physical effort characteristics and working environment described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Physical Efforts
While performing the duties of this job the employee is occasionally lifting/carrying up to 10 pounds. Also, the employee is occasionally pushing/pulling up to 10 pounds. Work includes sensory ability to talk, hear and touch. Work in this position also includes close vision. Employees will sit. Position requires hand/finger dexterity.
Working Environment
The work environment will include inside conditions.