DATA ANALYST

Posting Details

Posting Details

Reference Number 62-27540
Posted Job Title DATA ANALYST
School Name Penn Global
Org International Student and Scholar Services
Posted to the Web 12/06/2017
Posted Job/Salary Grade C
Employment Type Exempt
Hours N/A
Position Type Full Time
Position Schedule 9am - 5pm
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

Penn Global provides strategic direction for Penn’s global endeavors with a focus on efficient investment of university resources for global activities. Penn Global collaborates with Schools and Centers across the University and seeks to catalyze cross-school collaborations to integrate knowledge that addresses key issues. We partner with leaders from Penn and around the world to develop innovative interdisciplinary global strategies, initiatives and programs. In addition, Penn Global provides important services in support of University endeavors, including academic year study abroad, immigration services for international students and operational, compliance support for international projects and Perry World House. http://global.upenn.edu/

Duties

The Data Analyst at ISSS is responsible for the accuracy of all data in iPenn and SEVIS, to ensure a high level of data integrity and compliance, which includes data management, quality control, data cleanup, data integration, data analysis, and data matching with other Penn systems. This also includes analysis of automatic and manual processes that deliver data to identify issues and feasible improvements. Monitor alerts within SEVIS database or iPenn system, contact ISSS clients or correct the errors at the system level and distribute follow-up tasks to ISSS staff. Configure templates and automated workflows to handle varying possible combinations of incoming data. Move rule-based processing into automated workflows, in order to allow more ISSS staff time to be spent on more nuanced immigration issues. Analyze SEVIS reportable data from iPenn, Penn student records, and Penn HR records to identify and remediate gaps in reporting. Monitor and address batch errors to identify feasible process changes to reduce batch errors proactively and correct data integrity alerts within iPenn. Collaborate with ISSS team to identify the error cause and appropriate process adjustments to eliminate the issues. Generate fee processing reports to support internal fee charging processes, and support internal verification to ensure that fee revenue is properly received for all relevant ISSS processes. Generate routine and ad hoc reports to meet ISSS business needs and requirements from Penn community. Create and manage ISSS connection to Penn’s QlikView system and/or other data analysis software in order to present ISSS data to stakeholders in a more interactive format. Generate diagrams that illustrate the flow of specific data points among different systems and identify process points that cause problems and propose alternatives. Liaise with other central Penn units that handle international student/scholar/faculty processes, including student records/NGSS project and HR records/HCM project. The Data Analyst is responsible for clarifying existing processes and gaps, as well as matching existing data to propose and validate the potential of future process improvements.

Qualifications

Bachelor’s degree and a minimum of two years of data analyst experience or an equivalent combination of education and experience. Proficiency with databases and relational database design; advanced technical skills with SQL and Excel; excellent organizational, analytical, and problem solving skills; excellent oral and written communication skills; the ability to learn and work independently in a collaborative environment, apply new technologies and business rules quickly, and problem solving to propose technical solutions for reducing data/system redundancy and ensuring data integrity. U.S. Citizenship or legal permanent residency status as required by federal regulations.
DESIRED: Experience with database management and ColdFusion strongly desired; hands on experience with data visualization strongly desired. Demonstrated knowledge with SEVIS in F and J or employment based petition requirements; DSO/ARO, SEVIS and Sunapsis system experience; and cross-cultural or multi-cultural experience.

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
Quick Link http://jobs.hr.upenn.edu/postings/33317

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

Applicant Documents

Required Documents
  1. Resume
Optional Documents
  1. Cover Letter