Skip to Main Content

Business Analyst

Below you will find the details for the position including any supplementary documentation and questions you should review before applying for the opening.  To apply for the position, please click the Apply for this Job link/button.

If you would like to bookmark this position for later review, click on the Bookmark link. If you would like to print a copy of this position for your records, click on the Print Preview link.

Please see Special Instructions for more details.

All applications must be submitted online at Saint Joseph’s University is a private, Catholic, Jesuit institution and expects members of its community to be knowledgeable about its mission and to make a positive contribution to that mission. Saint Joseph’s University is an equal opportunity employer that seeks to recruit, develop and retain a talented and diverse workforce. EOE M/F/V/D

Position Information

Position Information (Default Section)

Position Title: Business Analyst
Open to: Internal and External Applicants
Full-Time or Part-Time Status: Full-Time, 12 months
If Part-Time, hours per week:
If temporary, please provide a start and end date:
Staff Job Type: Salaried/Exempt
Position Summary or Faculty Qualifications

The Business Analyst works as part of a team responsible for the management, knowledge and reporting of over 100,000 alumni, donor, and constituent records.

The incumbent will support the University Advancement Division as well as the University community by providing accurate lists, statistical reporting, and financial reporting.

The candidate will also be involved supporting specific data loads into our enterprise system, monitoring the updates to external systems, and managing security requests for external systems.

Essential attributes to achieve success at this position are a keen sense of detail, good communication skills, diligent data stewardship and the ability to handle multiple requests.

Duties and Responsibilities:

• Serves as the primary provider of ad-hoc reports for advancement staff as well as other academic and administrative offices on campus. Must maintain a high degree of accuracy, delivery in a timely manner, and continual emphasis on information disclosure policies.
• Responsible for monitoring data standards, security and integrity of alumni, donor and constituent records.
• Act as an advisor for staff responsible for maintaining and enhancing the highly confidential data of the alumni and donors on the university’s Banner Advancement System.
• Act as lead analyst and data steward in the department’s external systems (e.g. iModules) overseeing the systems security, defect tracking, upgrade notices and data integrity. Make recommendations for improvement of processes related to the system itself or its integration with the central Banner system.
• Coordinate and manage the upload and transfer of information from external systems into Banner Advancement using custom data loader as it pertains to appeals, emails and outreach activities for tracking and reporting purposes.
• Responsible for assisting the with the identification, design and implementation of improvements to all Advancement information systems and business processes as they relate to the Banner Advancement System and other division’s external systems.
• Data integrity is essential to the success of University Advancement activities and the incumbent will need to work with Advancement Records & Gift Services to develop strategies to constantly improve the integrity of the data in systems. This will include the development of reports and statistics to monitor data integrity, database changes, address accuracy and interrelationships of data.
• Work to further develop self-service reporting and dashboards for the division via Cognos reporting tool.
• Collaborate and assist with the development, design and set-up of automated processes to provide for mass data integrity updates.

Secondary Responsibilities:

• Responsible for troubleshooting Banner Advancement related issues, typically partnering with IT.
• Serve as backup in supporting Banner Advancement upgrades, defect resolutions and developing testing protocols.
• Assist in identifying and develop projects that are division-wide or at times inter-departmental in scope, in an effort to advance the level of service provided to university staff, donors, friends and alumni.
• Serve as a backup for editing and updating external systems (e.g. iModules) informational pages updates as well as coordinate mailing of electronic communications to the constituent base.
• Acts as an associate project manager for Advancement Services in relation to Information System projects and improvements.
• Liaison with Information Technology Help Desk area.
• Support the division with first level technical support, including the installation of software, hardware and any technical needs. Recommend improvements or upgrades when needed.
• Perform information system testing in relation to projects or system upgrades.
• Audit and track all hardware, software and systems used within the Division.

Physical Requirements and/or Unusual Work Hours:
Minimum Requirements:

• An undergraduate college degree from an accredited, four-year institution.
• 3-5 years of closely related experience in the advancement and/or analytic reporting or technology field.
• Specific professional work experience dealing with large complex data sets and migrating data records.
• Solid understanding of Oracle DBMS and use of SQL.
• Experience with developing reports in a robust reporting tool like Cognos
• Mastery of Microsoft Office including Excel, Word, Access and Outlook.

Preferred Qualifications:

• Previous professional experience in an advancement department or non-profit organization.
• Previous experience with Banner Advancement and/or Cognos
• Previous experience working with end users on gathering requirements for information needs

Additional Information:
Position Classification: Professional
Union: None
Number of direct reports to this position: 0
Department: 514000 - Advancement Services
Band: 14
Date Open to Internal Applicants: 06/22/2017
Date Open to External Applicants: 09/13/2017
Job Close Date:
Open Until Filled Yes
Special Instructions:

All applications must be submitted online at
Saint Joseph’s University is a private, Catholic, Jesuit institution and expects members of its community to be knowledgeable about its mission and to make a positive contribution to that mission. Saint Joseph’s University is an equal opportunity employer that seeks to recruit, develop and retain a talented and diverse workforce. EOE M/F/V/D

Supplemental Questions

Required fields are indicated with an asterisk (*).

  1. What is the highest level of education you possess?
    • Bachelor's Degree
    • Master's Degree
    • ABD
    • Doctoral Degree
  2. Of your years of professional experience listed above, how many are in Educational Development/Advancement or a non-profit organization?
    • None
    • 1-3 years
    • 4-6 years
    • 7-10 years
    • More than 10 years
  3. How many years of Oracle Database or PL/SQL experience do you have?
    • No Response
    • No experience
    • Up to 2 years
    • 2 to 4 years
    • 4 years or more
  4. Do you have previous experience using the Advancement module in Banner?
    • Yes
    • No
  5. * Please indicate how you FIRST learned of this position
    • Internal Job Announcement
    • Periodic search of the SJU website
    • Employee Referral (Specify name of employee below)
    • On-line Advertisement (Please specify source below)
    • Social Media (Please specify venue below)
    • Email Announcement (Please specify listserv or other source below)
    • Print Advertisement (Please specify source below)
    • Networking Event or Conference (Please specify event name and date below)
    • Job Fair (Please specify event name and date below)
    • Other (Please specify below)
  6. * Per the question above, please specify the name of the venue or place where you FIRST learned of this position.

    (Open Ended Question)

Required Documents

Required Documents
  1. Cover Letter/Letter of Interest
  2. Resume/Curriculum Vitae
Optional Documents