Reporting to the Associate Director of Budget Planning & Systems the Financial Systems Analyst is responsible for supporting the University Budget Office by building financial models, overseeing database management, analyzing operations, creating and managing reports.
Tasked with developing complex models, working within the web-based strategic planning model, overseeing databases, designing reports by leveraging existing ERP and database tools to provide clear actionable reporting. The successful candidate will have extensive experience with financial modeling, database maintenance, strong data analysis skills, advanced Excel skills, and exhibit strong, creative, problem-solving skills, and collaborative abilities. This position requires proficiency in data analysis, extensive knowledge of ERP systems and databases as well as having a strong analytics aptitude and the ease/ability to communicate with operating managers.
Collaborates with colleagues and outside consultants to enhance the state-of-the-art university strategic planning model by becoming an expert user, developing various reports used for analysis and decision making, improving upload and download capabilities, building new fields and programs, learning and writing formulas, and troubleshooting problems.
Responsible for building, loading and maintaining various budget databases including building reports, and layouts, troubleshooting database errors and proactively seeking ways to enhance the databases for efficiency and ease of use.
Serves as a functional lead within the Budget Office to translate business requirements into technical requirements for development, testing and troubleshooting. Ensure that application programs are tested and regular quality assurances are conducted. Serves as functional expert for Financial systems and is the technical liaison between the Budget Office and IS&T resources. Facilitates continuous business process improvement by identifying and implementing system efficiencies. Lead user acceptance testing, develops test cases from analyzing business and system requirements and conducts test execution. Proactively reviews system security to identify gaps and collaboration with IS&T to ensure appropriate user access. Create ad hoc reports using PeopleSoft Query Manager or other reporting tools. Respond to user requests for application support and troubleshoots system problems.
Bachelor's degree from an accredited college in a related discipline
10 + years’ experience in an analytical capacity building high value financial models, databases and reporting
7-10 years' experience supporting finance
High degree of proficiency in Microsoft Office Suite, Excel, including building and modifying complex pivot tables and macros for reporting and dashboards
Experience with building functional, data driven dashboards for real-time forecasting
Experience in aggregating and integrating data points for functional analysis within dashboards
Strong analytical skills, with experience developing financial models and analysis
Proficiency in relational databases and related database tools
Detail oriented with strong quantitative skills and strong knowledge of financial modeling, analysis and reporting techniques
Must have proven ability to develop and maintain dashboard reports for business units along with key metrics and savings capacities
Highly motivated, self-starter who manages projects end-to-end and has a demonstrated track record of getting results, organizing and prioritizing deadlines
Commitment to work in a team-based environment and acceptance of multi-directional feedback
Demonstrated ability to drive continuous improvement and solve problems while collaborating with stakeholders on their needs
Ability to multi-task, which requires strong organizational skills, attention to detail and high degree of accuracy
Possess excellent verbal, written and interpersonal communication skills and have a process improvement oriented mindset
Ability to manage competing priorities in a professional manner
Results-oriented individual with the ability to adapt to a frequently changing environment
Ability to maintain a high level of privacy and confidentiality, and to consistently demonstrate a professional and diplomatic manner
Ability to maintain calm, professional demeanor under deadlines, pressure and/or critical, urgent priorities
MS degree in Management Information Systems, Economics, Finance, Accounting or Business, MBA, or equivalent combination of education and experience
Higher Education work experience
FileMaker Pro experience
Familiarity with object oriented modeling and/or programming concepts is preferred
Applicants for Staff and Administrator positions must be currently authorized to work in the United States on a full-time basis. Chapman University does not sponsor applicants for Staff and Administrator positions for work visas.
The offer of employment is contingent upon satisfactory completion and outcomes of a criminal background screening, credit check, and returning to the Office of Human Resources a signed original acceptance of the Chapman University Agreement to Arbitrate.
Internal Number: 19991
About Chapman University
Chapman University is one of California's oldest and most respected private universities, offering distinguished undergraduate and graduate degrees in the context of a liberal arts and sciences university. For more than 150 years, Chapman University has served as a symbol of educational access and excellence in the state of California. Founded as Hesperian College in 1861 in Woodland, California by members of the Christian Church (Disciples of Christ), we admitted men and women and people of color from our earliest days. Endowed by the Valencia orange magnate Charles Clarke Chapman, the institution changed its name to Chapman College in 1934, and by 1954 had moved to the former campus of Orange Union High School in Orange, California. The college again extended higher educational access when it began offering classes to military personnel at El Toro Marine Base.In 1965, Chapman took undergraduate education to the high seas when it began running World Campus Afloat, the program that would eventually become Semester at Sea, a tradition that continues at Chapman through our world-wide study abroad programs.Since our founding, Chapman has grown into a highly regarded university that at...tracts high-achieving undergraduate and graduate students from all over the United States, and more than 60 nations around the world.Our mission statement: To provide personalized education of distinction that leads to inquiring, ethical and productive lives as global citizens.