Financial Management Analyst II

Occupational Summary

This position plays a key role in fostering financial strength by developing and coordinating financial reporting and analysis, budget development, and financial control monitoring for both operational and non-operational activities on behalf of the Divisions of General Internal Medicine and Geriatrics/Palliative Care within the Department of Medicine (DOM).

The role requires close collaboration with stakeholders across and beyond the division, cultivating strong relationships to achieve shared objectives.

Primary Job Responsibilities

• Provide support for the accounting activities and financial reporting associated with maintaining the operational and non-operational divisional activities, which will include:
• Budget development and monitoring of actual financial activities associated with divisions budgets, both SOM and DHIP to include monthly variance reporting and analysis.
• Prepare trend analyses and reporting, as needed both operational and non-operational programs noting trends that require intervention on level of spending.
• Generate monthly reports for all institutional funds including startup funds, discretionary funds, and internal grants. Special attention should be given to those codes with limited funds for spending to proactively limit any overspending of the funds and keep Divisional leadership abreast of the balances within these funds alerting them to negative trends in spending.
• Perform monthly (and year end closing) process for the division to include processing of journal entries and review and approval of expenditures on any and all types of fund codes across the divisions ensuring the proper funds flow occurs. In addition, serve as the lead for tracking and submitting supplemental payments.
• Responsible for various aspects of the SOM’s monthly/quarterly FAM analysis and reconciliation process together with overdraft management on fund codes/WBSE within the divisions.
• Prepare & manage staff and faculty salary cost distributions and submit all iForm and SEA change submissions; ensuring the appropriate funds are used based on divisional operating budget and/or other programmatic codes.
• Help to support annual effort reporting and certification in concert with the Divisional DA’s and departmental research administration team.
• Work with faculty to develop budget proposals for educational events / CME courses.
• Track invoices, payments, expenses and distribution of funds.
• Work with the Department of Medicine to reconcile problem invoices from Accounts Payable, following up with purchasers to ensure timely payment of invoices.
• Serve as support to one Program Coordinator and one Staff Assistant and their financial scopes of work. Additionally, serve as the backup on activities to include: Buy@Duke contact for Division employees. Procurement contact: Submitting and approving shopping carts, invoice submissions, AP Check request submissions, Buy@Duke questions, AP questions, blocked invoices and goods receipts; assist the labs with their purchases, AP issues, and equipment maintenance agreements. Monitor revenue for clinical outreach contracts, potentially serving as the lead POC with DHIP AR.
• Be able to understand and facilitate conversations with faculty on their discretionary account spending.
• Provide oversight of timely processing/reporting of corporate card activities and other expenditures within the Concur system at Duke.
• Responsible for various accounting aspects associated with endowments within the division, to include monitoring of spending on various endowments, with an understanding of the restrictions associated with those funds.
• Interact on a regular basis with the Division Administrators, and routinely collaborate with other divisional administrative positions, faculty members, as well as staff in the DOM central offices such as DOM Finance, DOMRA, CRU and HR and APT.

Preferred Qualifications

• Demonstrated financial knowledge and expertise with using general ledger systems and working with large volumes of data from various systems.
• Strong accounting skills with attention to details and ability to analyze financial data and present results in concise and clear manner in reports for management use.
• Strong analytical skills combined with investigative and curious mindset to problem solve.
• A critical thinker with the ability to understand complex processes and evaluate solutions.
• Mastery of Microsoft Office Applications, especially MS Excel, understanding pivot tables, and graphs.
• Excellent written, oral and conversational skills to effectively work with diverse groups.

Required Qualifications

• Education/Training: Work requires a Bachelor's degree in Accounting, Finance, Economics, Business Administration or a related field. CPA is desirable.
• Experience: Work requires three years experience in financial management, cost accounting or a field directly related to specialized area of assignment.