St. John's established in 1870, has three New York City campuses; a graduate center in Hauppauge, NY; international locations in Rome, Italy; Limerick, Ireland; and Paris, France; and study abroad locations around the world. The Princeton Review and other top rankings consistently recognize the University's outstanding academics, diverse student body, dynamic internship and volunteer opportunities, focus on student life, and diverse study abroad offerings. St. John's University offers more than 100 undergraduate and graduate programs in its six colleges and schools, with a growing number of programs offered online. The University is accredited by the Middle States Commission on Higher Education and 12 other major academic and professional associations.
A dedication to diversity, equity and inclusion is at the heart of our mission. As a Catholic and Vincentian university, St. John's is committed to institutionalizing practices of inclusive excellence to ensure that we welcome and celebrate the intrinsic worth of all members of our community. We will become an even stronger university as we enhance equity at every level of our institution. As noted in our Vision Statement, our graduates will excel in the competencies and values required for leadership and service in a rapidly evolving world.
Job Summary: The Advancement Services Reporting Analyst will report directly to the Director of Advancement Services. This position will be responsible for supporting the Advancement Office with the university's enterprise resource planning system (ERP), Ellucian Banner, participating in the data maintenance plan, completing ad hoc and custom report requests, generating alumni, financial, donor, prospect and related reports for the division of Institutional Advancement and the University community.
Gain a thorough understanding of the Ellucian/Banner system, keep up-to-date on new and existing functionality and gain the ability required to update biographical information and research constituents and organizations. Updates include, but are not limited to: name changes, address changes, salutations, employment information updates, telephone number changes, e-mail address updates, the ability to create new records or update existing records in the database and the ability to enter various types of activity
Work with the Advancement Services team to implement the department's data maintenance plan by coordinating with external vendors to obtain constituent data and updates and performing audits for data integrity Updates include e-mail appends, address maintenance, lost alumni searches, telephone appends and various other fundraising related data extracts and updates, research, detection and deletion of duplicate records, perform and manage batch system updates, and manage various other database management and clean-up procedures
Manage QuadWrangle operations, including, Resident Expert responsibility for the Alumni Community, managing access issues including any user related issues with logins, passwords, new user registration, Also responsible for training new and existing staff on using the administrative functions of the tool including Directory Admin, Broadcast e-mail segments and reporting, user stats, downloading data updates, generating reports for online giving and events, RSVP confirmation process, working with University Events regarding reporting requirements, training for event registration and issue resolution, coordinating all data transfers and reports and managing the database updates between Banner and QuadWrangle.
Assist in evaluation, implementation and on-going data synchronization of software used to support administrative systems - QuadWrangle, Reeher,
Collaborate with and assist the Director of Advancement Services in the development and enhancement of financial reports and dashboards (Access/Reeher/Quad) relating to capital campaign & annual giving, including weekly donor and revenue reports, phonathon donor reports and suppression lists, pledge partial payment audits, accrual vs. cash, event profiles, cost of funds, and various custom reports. Maintain and produce these reports as
Act as a liaison, in a professional and approachable manner, with various departmental representatives in a customer service oriented environment to refine information requests in order to meet end user requireme This will include assessing business and functional reporting requirements and also aid in managing user expectations in order to complete requests in a professional and timely manner.
Cross-train with other members of the department to obtain student data for Advancement use in segmenting and targeting constituencies (i.e. study abroad, student life activities, athletics, and legacy alumni)
Responsible for assisting the Director in managing the student workers and Graduate Assistants within the Advancement Services department including their project assignments to ensure that projects are completed in an efficient and effective
Perform other duties and projects as assigned
Bachelor's degree required (Business or Accounting related degree preferred or equivalent work experience in business, IT or fundraising field)
At least 3 years of experience that is directly related to the duties and responsibilities
Prior report writing and report generation experience necessary, as well as a demonstrated ability to select, insert, delete and update data stored in a relational database such as Oracle and
This position requires comfort and effectiveness translating between end users with varying degrees of technical ability and database output. Must be able to understand development and alumni officers' needs so as to accurately translate their requests into effective queries and reports. Skill in making presentations and training individuals in software applications is highly desirable.
Ability to organize and prioritize requests, take initiative, perform quality reviews, spot check audits and multi-task to meet deadlines in a fast paced time sensitive
Application programming experience in an Ellucian Banner ERP software environment (especially Advancement)
Application development experience using Adobe Developer Tools (flex, flash) Java, HTML, SQL Server, Cold Fusion, Pro-C, Evisions Argos, MS Excel and MS Access is
Technical expertise in database management, information systems and financial reporting query tools (specifically MS Access or other report writing and query tool experience, (i.e. Crystal reports, SAS, FOCUS, Oracle Developer, etc.)), used in generating financial, donor and prospect related reports and responding to ad hoc
Excellent project management skills
Highly proficient in the use of Microsoft Office including Outlook, Access, Word, Excel and
Basic knowledge of fundraising and philanthropy required. Prior Higher Education, fundraising or Not-for Profit experience a
Knowledge of SCT Banner ERP system or related ERP or fundraising system desirable.
Demonstrated ability to communicate effectively and collegially with colleagues is required, as well as, excellent verbal and written communication
Possess effective problem solving and organizational skills and have outstanding attention to
Possess an understanding for data integrity and security controls and perform sound judgment when dealing with highly confidential
Ability to complete assignments individually or participate as an effective member of a project team to complete various departmental
St. John's offers a competitive compensation program which is commensurate with your qualifications, experience, and contingent upon the departmental budget. We also offer an extremely comprehensive benefits program to meet the diverse needs of our workforce. Along with exceptional benefits such as medical, dental, life insurance, long term disability insurance, tuition remission, generous 403(b) employer contribution, employee assistance program, and liberal paid time off policies, faculty and staff can also enjoy St. John's performing arts, libraries, bookstores, dining facilities, campus recreation and sporting events.
Any offer of employment is subject to receipt by St. John's University of satisfactory references, verification of employment and education.
St. John's University is an Equal Opportunity Employer and encourages applications from women and minorities. All qualified applicants will receive consideration without regard to race, color, religion, sex, sexual orientation, gender identity, national or ethnic origin, age, status as an individual with a disability, protected veteran status, or any other characteristic protected by law.
St. John's University is Catholic, Vincentian and Metropolitan. We are committed to attracting, motivating, and retaining a highly qualified and diverse workforce to support our mission of academic excellence and the pursuit of wisdom. Known for over 100 years of proud athletic tradition, our Big East excitement keeps Red Storm fans cheering. Ranked among America's top universities by The Princeton Review, St. John's University educates leaders for today's global society through quality academics, high-tech resources and an expanding international presence. With 1,500 Faculty and 1,400 Administrators/Staff, St. John's is a leading Catholic University in the Vincentian tradition, dedicated to making a positive difference in people's lives through active engagement in issues of energy and resource conservation, social justice and global citizenship. These values enhance the academic experience of more than 20,000 undergraduate and graduate students on three residential New York City campuses in Queens, Staten Island and Manhattan; a graduate center in Oakdale, NY; an international campus in Paris, France and Rome, Italy; and learning centers in other locations worldwide.