Data Analyst

Philadelphia, PA, United States

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. As an employer Penn has been ranked nationally on many occasions with the most recent award from Forbes who named Penn one of America’s Best Large Employers in 2023.

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.

Posted Job Title

Data Analyst

Job Profile Title

Data Analyst C

Job Description Summary

Information Systems & Computing (ISC) is the University of Pennsylvania’s central IT organization, providing the core network, data, voice, video, and enterprise application infrastructure and services upon which Penn’s numerous Schools and Centers build their unique tools and capabilities.

ISC’s 270-plus employees work closely with the University’s IT organizations in order to create, deliver and support products and services that help Schools and Centers operate efficiently and effectively. We strive to be easy to work with, and to serve as a trusted advisor to Penn’s IT community, faculty, staff and students in support of an environment of discovery and progress.

ISC’s focus on customer service and the high-quality, cost-effective, reliable implementation of modern IT solutions advances the mission of the University, as well as that of each individual School and Center. At Penn, technological freedom and departmental autonomy represent dearly held core values. ISC supports those ideas by providing foundational services and cogent counsel, empowering individuals and departments to employ their distinct strengths in support of their goals.

Learn more about us by visiting https://www.isc.upenn.edu/about or www.linkedin.com/company/penn-information-systems-computing/.

Application and Information Services (AIS), a unit within Information Systems and Computing (ISC), works with University clients to plan, acquire, develop, and maintain the University’s core business and student support systems. AIS is seeking a Data Analyst to join the Enterprise Information & Analytics team.

Job Description

Job Responsibilities

Interact closely with clients and ISC colleagues to deliver quality solutions to complex business opportunities and problems involving administrative processes and data.

Support clients and ISC colleagues in the correct and appropriate use of data management and reporting technologies to support information needs.

Support and participate in administration of analytics tools.

Participate in planning and implementation of data extraction, transformation and load processes for data warehousing efforts.

Participate in data modeling, physical design and quality assurance activities with project teams.

Support data warehousing and business application implementation efforts; may include participation in data conversions for new application systems.

Create and maintain documentation (e.g., requirements documents, data documentation, analytics tools support aids).

Participate in development of training materials and assist in facilitation of training sessions for clients and ISC colleagues.

Support the implementation of policies, procedures and standards..

Qualifications

Bachelor of Science and 2 to 3 years of experience delivering data warehousing and/or business system solutions in a large university or similar complex organization or equivalent combination of education and experience is required.

Experience with the following classifications of technologies is required: Business Intelligence/Reporting Tools (i.e., BusinessObjects, Crystal Reports, Power BI, Qlik, Toad); Database and ETL (i.e., Snowflake, Oracle, MS Access, Talend); Productivity (i.e., MS Word, MS Excel, MS PowerPoint).

Experience with the following classifications of technologies is desired: Data Modeling, ETL, Web Development. Experience with Dashboard Design, Data Mining, Predictive Analysis and Performance Management is a plus.

Must be self-motivated with a proactive approach to completing work assignments and able to work effectively on multiple concurrent assignments.

Proven analytic skills and applied knowledge of how organizations use information to aid decision making.

Experience on project teams with the demonstrated ability to plan, estimate and deliver work on a schedule.

Strong written and excellent verbal communication skills; adept at developing and delivering oral presentations appropriate for audience.

Ability to listen and assimilate information provided by others; good influencing skills and ability to reach consensus with clients and peers.

Job Location - City, State

Philadelphia, Pennsylvania

Department / School

Information Systems and Computing

Pay Range

$51,824.00 - $85,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.

To learn more, please visit: https://www.hr.upenn.edu/PennHR/benefits-pay

#J-18808-Ljbffr