Budget Systems Architect & Analyst

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 Application Instructions In addition to completing an online application, please attach a resume and cover letter. 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.