Assistant for University Financial Analysis

Location: Albany, NY Category: Professional Positions Posted On: Fri Oct 25 2024 Job Description:

This position is in the Office of the University Controller. It will assist with processing and reviewing monthly and quarterly reports as well as processing a wide array of revenue transactions in a similar time frame or on an as needed basis. This position will also assist with system development, maintenance, and enhancement of the Business Intelligence (BI) reporting tool.

General Duties And Responsibilities

• Assist with analyzing and monitoring campus or program financial performance utilizing the State University's automated systems and campus reports. Identify emerging issues and recommend solutions. Use appropriate computer software programs including spreadsheets to assist in this analysis.
• Work with the Office of Information Technology (IT) and assist campuses with BI reporting system.
• Provide clear and accurate verbal and/or written reports, including tabular presentations, to supervisors and managers regarding financial and procurement matters.
  
  

Specific Duties And Responsibilities

• Assist with development, enhancement, and maintenance of the University's accounting system reporting tool (BI) for all areas of finance reporting. Includes identifying performance and other issues, identifying necessary enhancements, reporting issues to SUNY's Team Dynamix tracking system, designing BI dashboard pages, and working with IT team on implementation.
• Utilize systems and applications including SUNY Business Intelligence, SUNY Financial Management System (FMS), Statewide Financial System (SFS), and SFS Analytics to perform responsibilities and enhance analytical capabilities.
• Assist and provide training to campuses in all areas of BI finance reporting tool and cash reporting. Act as a resource for the campuses on BI Finance dashboards and analysis and cash reporting in the resolution of problems.
• Assist with University cash reporting for core academic operations, residence halls, self-supporting funds and hospitals, including cash by account reporting.
• Assist with the development of University's Financial Management System as it relates to cash reporting.
• Prepare various periodic financial reports.
• Prepare and review the quarterly Cash Reserve Percentage Report to monitor campus cash thresholds and causes of large increases or decreases from quarter to quarter.
• Prepare the bi-monthly receipt and disbursement projections vs. actuals report and provide to senior management, Division of Budget (DOB), and the state senate.
• Prepare the bi-monthly receipt and disbursement projections vs. actuals report and provide to senior management, DOB, and the state senate.
• Process and review month end Medicaid report, as well as related hospital program revenue transfers, to provide reporting numbers for OSC.
• Processing and recording of various financial transactions:
• Process quarterly revenue transfers for state tax support/pooled offset, and monthly revenue transfers for scholarship payments from Higher Education Services Corporation (HESC).
• Process quarterly Facilities to Hard Dollar payroll transfers.
• Reclassify and distribute quarterly rebates from the Citibank cards from Office of General Services (OGS) to the state operated campuses.
• Process revenue transfers for quarterly and annual loans to state operated campuses and quarterly fringe benefits payments for the Long Island Vets Home.
• Process monthly revenue journals (AC909s) relating to Crown Castle revenue shares and Pell Grant drawdowns as needed.
• Assist in revenue transfers to and from the state operated campuses and the SUNY Construction Fund, as well as applying coding to post to our BI system properly, as needed.
• Process OGS surplus revenue to campuses as needed.
• Assist with the banking services function and allocation distribution for campuses. Serve as a liaison to the State Comptroller's Office (OSC) and campuses for banking matters.
• Report monthly bank balances to OSC.
• Provide clear and accurate verbal and/or written reports, including tabular presentations, to supervisors and managers regarding financial matters.
• React to a wide range of internal (campus personnel, system administration, senior management) and external (OSC, DOB) ad hoc information or data requests.
• Complete other tasks, as assigned by SUNY Leadership.
  

Job Requirements

Required Qualifications:

• Bachelor's degree in Accounting, Business, or related field required
• In-depth knowledge of and experience with spreadsheet packages, database packages, web applications and presentation software
  
  

Preferred Qualifications

• Experience utilizing web-enabled applications (e.g., Oracle Business intelligence)
• Experience in a higher education environment or financial administration
• Ability to communicate complex information with various levels of management, campuses, and other agencies
• Other important skills such as excellent analytical ability and oral and written communication skills
  
  

Additional Information

• Salary is dependent on a variety of factors, including but not limited to, experience, education, training, and certifications. The range for this position is $56,000 - $62,000.
• Excellent Benefit Package which includes: NYS health insurance, free dental and vision coverage, competitive retirement options, tuition assistance, parental leave at full pay, and generous vacation, sick, and holiday time. 13 days of paid holidays per year; 21 days of vacation and 21 days of sick time accrued each year. Please see our Management/Confidential benefits summary for additional information.
• Management/Confidential appointments work under the leadership and discretion of the appointing authority and are not represented by a union.
• This position will be based in Albany.
  
  

Applicants must be currently authorized to work in the United States on a full-time basis.

SUNY System Administration Benefits

SUNY System Administration provides an outstanding and comprehensive benefits package to support you and your family through the many life changes you may experience while you work for SUNY. Our nationally recognized benefits include:

• Retirement: The choice between a fully funded pension plan and a self-driven defined contribution plan, along with two supplemental plans to increase your ability to save for retirement.
• Health Insurance: Several health insurance options at an affordable cost that provide full coverage without mandatory deductibles.
• Time Off: Paid time off with separate vacation and sick leave accruals up to 21 days a year for each category.
• Additional paid leave policy options for childbirth, adoption, elder care, and other family care situations.
• Flexible Working Arrangements: Flexible working arrangements, including hybrid schedules, are available depending on position.
  
  

Explore our full benefits offerings here: www.suny.edu/benefits