Accounts Receivable (AR) Analyst

City of Boise; Boise (ID); Hybrid; USD 65,000 - 85,000; Full time

Job summary

The City of Boise's Finance Department seeks an Accounts Receivable Analyst to join our team in a hybrid role combining financial analysis, data work, and cross‑department collaboration. You will analyze revenue trends, develop reports and dashboards, work with the ERP system, and support cost-recovery and billing processes while advising on internal controls.

Strong Excel and data visualization skills (Power BI) are a plus, with a focus on turning financial data into actionable insights for

Qualifications

• 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.

Responsibilities

• Analyze revenue and financial trends to inform decision-making.
• Develop reports and dashboards using ERP data and Power BI/Excel.
• Support contracts, cost-recovery calculations, and cross-department procedures.

Skills

Analytical thinking

Data analysis

Financial analysis

Reporting

Education

Bachelor's degree in finance, economics or closely related field

Tools

Power BI

Excel

Job 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.

To ensure internal equity and alignment with the approved budget for this position, offers are made within the posted hiring range. Although the hiring range is fixed, employees receive an exceptional benefits and total rewards package that enhances the overall value of employment with the City of Boise.

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

• 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.

Ability to:

• 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.

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.