Senior Compliance/Systems Analyst
Senior Compliance/Systems Analyst-1801852
Preferred Qualifications: Experience in a budget or financial planning office. Advanced Excel skills. Tableau skills. Pyramid querying skills. Website development skills. Evidence of interpretive ability and problem-solving skills. Experience reconciling in various financial systems. Some experience with graphing software. SBU Reporting experience. PeopleSoft query experience. Experience in a higher education setting.
Brief Description of Duties: The Senior Compliance/Systems Analyst is responsible for monitoring compliance between each area’s budget plans compared with their expenditure patterns. The incumbent will work with VP areas to adjust the budgeted CBM positions to align with available allocation. S/he is also responsible to manage alterations to funded position data. The incumbent will be the liaison to HRS and provide verification for budgeted recruitment activity. The incumbent will be the functional coordinator for all CBM system enhancements associated with the New Budget process including testing and troubleshooting new panels and fields needed to provide additional functionality to manage budget compliance. These reports/schedules will be used to create actionable data to inform senior managers. The incumbent must have the technical expertise to extract data from various financial systems and the experience to accurately interpret this data. As new schedules are needed, the incumbent should have the ability to work autonomously on their development and preparation. This position requires excellent database analysis skills. The selected candidate will have excellent communication skills.
- Develop reports for senior management to review expenditure patterns and identify anomalous budget practices that put the university at risk (monetarily or procedurally.)
- Develop ad-hoc reports and queries incorporating rigorous analytics to detect deviations from each unit’s annual financial plan.
- Develop ongoing assessment metrics to review each area’s condition (financial and/or performance metrics.)
- Assess the reasonableness of negative budget entries (anticipated revenue). These determinations must be made using historical earnings by category with comparable growth factors.
- At biweekly meetings with VP Budget and HR coordinators, work with VP areas to develop new position management tools to facilitate budget compliance and to enhance existing tools as needed.
- Other schedules as assigned. The incumbent should be able to generate data via PeopleSoft, Tableau, and data warehouse queries and organize that data into reports that the Director of Budget & Analysis can present to high level administrators.
- Develop specifications and work with the programming team to implement new panels, reports, and processes that incorporate supplemental information that is useful to financial managers. CBM panels and reports require collaboration with the Information Systems CBM programmers. Reports for the SBU reporting environment will require collaborating with the data warehouse programming team.
- Develop data load procedures related to the supplemental information that is being added to CBM.
- Test, document, and train users on all related system enhancements and reports.
- Build/modify and run reports to generate VP area Savings Targets.
- Distribute reports and communicate savings targets to VP area financial leaders.
- Track VP area progress with submitting their budgets and perform analysis of the results. - Work with areas for viable budget resolutions.
- Identify potential risks/concerns with submitted budget plans.
- Review and address areas with budgeted FTEs that are at variance with their available allocation.
- Research and verify funding availability related to personnel change requests submitted by VP areas. Pass onto HR after receiving approval of Director of Budget & Analysis.
- Meet with HR and financial leaders periodically to get feedback on the new recruitment process and review and resolve issues. 5% E Training and Documentation:
- Train campus users on new compliance reports and panels as they are developed.
- Prepare documentation related to compliance and position control.
- Update and maintain web documentation related to compliance and savings plan.
- Preparation of various financial charts and slides. The incumbent should have the ability to interpret the data specifications provided by the supervisor and develop ad hoc charts and slides independently with the use of various software packages. An example would be development of a query to generate data based on specific criteria given by the incumbent’s supervisor, organization of that data into a report for high level administrators, and translation of the results into a requested graph type.
- Other duties or projects as assigned as appropriate to rank and departmental mission.
Stony Brook University is 100% tobacco-free as of January 1, 2016. See our policy and learn more at stonybrook.edu/tobaccofree.
Pursuant to Executive Order 161, no State entity, as defined by the Executive Order, is permitted to ask, or mandate, in any form, that an applicant for employment provide his or her current compensation, or any prior compensation history, until such time as the applicant is extended a conditional offer of employment with compensation. If such information has been requested from you before such time, please contact the Governor’s Office of Employee Relations at (518) 474-6988 or via email at [email protected]
About Stony Brook:Stony Brook University, home to many highly ranked graduate research programs, is located 60 miles from New York City on Long Island's scenic North Shore. Our 1,100-acre campus is home to 24,000 undergraduate, graduate, and doctoral students and more than 13,500 faculty and staff. SBU is a comprehensive research-intensive university and a member of the prestigious Association of American Universities (AAU), which includes 34 public universities among its 62 members. SBU consists of 12 schools and colleges and a teaching hospital that provides state-of-the-art healthcare in the Long Island region. SBU also manages and performs joint research with Brookhaven National Laboratory, the only Department of Energy Laboratory in the Northeast, and shares doctoral programs with Cold Spring Harbor Laboratory, a world-renowned molecular biology institute. Home to the Emerson String Quartet, the Jackson Pollock House in East Hampton, New York, the Humanities Institute, and the Southampton Arts Program, and with endeavors that extend to the Turkana Basin Institute in Kenya and the Ranomafana National Park in Madagascar, SBU sustains an international reputation that cuts across the arts, humanities, social sciences, and natural sciences.
Stony Brook University is an Affirmative Action/Equal Opportunity employer. We encourage protected veterans, individuals with disabilities, women and minorities to apply.
If you need a disability related accommodation, please call the University Human Resource Services Department at (631) 632- 6161 or the University Hospital Human Resources Department at (631) 444-4700. In accordance with the Title II Crime Awareness and Security Act, a copy of our crime statistics is available upon request by calling (631) 632- 6350. It can also be viewed on line at the University Police website at http://www.stonybrook.edu/police.
Official Job Title: Assistant for University Financial Analysis
Job Field: Administrative & Professional (non-Clinical)
Primary Location: US-NY-Stony Brook
Department/Hiring Area: Budget Office-Stony Brook University
Schedule: Full-time Day Shift 8:30 a.m. - 5:00 p.m.Budget Office-Stony Brook University
Posting Start Date: Sep 10, 2018
Posting End Date: Sep 24, 2018, 11:59:00 PM
Salary: Commensurate with experience within the range of $70,000-$80,000.
Salary Grade: SL4