Senior Institutional Research Analyst

Posted on6/25/2018
Job typeFull-time
Reports toThisie Schisler Do
Reports in officeCollege of Arts, Sciences, and Engineering Institutional Research Office
Application due dateRolling Applications Until Candidate Identified
Job start dateRolling Applications Until Candidate Identified
CityRochester
State/ProvinceNew York
InstitutionUniversity of Rochester
Institution descriptionThe University of Rochester is one of the country's top-tier research universities. Our campuses are home to 200 academic majors, more than 2,000 faculty and instructional staff, and some 10,000 students—approximately half of whom are women.

Learning at the University of Rochester is also on a very personal scale. Rochester remains one of the smallest and most collegiate among top research universities, with smaller classes, a low 10:1 student to teacher ratio, and increased interactions with faculty.
Job dutiesGeneral Responsibilities:
Performs research and complex data manipulation and analysis in support of AS&E initiatives. Interprets the results of research and analysis based on the needs of those requesting the information and/or the target audience. Collaborates with various constituencies including University IT programmers to design and refine data systems that will support ongoing reporting needs and research requirements. Develops high level standard reports and templates that serve as the foundation for both annual reports and ad hoc reports. Performs advanced statistical analysis and modelling.

Specific Responsibilities:

Data Warehouse Development (35%)
• Work with the University-IT data warehouse team to perform ongoing data warehouse testing and refinement to ensure data integrity. This includes comparing and reconciling the data warehouse (Cognos and Tableau) to mainframe and other critical data resources.
• Provide ongoing assessment of the data warehouse’s end-user functionality. Advise and recommend structural data warehouse improvements, enhancements and bug-fixes to the Director of Institutional Research.
• Develop detailed specifications for University-IT data warehouse programmers to ensure a clear understanding of end-user requirements.

Data Analysis and Reporting (25%)
• Combine and manipulate complex data sets using student, faculty and course section data from multiple data sources, perform statistical analysis of data, and interpret/organize results into meaningful reports for senior leadership and department heads.
• Develop rich data models to support the statistical analysis of student enrollment flows and trends as well as retention and graduation rates within a variety of cohort groups. Illustrate which variable or variables have the most significant impact on student outcomes and how adjusting inputs can affect results.
• Analysis and reporting examples include divisional flows, major flows, graduation and retention rates broken down by various sub-groups as well as credit hour and faculty load reporting.
• Work with faculty affairs officer to develop shared reports that track faculty headcounts and characteristics.

Cognos & Tableau Reporting (25%)
• Develop and enhance standard reports using the Cognos data warehouse, and Tableau to replace antiquated mainframe Natural and SAS reports. Work cooperatively with Provost’s IR and University IT programmers to ensure that results are verifiable and consistent with other data sources.
• Focus on developing standard reports and templates that can be run by end users and that reduce the need to “reinvent the wheel” for each reporting cycle.
• Prepare reports and analysis in support of other activities including, but not limited to, student major trends, credit hours analysis, and enrollment budget projections.

General Institutional Research (15%)
• Collects, analyzes, and reports SAT and ACT scores for IPEDS and US News reporting.
• Develop ad hoc reports for student service areas including Residential Life, Study Abroad, and Academic Advising. Create ad hoc reports using the data warehouse, FARS, Prospect-Plus, and other sources as requested.
• Prepare or participate in the preparation and presentation of formal research reports.
• Identifies external data sources and completes studies on peer schools including enrollment and graduation trends.
• Assist in the review of external surveys (U.S. News and World Report rankings) and data sources (U-CAN).
QualificationsBachelor’s degree required, Master’s degree strongly preferred. Educational background (and/or experience) emphasizing quantitative skills and research methods (e.g. Mathematics, Statistics, Social Science etc.); excellent analytical reasoning and problem solving skills; ability to compile, analyze and interpret data; ability to produce both descriptive and inferential statistical analyses; proficiency in a programmable statistical analysis software (Base SAS, SPSS syntax, STATA, etc.) experience using Cognos, Tableau or other data warehouse tools strongly preferred; demonstrated ability to use other software packages including FileMaker and Microsoft Office products; demonstrated understanding of relational data bases; ability to merge data from different sources; excellent interpersonal and verbal and written communication skills (ability to relay complex statistical results in an organized and easily understandable fashion); excellent organizational skills, attention to detail, as well as the ability to prioritize work and handle multiple tasks and deadlines; ability to work independently and as part of a team effort.
Salary range$40,000 - $60,000
Salary benefitsFor detailed information on Benefits for this position please visit our Benefits website.
Application procedureTo apply, please proceed to this website and search for Job ID #208494 in the search field.