Budget Analyst Intermediate

Quest Oracle Community; Ann Arbor, Northern (MI, KY); On-site; USD 65,000 - 90,000; Full time

Job summary

University of Michigan Library is seeking a Budget Analyst to support the Publishing division and library finance. You will perform financial planning and analysis, manage transactions, and participate in year-end closing with internal controls.

Responsibilities include budgeting, reporting, general ledger activity, royalty processing, procurement support, and SOP development. You will collaborate with a Finance team to deliver accurate statements and ensure policy compliance.

Qualifications

• Bachelor's degree in accounting, finance, or related field.
• 2+ years of experience as an accountant, financial analyst, or budget analyst.
• Experience with financial analysis, budget development, general ledger activities, reconciliations, auditing, monitoring, and presenting financial information clearly.
• Proficiency with reporting tools, databases, and advanced spreadsheet functions, including SQL/Oracle/Excel PivotTables/VLOOKUP/Google Sheets.
• Strong analytical, problem-solving, organizational, and communication skills.
• Experience managing varied work in an environment with shifting priorities.
• Excellent customer service, attention to detail, and ability to handle sensitive information.

Responsibilities

• Financial Planning, Analysis, and Budget Monitoring: monitor, reconcile, and analyze budgets; track costs, revenues, and projections.
• Financial Reporting and Data Management: prepare financial statements, develop reports and variance analyses, manage ebook sales data.
• General Ledger and Transactional Operations: process AP/AR/travel; post journal entries; reconcile accounts; year-end activities.
• Royalty Management and Contract Administration: enter contracts; prepare/upload royalty data; reconcile royalties; liaise with authors.
• Procurement, Purchasing, Internal Controls: support RFQ/RFP processes; ensure internal controls; troubleshoot procurement issues.
• Process Documentation, Training, and Support: develop SOPs; train staff; back up colleagues; contribute to special projects.

Skills

Financial analysis

Budget development

General ledger

Reconciliations

Auditing

Data reporting

Communication

Education

Bachelor's degree in accounting/finance

Tools

Business Objects

SQL

Oracle

Excel PivotTables

VLOOKUP

Google Sheets

Job description

Financial staff serve as consistent partners within the University of Michigan Library by providing reliable support across the library. As the Budget Analyst, you will support the financial and business operations of the Publishing division, and broader financial processes across the library. Working within an experienced and mutually supportive team, your responsibilities will include financial planning and analysis, financial transactions support, reconciliations, royalty processing, procurement, and financial reporting. Annually, you will work with the finance team members on library-wide budget deliverables, fund allocations, and budget projections. You will also be responsible for fiscal year-end activities and internal controls.

Responsibilities

• Financial Planning, Analysis, and Budget Monitoring: Monitor, reconcile, and analyze assigned budgets, accounts, and project grants, including identifying trends, costs, revenues, commitments, and future projections; Analyze sales and related transactions to prepare journal entries for the general ledger; Track production cost information for individual contracts and process/track subvention requests and payments; Collaborate with the finance team on library-wide budget deliverables, including fund allocations and annual budget projections.
• Financial Reporting and Data Management: Prepare client financial statements as required by specific contracts and maintain historical sales files; Develop financial reports and variance analyses to support librarywide budget-related materials; Manage the preparation, submission, and tracking of ebook sales and associated payments; Audit financial information from external sources to ensure total accuracy and contract compliance.
• General Ledger and Transactional Operations: Execute financial transactions, including accounts payable, accounts receivable, travel and expense, and requisitions; Prepare and record journal entries in the general ledger to accurately reflect business activity; Reconcile balance sheet accounts and budget lines against third-party records. Manage fiscal year-end activities and ensure all transactions are completed within established timelines.
• Royalty Management and Contract Administration: Enter and maintain contracts and related data within specialized royalty software; Prepare and upload sales and income data for royalty processing; Audit and reconcile royalty balances, serving as a point of contact for authors regarding their statements and payments.
• Procurement, Purchasing, and Internal Controls: Support purchasing and bid-related processes, including the preparation of requests for quotations (RFQ), requests for proposals (RFP), and sole source justifications; Review financial activity for policy compliance and alignment with University internal controls; Troubleshoot and resolve issues related to financial transactions or procurement workflows.
• Process Documentation, Training, and Professional Support: Develop and maintain standard operating procedures (SOPs) and supporting documentation for both Publishing and Library Finance operations; Provide guidance and training to non-finance staff regarding financial procedures, budget processes, and system usage; Serve as a backup for colleagues and contribute to special projects as assigned to ensure consistent support across the library.

Required Qualifications

• Bachelor's degree or equivalent experience in accounting, finance, or a related field, with knowledge of accounting and financial principles.
  2+ years of experience as an accountant, financial analyst, or budget analyst.
• Experience with financial analysis, budget development, general ledger activities, reconciliations, auditing, monitoring, and presenting financial information clearly.
• Proficiency with reporting tools, databases, and advanced spreadsheet functions, including tools such as Business Objects, SQL, Oracle, Excel PivotTables, VLOOKUP, and Google Sheets.
• Strong analytical, problem-solving, organizational, and communication skills, with the ability to anticipate issues, take initiative, and meet established timelines.
• Experience managing varied work in an environment with shifting priorities, both independently and as part of a team.
• Excellent customer service skills, attention to detail, accuracy, and ability to handle sensitive information.

Desired Qualifications

• Experience with higher education budget processes, cycle, and requirements.
• Experience with publishing industry finance.
• Experience with revenue and non-profit accounting standards and activities.