Lead Institutional Research Analyst and Developer

Responsibilities

• Audit, clean, and maintain institutional data in People Soft, 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 People Soft, 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.

• 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:
• Query building (particularly in R, SQL, Python or similar coding languages)
• Data extraction from large enterprise systems
• 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.

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.

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.

Application Due Date:

Job

Start Date:

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