Apply on Institution's Website:
Application Deadline: Review of application materials will begin immediately. Search and selection procedures will be closed when a sufficient number of qualified candidates have been identified.
- Letter of Interest
Applications submitted without the required attachments will not be considered.
All offers of employment are contingent on successful completion of all required background checks. All new hires will be required to submit proof of current COVID-19 vaccination (including booster) or receive an approved medical or religious exemption from the university.
Please note that we generally do not sponsor applicants for work visa for staff positions. Therefore, we generally require applicants for staff positions to be currently authorized to work in the United States on a full-time basis.
- We acknowledge the richness of commonalities and differences we share as a university community; the intrinsic worth of all who work and study here; that education is enhanced by investigation of and reflection upon multiple perspectives.
- We aspire to create respect for and appreciation of all persons as a key characteristic of our campus community; to increase the diversity of all parts of our University community through commitment to diversity in our recruitment and retention efforts; to foster a spirit of openness to active engagement among all members of our campus community.
- We act to achieve an environment that welcomes and supports diversity; to ensure full educational opportunity for all who teach and learn here; to prepare effectively citizen-leaders for a pluralistic world.
Puget Sound is committed to an environment that welcomes and supports diversity. We seek diversity of identity, thought, perspective, and background in our students, faculty, and staff. To learn more please visit: https://pugetsound.edu/about-puget-sound-0/mission-core-values/institutional-equity-diversity
The University of Puget Sound is an equal opportunity employer.
The University of Puget Sound is looking for a creative, curious and technically savvy Analyst to join our team in the Office of Institutional Research. Do you like to juggle more than one project at once? Do you embrace both finding creative ways to improve processes, and preforming with quality in routine tasks? If so, we’d love to receive your application. We are looking for someone who will have who has 2 to 5 years of experience collecting, cleaning, and analyzing data, ideally in a higher education setting.
Reporting to the Associate Director, Institutional Research and Assessment, the Institutional Research Analyst supports the collection and reporting of information about the University, and ensures accurate and timely reporting of data. In addition, the Analyst supports assessment efforts and institutional research communications.
Essential Job Functions and Responsibilities:
Under the general supervision of the Associate Director, Institutional Research and Assessment the responsibilities of the position include:
- Audit, clean, and maintain institutional data in PeopleSoft, and its storage in the Snowflake Data Warehouse, including writing query code (SQL), for the extract-load-transform (ETL) processes, testing results and identifying and correcting errors.
- Extract student census data at specific times throughout the year, clean, ensure accuracy of that data, and maintain it in the data warehouse.
- Create and implement testing protocols for critical reports, in systems such as PeopleSoft, to ensure their reliability after software updates.
- Create and maintain recurrent institutional reporting, including but not limited to Sound Reports and the Institutional Dashboard.
- Extract, clean, and store data from external organizations such as the IPEDS and National Student Clearinghouse for institutional outcomes reporting.
- Complete and submit external data requests, including IPEDS, as well as other external organizations, such as NCAA, the Higher Education Data Sharing Consortium (HEDS), Independent Colleges of Washington (ICW), bond agencies, etc.
- Coordinate and submit responses to guidebooks (Princeton Review, US News, Fiske, etc.)
- Compile and manage faculty and staff data and respond to AAUP, CUPA, and other requests for employee data.
- Providing internal and national quantitative data and analysis to departments and offices for use in assessment.
- Update and maintain recurrent predictive analytics, including enrollment trends using statistics and programming.
- Respond to ad hoc internal and external requests for data and reports.
- Clean and analyze data from national and homegrown student, faculty and staff surveys.
- Create graphs and tables to visualize data.
- Collect and maintain data from peer institutions for internal indicators and dashboards.
- Query data from University systems.
- Support logistics for focus groups, and serve as notetaker for focus groups.
- Represent the department within the campus community on committees or workgroups related to the role as a steward for institutional data.
- Represent the University within the Institutional Research professional community and pursue professional development opportunities outside of Puget Sound.
- Participate in the success of the Office of Institutional Research in meeting its goals.
Knowledge, Skills, and Abilities:
- Ability to manage external reporting on behalf of the University independently with accuracy and attention to reporting implications.
- Ability to clarify and respond to data requests to meet end users’ needs.
- Ability to extract data from national and local sources using PS Query, Excel, Qualtrics, and web functions including:
- Querying data from the Snowflake data warehouse in SQL,
- Writing and editing existing queries in PS Query,
- Importing data from national databases into Excel,
- Retrieving data from Qualtrics or equivalent survey software.
- Ability to manipulate, analyze, summarize, and present quantitative data in multiple ways for a variety of audiences using:
- Excel (minimum knowledge includes pivot tables, Vlookup, and macros),
- RStudio or similar statistical software program (minimum knowledge includes importing datasets, cleaning and labelling data, and descriptive statistics),
- PowerPoint (importing graphs and tables for effective communication of data as information),
- Microsoft Word (to write reports, including importing graphs, tables, and images).
- Ability to develop and administer surveys, preferably through the use of Qualtrics survey software, including the ability to import contact lists, employ survey logic, craft survey questions collaboratively, manage survey messaging and the use of an API with our student portal.
- Ability to collaborate with colleagues and to work well with faculty, staff, and students across the institution to identify and act on areas for improvement within the purview of Institutional Research.
- Ability to manage projects, both new and recurring, with clear planning, documentation, attention to detail, and accuracy.
- Ability to efficiently manage the production of multiple, time-critical projects.
- Knowledge of the issues of higher education and university administration is preferred.
- Ability to work, communicate, and provide leadership respectfully within a diverse campus community.
- Education level: a bachelor’s degree; advanced degree preferred. Equivalent work experience acceptable.
- Years of experience: three to five years’ experience in Institutional Research or equivalent data analysis role.
- Excellent communication (oral and written) and interpersonal skills, as evidenced through samples of written reports, and performance on a job task.
Compensation and Benefits: The anticipated budget for this position is $58,580 DOE. Decisions about starting salaries are made based on the extent and relatedness of the candidate's education and experience and on internal equity and market considerations.
Puget Sound offers a generous benefits package. For more information, visit: https://pugetsound.edu/human-resources/benefits