Lead Institutional Research Analyst and Developer
Application Procedure:
To apply please visit https://apptrkr.com/6687450
Job Duties
● 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.
● Evaluate utility, availability, accuracy and timelines of scheduled reports
● Lead the development of institutional analytics tools to meet campus needs, such as R Shiny
applications, Tableau dashboards, etc.
● Provide analysis of enrollment trends and forecasting for use in institutional budget
development.
● Create and implement testing protocols for critical reports, in systems such as PeopleSoft, to
ensure their reliability after software updates.
● Lead the production of Sound Reports, including creation, maintenance and posting.
● Extract, clean, and store data from external organizations such as the IPEDS for institutional
reporting.
● Complete and submit external data requests, including IPEDS, as well as other external
organizations, such as NCAA, Independent Colleges of Washington (ICW), bond agencies,
etc.
● Manage back-end technology for course evaluations
● 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.
● Other duties as assigned.
For full position responsibilities and description information, visit: https://apptrkr.com/6687450
● Extract student census data at specific times throughout the year, clean, ensure accuracy of that data, and maintain it in the data warehouse.
● Evaluate utility, availability, accuracy and timelines of scheduled reports
● Lead the development of institutional analytics tools to meet campus needs, such as R Shiny
applications, Tableau dashboards, etc.
● Provide analysis of enrollment trends and forecasting for use in institutional budget
development.
● Create and implement testing protocols for critical reports, in systems such as PeopleSoft, to
ensure their reliability after software updates.
● Lead the production of Sound Reports, including creation, maintenance and posting.
● Extract, clean, and store data from external organizations such as the IPEDS for institutional
reporting.
● Complete and submit external data requests, including IPEDS, as well as other external
organizations, such as NCAA, Independent Colleges of Washington (ICW), bond agencies,
etc.
● Manage back-end technology for course evaluations
● 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.
● Other duties as assigned.
For full position responsibilities and description information, visit: https://apptrkr.com/6687450
Job Qualifications
● Education level: a bachelor's degree; advanced degree preferred. Equivalent work experience acceptable.
● Years of experience: AT LEAST one year's experience in Institutional Research or equivalent data analysis role.
● Demonstrable skills in the following:
1. Query building (particularly in R, SQL, Python or similar coding languages)
2. Data extraction from large enterprise systems
3. Reporting capabilities to audiences with various technical and non-technical backgrounds ● Excellent communication (oral and written) and interpersonal skills, as evidenced through
samples of written reports, and performance on a job task.
● Years of experience: AT LEAST one year's experience in Institutional Research or equivalent data analysis role.
● Demonstrable skills in the following:
1. Query building (particularly in R, SQL, Python or similar coding languages)
2. Data extraction from large enterprise systems
3. Reporting capabilities to audiences with various technical and non-technical backgrounds ● Excellent communication (oral and written) and interpersonal skills, as evidenced through
samples of written reports, and performance on a job task.
Institution Description
We believe that a Puget Sound education isn't something you get, it's something you do. Our alumni continue to learn, to give, to engage, and to change the world. As individuals and as a community that spans generations, we have enormous impact. We pioneer, we influence, we take risks. We give back to each other, to Northwest, and the world. Our journey at Puget Sound continues long past graduation, and connects us in meaningful ways to both past and future generations.
Benefits
It is anticipated that the successful candidate will be hired between $28.60 - $30.70 per hour. The rate for an experienced employee in this role may go up to $35.60 per hour, and the starting salary will be based on experience level.
Puget Sound offers a generous benefits package for eligible staff employees.
Puget Sound offers a generous benefits package for eligible staff employees.
Application Due Date: 2025-12-30
Job Start Date: 2026-01-30
Salary: $28.6 - $30.7
City: Tacoma
State/Province/Region: WA
Institution: University of Puget Sound
Reports To: Director of Institutional Research
Staff # Reporting to Position: 1
Reports In Office: N/A
Search for openings in IR, effectiveness, assessment, planning, and related fields at higher education institutions in the U.S. and abroad.