Budget Systems Architect & Analyst

Syracuse University; City of Syracuse (NY); On-site; USD 115,000 - 135,000; Full time

Job summary

Syracuse University in Syracuse, NY seeks a financial systems specialist to support Hyperion Planning and Essbase and PeopleSoft Financials. The role blends functional and technical work on a team delivering budgeting, data warehousing, and analytical capabilities for campus leaders.

You will design, implement, and maintain Hyperion and PeopleSoft modules, develop queries and reports, and support daily operations and upgrades to ensure accurate university financial analytics.

Qualifications

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

Responsibilities

• Interpret and apply University financial policies, manage resources, and initiate actions to achieve broadly defined objectives.
• Design, analyze, code, and implement applications within the Hyperion Planning framework that support and enhance the University’s financial systems used by university departments in the analysis and interpretation of budget data.
• Create, update, modify, and develop specialized data and reporting tables and structures for Budget Directors and Managers and OBP personnel.
• Respond to Director’s and/or senior university leadership requests for specialized analytics.
• Develop, modify, and review financial reports and data for monthly financial analysis.
• Provide input into strategic decisions that affect financial planning, policies, practices, and operations for Financial Centers across Campus.
• Work with users to translate requirements into financial reports in Hyperion and PeopleSoft environments.
• Maintain and upgrade the PeopleSoft and Hyperion Planning systems, including data audits and security.

Skills

SQL proficiency

Data analysis

Budget analytics

Team collaboration

Education

Bachelor’s degree in MIS / Accounting / CS

Tools

Tableau

Power BI

Hyperion Planning

Essbase

PeopleSoft Financials

HCM

Smart View

Microsoft Office

Job description

Syracuse University is committed to delivering an exceptional student experience through vibrant, engaged campus communities. This position is based at the above campus location and requires regular in-person presence to support our students, collaborate with colleagues, and contribute to our thriving academic environment. Syracuse University values the collaboration, mentorship, and spontaneous connections that happen when our community works together on campus. Remote work arrangements are limited in accordance with University policy.

Pay Range

Pay Range $115,000 -$135,000

Pay rates at Syracuse University are based on a combination of factors including, but not limited to, the job responsibilities; the candidate’s education, training, work experience and key competencies; the university’s strategic priorities; internal peer equity; applicable federal, state, local laws, grant funding and contractual requisites; and external market analyses.

Staff Level

Staff Level S5

FLSA Status

FLSA Status Exempt

Hours

Standard University business hours

8:30am – 5:00pm (academic year)

8:00am – 4:30pm (summer)

Hours may vary based on operational needs.

Job Type

Full-time

Unionized Position Code Not Applicable

Job Description

This position has an active role in the daily support of the Hyperion Planning and Essbase environment and PeopleSoft Financials. The position will work in a combined functional and technical environment and will work on a team responsible for the integration of financial transactional systems, data warehousing, data modeling and analysis, and planning and budgeting systems that support the delivery of financial and analytical data to business end-users and University leaders. The position is responsible for designing, building, implementation, maintenance, and future system enhancements of the Hyperion Planning and Essbase environment as well as modules within the PeopleSoft Financials system for budget related functionality and data related to budgeting processes. The position will also work on a team responsible for developing and maintaining queries and reports using the University’s query, reporting, and analysis tools.

Education and Experience

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

Skills and Knowledge

Bachelor’s degree required in MIS , Accounting, Computer Science or a related field and at least 5 years of experience.

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 that support and enhance the University’s financial systems used by university departments in the analysis and interpretation of budget data.
• Create, update, modify, and develop specialized data and reporting tables and structures for Budget Directors and Managers and OBP personnel.
• Respond to Director’s and/or senior university leadership requests for specialized analytics. Develop, modify, and review financial reports and data that can be used for monthly financial analysis.
• Provide input into strategic decisions that affect 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 a complex Hyperion and or PeopleSoft environment.
• Applications to include (but not limited to) department tree, account tree, and several additional hierarchy trees used for application buildup. Daily maintenance of PeopleSoft Financials and Hyperion Planning systems, to include (but not limited to) log clean-up, troubleshooting, user and group security, performance tuning, and dimension audits.
• Create and update data audit reports for various feeder systems and work and lead projects to enhance capabilities and services that the office provides with regards to the financial management of the university.
• This includes upgrades, patches and fixes to the PeopleSoft and Hyperion Planning systems.
• Preparation for the annual budget and setup of the training environment, including daily data audits, pre-system opening reporting, post-system closing reporting, and assistance with data feeds to HR and GL

Physical Requirements

Not Applicable

Tools/Equipment

Not Applicable

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 scope of Syracuse University is a testament to its strengths: a pioneering history dating back to 1870; a choice of more than 200 majors, 100 minors, and 200 advanced degree programs offered across the University’s 13 schools and colleges; over 15,000 undergraduates and over 6,000 graduate students; more than a quarter of a million alumni in 160 countries; and a student population from all 50 U.S. states and 123 countries. For more information, please visit http://www.syracuse.edu.

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 ranging from water skiing and snow skiing, hiking in the Adirondacks, touring the historic sites, visiting wineries along the Finger Lakes, and biking on trails along the Erie Canal.

EEO Statement

Syracuse University is an equal-opportunity institution. The University prohibits discrimination and harassment based on race, color, creed, religion, sex, gender, national origin, citizenship, ethnicity, marital status, age, disability, sexual orientation, gender identity and gender expression, veteran status, or any other status protected by applicable law to the extent prohibited by law. This nondiscrimination policy covers admissions, employment, and access to and treatment in University programs, services, and activities.

Commitment to Supporting and Hiring Veterans

Syracuse University has a long history of engaging veterans and the military-connected community through its educational programs, community outreach, and employment programs. After World War II, Syracuse University welcomed more than 10,000 returning veterans to our campus, and those veterans literally transformed Syracuse University into the national research institution it is today. The University’s contemporary commitment to veterans builds on this historical legacy, and extends to both class‑leading initiatives focused on making an SU degree accessible and affordable to the post‑9/11 generation of veterans, and also programs designed to position Syracuse University as the employer of choice for military veterans, members of the Guard and Reserve, and military family members.

Commitment to a Respectful and Welcoming Community

Syracuse University fosters a welcoming learning environment where students, faculty, administrators, staff, curriculum, social activities, governance, and all aspects of campus life reflect a broad range of perspectives and experiences. The University community values the many similarities and differences among individuals and groups. At Syracuse, we are committed to preparing students to engage with and appreciate the richness of backgrounds, beliefs, and experiences that shape our society. To achieve this, we strive to cultivate a community that respects and encourages open dialogue, understanding, and mutual respect.

Required fields are indicated with an asterisk (*).