OFFICIAL JOB TITLE: Institutional Research Analyst
DIVISION: Academic Affairs
DEPARTMENT: Institutional Research and Assessment
BARGAINING UNIT STATUS: ESU, Cat 12
EEO STATUS: 3.1
JOB CODE: 122
FLSA STATUS: Exempt
REPORTS TO: Director of Institutional Research
MINIMUM STARTING SALARY: $ https://www.umassd.edu/hr/policies-and-laws/union-contracts/
SUMMARY PURPOSE OF POSITION: Supports institutional research functions in data extraction, interpretation, and presentation and by helping implement a variety of data inquiries and information collection activities. Extracts data from complex files and systems including the campus enterprise system (across its functional areas including students, human resources, finances, and other system areas) and Institutional Research and UMass databases. Translates extracted data into other data structures for specific reports (such as the HEIRS data system for reporting unit data to the Massachusetts Department of Higher Education). Applies expertise in data interpretation ensuring consistent and auditable results and interacts with campus staff and representatives of external organizations to validate existing data, obtain new data, and support information and data needs. Reports data extraction and inquiry results in a variety of complex formats, including in-house publications and reports, ad-hoc reports or inquiries, and external surveys or other external data reports that can be at the federal or state levels. Create and maintain reports in Oracle OBIEE/Answers and Tableau Visualizations utilized by academic deans, department directors, and other administrators and staff. Performs other related duties as assigned.
Follows the University’s best practices to build and/or support student academic success and retention, and assist in meeting strategic objectives for persistence and timely graduation of all the student population.
EXAMPLES OF PRIMARY DUTIES AND RESPONSIBILITIES:
- Extracts data from complex files and systems including the campus enterprise system and creates and maintains SPSS databases and dictionaries.
- Extracts, analyzes and tracks trends on key performance metrics related to enrollment, retention, and degree persistence at the college and program levels.
- Translates extracted data into other data structures for specific reports, such as those for the comprehensive HEIRS data system for reporting unit data to the Massachusetts Department of Higher Education, and routine office and critical benchmarking projects.
- Applies expertise in data interpretation using the enterprise information system (PeopleSoft) and IR/UMass databases, ensuring consistent and auditable results across the functional areas of the enterprise system (including students, human resources, finances, and other system areas). Interpretation includes accurate application of data definitions/look-up tables and the application of subtotals, percentages, averages, percentiles, and similar functions.
- Interacts with campus staff, administrators and representatives of external organizations to validate existing data and obtain new data and supports information and data needs for other campus units as assigned.
- Reports data extraction and inquiry results in a variety of complex formats, including in-house publications and reports, ad-hoc reports or inquiries, and external surveys such as US News and Petersons, and other external data reports that can be at the federal or state levels.
- Assist with providing training for the SUMMIT dashboard and reporting system to university staff and faculty.
- Report Writer for PeopleSoft Student Administration in OBIEE and Answers.
- Create and maintain Tableau Visualizations utilized by academic deans, department directors, and other administrators and staff.
- Performs other related duties as assigned.
EDUCATION: Bachelor's degree.
EXPERIENCE: Demonstrated (over 3 years) experience in computer programming, data extraction, and reporting with previous experience in a college/university or other institutional setting performing management reporting and analysis.
OTHER: May need to be available for evening/weekends hours as needed; some travel to off-campus locations required.
KNOWLEDGE, SKILLS AND ABILITIES REQUIRED:
- Ability to learn data values and interrelationships in a comprehensive enterprise information system and apply them in a range of specific contexts and reports.
- Demonstrated database and reporting skills including SQL queries, OBIEE/Answers, Tableau or related reporting tools, and SPSS and/or Excel to perform analyses and generate reports.
- Ability to provide professional-level accuracy and precision of interpretation of complex sets of data.
- Able to manage multiple competing priorities and projects.
- Knowledge of basic statistical applications.
- Experience in a higher education setting enterprise system reporting and analysis.
- Experience in using the PeopleSoft enterprise information system and the OBIEE/Answers Dashboard/Report Writing tool.
- Experience with Tableau Visualizations
- Experience working in a data warehouse environment.
Applicants must be authorized for employment in the U.S. on a full-time basis. Employment-based visa sponsorship not available.
SPECIAL INSTRUCTIONS TO APPLICANT:
To apply please submit a letter of interest, current resume and the contact information for three professional references.
The deadline for internals to apply is November 27, 2019.
The review of applications will begin November 28, 2019 and will continue until the position is filled.