Lead Institutional Research Analyst and Developer

University of Puget Sound • Tacoma, WA

57d • $29 - $36 • Onsite

About The Position

Reporting to the Director of Institutional Research, the Lead Institutional Research Analyst and Developer supports the collection and reporting of information about the University, and ensures accurate and timely reporting of data. In addition, they build applications to provide ready access to information about students, faculty and staff.

Requirements

• 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 labeling 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.
• 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.
• Ability to respectfully work, communicate and provide leadership within a diverse campus community

Nice To Haves

• Knowledge of the issues of higher education and university administration is preferred.

Responsibilities

• 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.
• Serve on the Data Governance Committee.
• Create graphs and tables to visualize data.
• Collect and maintain data from peer institutions for internal indicators and dashboards.
• Query data from University systems.
• 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.
• Represents the Office in the absence of the Director.
• Other duties as assigned.

Benefits

• Medical, dental, and vision
• Life insurance and long-term disability
• Employee Assistance Program
• Retirement plan options and 403(b) contributions
• Paid vacation, sick leave, floating holiday, campus holidays and bonus holidays
• Education benefits, such as full tuition for eligible employees and their families
• Access to university facilities and entertainment (fitness center, pool, library, concerts, lectures and more!)

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Industry: Educational Services
• Number of Employees: 501-1,000 employees