Posting Details

Posting Details

Reference Number 90-26972
School Name Development and Alumni Relations
Org Reports
Posted to the Web 09/27/2017
Posted Job/Salary Grade B
Employment Type Exempt
Hours N/A
Position Type Full Time
Position Schedule N/A
Months 12
Position Length Ongoing
Position End Date
University Overview

The University of Pennsylvania, the largest private employer in Philadelphia, is a world-renowned leader in education, research, and innovation. This historic, Ivy League school consistently ranks among the top 10 universities in the annual U.S. News & World Report survey. Penn has 12 highly-regarded schools that provide opportunities for undergraduate, graduate and continuing education, all influenced by Penn’s distinctive interdisciplinary approach to scholarship and learning.

Penn offers a unique working environment within the city of Philadelphia. The University is situated on a beautiful urban campus, with easy access to a range of educational, cultural, and recreational activities. With its historical significance and landmarks, lively cultural offerings, and wide variety of atmospheres, Philadelphia is the perfect place to call home for work and play.

The University offers a competitive benefits package that includes excellent healthcare and tuition benefits for employees and their families, generous retirement benefits, a wide variety of professional development opportunities, supportive work and family benefits, a wealth of health and wellness programs and resources, and much more.

School/Center Overview

The Development and Alumni Relations organization at the University of Pennsylvania is one of the premier development organizations in the world.

Penn’s Development and Alumni Relations (DAR) team members benefit from an exceptional work environment where professional excellence and individual pride in achievement are grounded in a strong institutional commitment to integrity and collegiality as we strive for collective success. For talented and innovative individuals, a career at the University of Pennsylvania offers the chance to be part of an exceptionally exciting environment at the nation’s first university.

We seek talented individuals who will constitute a community that draws on the strength that comes with a substantive institutional commitment to diversity. Diversity is prized at Penn as a central component of our mission and helps create an educational and working environment that best supports the University’s commitment to excellence in teaching, research, and scholarship.

Penn’s commitment to achieving eminence through diversity is ultimately a commitment to creating a more vibrant university so that our employees will be both stimulated and empowered to shape a better world. http://darrecruiting.upenn.edu/why-choose-penn/about-dar


The Junior Data Analyst position is responsible for producing complex reports and data analysis tools based on multiple data sources to serve the business needs of the Development and Alumni Relations staff. A familiarity with database reporting structures and query tools is a requirement. A demonstrable familiarity with Advancement database systems or complex relational databases is strongly recommended. This position reports directly to the Director of Reports and Analytics. This is an early career programming position.

Specific Responsibilities

* Delivers system solutions involving advancement software systems, data visualization and query tools ATLAS, QlikView, Business Objects, SQL and other systems, to users.

* Designs, codes, simulates, tests, implements and maintains reporting solutions and associated middleware, interfaces and databases in highly complex solutions.

* Analyzes functional requirements and advises DAR users in the planning, selection, implementation and use of solutions to address business requirements.

* Ensures adherence to technical, quality assurance, data integrity, and security standards.


A Bachelor’s Degree and 1 year to 2 years of experience with a focus in Information Technology, Data Science, Computer Science or the professional equivalent is a requirement. A demonstrated familiarity with data analysis tools and query languages (Crystal Reports, Business Objects and SQL), data programming, mining and modeling languages (R, Python) and data visualization tools (Tableau, QlikView) or similar tools is required. Familiarity with complex relational databases, fundraising information systems and fundraising business practices is strongly recommended.

Affirmative Action Statement

Penn adheres to a policy that prohibits discrimination on the basis of race, color, sex, sexual orientation, gender identity, religion, creed, national or ethnic origin, citizenship status, age, disability, veteran status, or any other legally protected class.

Special Requirements Background check required after a conditional job offer is made. Consideration of the background check will be tailored to the requirements of the job.
Quick Link http://jobs.hr.upenn.edu/postings/31600

Posting Supplemental Questions

Required fields are indicated with an asterisk (*).

  1. * How did you hear about this employment opportunity?
    • Jobs@Penn
    • Contacted by a Penn Recruiter
    • Referred by a Penn Employee
    • Referred by a friend or family member
    • Higher Education Recruitment Consortium (HERC)
    • Inside Higher Ed
    • Indeed.com
    • Other Internet Advertisement
    • Linkedin
    • Twitter
    • Other Social Media Site
    • Professional Affiliation/Trade Website
    • Diversity Association/Publication Website
    • Heard about it at a conference or career fair
    • Apple One
    • Recruitment and/or staffing agency
  2. * What is your highest level of education completed?
    • Less than high school education
    • High School Diploma or GED
    • Vocational or Technical School
    • Associate's Degree or Two Year College
    • Bachelor's Degree
    • Master's Degree
    • PHD/MD/JD or equivalent doctoral degree
  3. * How many years of experience do you have related to this position?
    • 0 to 1 Year
    • 1 to 2 Years
    • 2 to 3 Years
    • 3 to 5 Years
    • 5 to 7 Years
    • 7 to 10 Years
    • Over 10 Years
  4. * Are you familiar with complex relational databases, fundraising information systems, and fundraising business practices?
    • Yes
    • No
  5. * Do you posses a demonstrated familiarity with query languages like Crystal Reports, Business Objects, and SQL?
    • Yes
    • No
  6. * Are you familiar with modeling languages such as R and Python?
    • Yes
    • No
  7. * Are you familiar with data visualization tools like Tableau and QlikView?
    • Yes
    • No

Applicant Documents

Required Documents
  1. Cover Letter
  2. Resume
Optional Documents