Budget Systems Architect & Analyst

About the Role

This position plays an active role in the daily support of the Hyperion Planning and Essbase environment and PeopleSoft Financials. The role operates in a combined functional and technical environment, working within a team responsible for integrating financial transactional systems, data warehousing, data modeling and analysis, and planning and budgeting systems that deliver financial and analytical data to business end-users and University leaders.

The position is responsible for designing, building, implementing, maintaining, and enhancing the Hyperion Planning and Essbase environment, as well as modules within PeopleSoft Financials related to budget functionality and data. The role also involves developing and maintaining queries and reports using the University’s query, reporting, and analysis tools.

Responsibilities

• Interpret and apply University financial policies, manage resources, and initiate actions to achieve broadly defined objectives.
• Interpret, organize, and execute projects with limited direction in a highly specialized and data-driven environment.
• Design, analyze, code, and implement applications within the Hyperion Planning framework to support and enhance the University’s financial systems used for budget data analysis and interpretation.
• Create, update, modify, and develop specialized data and reporting tables and structures for Budget Directors, Managers, and OBP personnel.
• Respond to requests from Directors and/or senior university leadership for specialized analytics.
• Develop, modify, and review financial reports and data for monthly financial analysis.
• Provide input into strategic decisions affecting financial planning, policies, practices, and operations for Financial Centers across Campus.
• Work extensively with users across the university to translate requirements into financial reports in complex Hyperion and/or PeopleSoft environments, including applications such as department trees, account trees, and additional hierarchy trees.
• Perform daily maintenance of PeopleSoft Financials and Hyperion Planning systems, including log clean-up, troubleshooting, user and group security, performance tuning, and dimension audits.
• Create and update data audit reports for various feeder systems and lead projects to enhance capabilities and services related to the financial management of the university, including upgrades, patches, and fixes to PeopleSoft and Hyperion Planning systems.
• Prepare for the annual budget and set up the training environment, including daily data audits, pre-system opening reporting, post-system closing reporting, and assistance with data feeds to HR and GL.

Requirements

• Bachelor’s degree in MIS, Accounting, Computer Science, or a related field.
• At least 5 years of relevant experience.

Preferred Qualifications

• 5+ years of experience in SQL using Tableau, Power BI, and/or other data tools.
• 5+ years of experience in Hyperion Planning & Essbase, including building out servers and applications.
• 5+ years of experience in PeopleSoft Financials, HCM, and Student Campus Solutions.
• 5+ years of experience with Microsoft Office Tools and the Smart View add-in.

About Syracuse University

Syracuse University is a private, international research university with distinctive academics, diversely unique offerings, and an undeniable spirit. Located in the geographic heart of New York State, with a global footprint and over 150 years of history, Syracuse University offers a quintessential college experience. The University provides a choice of more than 200 majors, 100 minors, and 200 advanced degree programs across its 13 schools and colleges, serving over 15,000 undergraduates and over 6,000 graduate students. The University has a student population from all 50 U.S. states and 123 countries.

About the Syracuse Area

Syracuse is a medium-sized city situated in the geographic center of New York State, approximately 250 miles northwest of New York City. The metro-area population totals approximately 500,000. The area offers a low cost of living and provides many social, cultural, and recreational options, including parks, museums, festivals, professional regional theater, and premier shopping venues. Syracuse and Central New York present a wide range of seasonal recreation and attractions, from water skiing and snow skiing to hiking in the Adirondacks, touring historic sites, visiting wineries along the Finger Lakes, and biking on trails along the Erie Canal.