Budget Associate

The Budget Associate, an integral member of the BPHC Budget Office, will report directly to the Senior Budget Analyst and will be primarily responsible for collecting and refining expenditure data to assist the BPHC Budget Office with tracking budget-to-actual status for BPHC's operating budget. This will require extensive data refinement and analysis using offline tools such as Microsoft Excel. The position will be responsible for the following:

• Assist with the development, analysis, and preparation of the commission's annual budget and reforecasts.
• Pull, aggregate, review, and refine expenditure data from the current ledger system, Microsoft Dynamics GP 2018.
• Load refined expenditure data into dashboards to generate reports for review by Budget Office leadership.
• Track staffing data to assist with the generation of monthly FTE reports.
• Assist the Senior Budget Analyst in performing cost-benefit analyses to compare operating programs, review new budget requests, and explore alternative budgeting/forecasting methodologies.
• Under the direction of the Senior Budget Analyst, serve as a point of contact for collecting budget related data from bureau and department contacts.
• Assist with assembling presentation material for major budget review meetings which happen three times per year.
• Maintain records related to budget amendments, meetings, and reviews.
• Review budget amendments for thoroughness and compliance, assist with uploading amendments into the ledger system.
• Input requested staff cost allocation updates and report on impact to Budget Office leadership.
• Be cross trained to assist the accounting office with financial analyses and duties associated with the year-end close on an as needed basis.
• Monitor a shared inbox and triage incoming messages to ensure all requests are met in a timely fashion.
• Be able to operate independently as well as part of a cohesive team.
• Work in a confidential capacity.
• Proactively identify budget issues and report on them in a timely manner to Budget Office leadership.
• Performs other related duties as required.

Qualifications

• BA/BS in Finance, Accounting, Business, or related field required or;
• Associate Degree in Finance, Accounting, Business, Economics, or related field and 1 year of transferable accounting experience or;
• 1-2 years of transferable accounting experience may be substituted in lieu of degree.
• Plus at least 1 year of transferable Finance experience is required.

• Candidate must be a quick learner and a strategic thinker with strong business process skills with the ability to optimize business functions through focused improvement initiatives.
• Excellent computer skills; experience in accounting software, Microsoft Office Suite required.
• General ledger software experience required. Proficiency with Microsoft Great Plains a plus.
• Advanced Microsoft Excel skills a plus, especially the ability to perform analyses utilizing pivot tables and flowing data between multiple spreadsheet sources.

• Excellent communication, interpersonal, and writing skills.