Job description

Description The Senior Data Analyst will actively engage in the process of turning raw data into useful information by developing and maintaining the core institutional data sets that support the work of the broader office and the Vice President of IR&A. Consideration will be given to candidates with advanced technical skills in data manipulation, excellent problem-solving skills, and demonstrated ability to communicate effectively and to work with others collaboratively. The successful analyst must be able to think strategically, develop creative solutions, process and manipulate institutional data, and, most importantly, help IR&A make meaning from these data. Duties • Design, create and manage complex data sets from multiple internal and external data sources. • Respond to internal and external requests for data, information, and analyses by preparing and submitting a variety of regular and ad hoc reports. • Produce novel analyses and prepare reports and / or presentations of analytical findings in narrative and visual formats. • Create efficient, repeatable processes to proactively respond to all ongoing and / or repeating requests for data, information, and analyses. • Define data constructs and create data governance and documentation standards. • Represent IR&A on university committees and task forces. • Other duties and responsibilities as assigned. Qualifications Bachelor Degree required, Master's degree preferred and 3 to 5 years of experience or equivalent combination of education and experience is required. Background and experience should emphasize data processing and quantitative research skills. (e.g., Computer Science, Statistics, Social Science, Mathematics, etc.) • Experience creating complex data sets from multiple internal and external data sources. • Demonstrated ability to use programming software to run queries, create scripts and transform data. (e.g. SQL, Base SAS, R, Python, etc.) • Demonstrated understanding of relational databases and data management. • Excellent analytical reasoning and problem-solving skills; ability to compile, analyze and interpret data. • Ability to convey complicated data and complex results as organized and easily understandable information. • Significant experience using descriptive statistics to clean and regularize data. • Experience with statistical programming language preferred. (e.g. SAS, R, SPSS syntax, STATA, etc.) • Experience with one or more data visualization software packages (e.g., Tableau, Microsoft BI, Qlik, etc.); Tableau preferred. • Demonstrated ability and desire to acquire new knowledge and skills independently. • Excellent organizational skills, including a keen orientation to detail and deadlines, as well as the ability to prioritize work and handle multiple tasks simultaneously. • Ability to handle confidential materials professionally and to utilize discretion in releasing confidential information. • Commitment to maintaining accurate and detailed records and documentation. • Experience working with the student or employee information systems (Banner and / or Workday especially helpful). Job Location - City, State Philadelphia, Pennsylvania Department / School President's Center Pay Range $74,476.00 - $100,000.00 Annual Rate Salary offers are made based on the candidate’s qualifications, experience, skills, and education as they directly relate to the requirements of the position, as well as internal and market factors and grade profile. 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. University Benefits Health, Life, and Flexible Spending Accounts : Penn offers comprehensive medical, prescription, behavioral health, dental, vision, and life insurance benefits to protect you and your family’s health and welfare. You can also use flexible spending accounts to pay for eligible health care and dependent care expenses with pre-tax dollars. Tuition : Take advantage of Penn's exceptional tuition benefits. You, your spouse, and your dependent children can get tuition assistance here at Penn. Your dependent children are also eligible for tuition assistance at other institutions. Retirement : Penn offers generous retirement plans to help you save for your future. Penn’s Basic, Matching, and Supplemental retirement plans allow you to save for retirement on a pre-tax or Roth basis. Choose from a wide variety of investment options through TIAA and Vanguard. Time Away from Work : Penn provides you with a substantial amount of time away from work during the course of the year. This allows you to relax, take vacations, attend to personal affairs, recover from illness or injury, spend time with family whatever your personal needs may be. Long-Term Care Insurance : In partnership with Genworth Financial, Penn offers faculty and staff (and your eligible family members) long-term care insurance to help you cover some of the costs of long-term care services received at home, in the community or in a nursing facility. If you apply when you’re newly hired, you won’t have to provide proof of good health or be subject to underwriting requirements. Eligible family members must always provide proof of good health and are subject to underwriting. Wellness and Work-life Resources : Penn is committed to supporting our faculty and staff as they balance the competing demands of work and personal life. That’s why we offer a wide variety of programs and resources to help you care for your health, your family, and your work-life balance. Professional and Personal Development : Penn provides an array of resources to help you advance yourself personally and professionally. University Resources : As a member of the Penn community, you have access to a wide range of University resources as well as cultural and recreational activities. Take advantage of the University’s libraries and athletic facilities, or visit our arboretum and art galleries. There’s always something going on at Penn, whether it’s a new exhibit at the Penn Museum, the latest music or theater presentation at the Annenberg Center, or the Penn Relays at Franklin Field to name just a few examples. As a member of the Penn community, you’re right in the middle of the excitement and you and your family can enjoy many of these activities for free. Discounts and Special Services : From arts and entertainment to transportation and mortgages, you'll find great deals for University faculty and staff. Not only do Penn arts and cultural centers and museums offer free and discounted admission and memberships to faculty and staff. You can also enjoy substantial savings on other goods and services such as new cars from Ford and General Motors, cellular phone service plans, movie tickets, and admission to theme parks. Flexible Work Hours : Flexible work options offer creative approaches for completing work while promoting balance between work and personal commitments. These approaches involve use of non-traditional work hours, locations, and / or job structures. Penn Home Ownership Services : Penn offers a forgivable loan for eligible employees interested in buying a home or currently residing in West Philadelphia, which can be used for closing costs or home improvements. Adoption Assistance : Penn will reimburse eligible employees on qualified expenses in connection with the legal adoption of an eligible child, such as travel or court fees, for up to two adoptions in your household. Last updated : 2024-10-07

Requirements