Budget Systems Analyst

Brief Summary of Work for this Position

The Budget Systems Analyst provides complex comparative analysis of all budget, position control and financial data contained in the University’s ERP – Banner. This position will be responsible for proactively analyzing data for trends, interdependencies, errors, and regulatory compliance to determine best actions.This position provides support to divisional leaders on understanding, using, and correcting financial actions.

This position must maintain a thorough technical knowledge of University systems, the North Carolina Financial System (NCFS), the North Carolina Integrated Budget System (IBIS) and the North Carolina DataMart and how they interrelate to ensure the data integrity of all systems. Additional responsibilities may include complex analysis, reporting and reconciliations between internal and external systems. The Budget Systems Analyst is also responsible for technical support, development assistance, and testing of new systems and upgrades to ERP by providing recommendations on appropriate actions related to these essential systems and our budgetary data within them. This position will be the lead coordinator and manager of all system maintenance and upgrades as they impact the Budget Office. Overall, this position provides assistance in analysis, problem resolution, scenario development, training, presentation of data and recommending course of action based on knowledge of the university systems, state systems, GAAP, and state and / or federal regulations.

This position also assists the Director with data inquiries from Office of State Budget Management and the UNC System Office along with other various projects as needed. This position will also be a responsible lead for the Budget Office year-end processes that include the position budget roll, general funds operating roll, and the unbudgeted trust fund cash roll. This position will work closely with the Director of Budget to assist, as needed, throughout the major budgeting cycles, preparing data needed for requests internally and externally.

This position will be the primary interface with Ellucian to improve year end budget rolls and implementing new Banner functionality. This position will also be the lead for the Anaplan Special Funds and All Funds Budget modules and process and will work with TruEd on designing and implementing enhancements and new functionality for these two modules. Additionally, this position will assist in the training and supervision of a journey level budget analyst. Minimum Education and Experience Requirements A Bachelor’s degree and 3 years of relevant professional experience. All degrees must be received from appropriately accredited institutions. Preferred Education, Knowledge, Skills & Experience

• At least 5 years of experience working in a higher education or financially complex organization.
• Ability to detect trends in financial data and determine the cause and effect of scenarios.
• Ability to identify risks associated with financial transactions.
• Maintain presentation of data in understandable ways.
• Experience working with Banner, NCFS, IBIS, and Anaplan.
• Extensive analytics and reconciliation experience.
• Excellent presentation skills and experience working as a project or team lead.
• Fundamental knowledge and application of generally accepted accounting principles (GAAP).
• Experience performing detailed financial analysis and interpreting financial data and reports.
• Excellent oral and written communication skills, including the ability to communicate financial data to senior management.
• Ability to work effectively in a collaborative team-oriented environment and independently.
• Ability to manage multiple and competing deadlines successfully.
• Excellent computer skills, including experience with Microsoft Office (Excel, Word, and PowerPoint), reporting writing systems and ERP systems.
• Experience creating spreadsheets with formulas and functions.

Required Certifications or Licensures N / A Primary Purpose of Organizational Unit The Finance team within the Division of Business Affairs supports the University’s mission, strategic vision, goals, and objectives by providing key financial services efficiently and effectively. The Finance team provides financial services directly to students and the campus community. Units within Finance include the Controller’s Office, the Office of Budget, Planning and Analysis, Purchasing Services, Student Accounts and Cashiers, and Financial Systems.

The Budget Office supports the Division of Business Affairs and the University’s mission by providing budgetary support to the entire University community in terms of maintaining and monitoring their budgets so that the continuing development of students, faculty, and staff is ensured with funds from both public and private sources. This office seeks to maintain fiscal integrity through development, review, revision, and control. The Budget Office is responsible for planning, organizing, directing, supervising, and administering all budgeting functions related to the operation of UNCW. Through ongoing planning and assessment of services, the Budget Office seeks to adapt to environmental change. Reporting is provided to all departments and divisions of the University, the Office of State Budget and Management, and to the UNC System Office. The Budget Office is required to maintain the budgetary data in the Banner ERP system (position control in HR module and budget in Finance module), the North Carolina Financial System (NCFS), the North Carolina Integrated Budget System (IBIS), and the North Carolina DataMart for personnel budgets. The Budget Office is responsible for the consolidation and maintenance of University budget records in order to provide accurate and complete budget and financial data to University management, State and Federal agencies.