Job Information

CUNY Institutional Research Specialist - Macaulay Honors College in New York, New York

Job Title: Institutional Research Specialist - Macaulay Honors College

Job ID: 20356

Location: Graduate Center

Regular/Temporary: Regular


In collaboration with eight of CUNY’s senior campuses, Macaulay Honors College (MHC) provides the most promising undergraduate students with an elite academic program of interdisciplinary seminars, personalized advisement, and experiential learning supported by dedicated funding for study abroad, internships, and research. With an entering class of approximately 550 students distributed on campuses across the five boroughs of New York City, Macaulay’s student body embraces the diversity of New York and represents the best and brightest of our next generation of leaders.

The Macaulay Honors College Office of Institutional Effectiveness seeks a motivated Institutional Research Specialist to work in a dynamic and challenging environment. The Research Specialist will report to the Director of Institutional Effectiveness and will play a pivotal role in assisting the Director of Institutional Effectiveness with internal and external reporting, academic, administrative and educational and student support.

Duties include but are not limited to:

  • Oversees the maintenance and design of a complex database system for Institutional Effectiveness, Academic Affairs and Student Services.

  • Maintains institutional data on students from eight (8) campuses in various formats.

  • Selects the strategies for updating and refreshing a complex database.

  • Administers large complex data sets, including exporting and importing data from various sources.

  • Runs queries and creates reports from database using TOAD, PS Query, PLSQL developer or similar tool.

  • Synthesizes information and disseminates results by producing informative reports, tables, presentations, and visualizations (e.g., charts, maps, and infographics).

  • Develops a dashboard application for administrative reporting and planning.

  • Posts or administers on-line forms or applications to collect data.

  • Provides support to Academic Affairs and Student Services for student co-curricular activities tracking.

  • Responsible for the maintenance, management and updating of the Macaulay Honors College student information.

  • May consult with staff and students in the design of databases for research projects.


Bachelor's Degree and four years' relevant experience required.

A preferred candidate should have:

  • Bachelor's degree in Information Systems, Statistics or a related field.

  • Four years of progressively responsible database management experience.

  • Experience developing data reporting systems.

  • Experience providing written reports.

  • Knowledge of SOL, VBA, Oracle, PL/SQL and other applicable programming languages.

  • Knowledge of Excel, SPSS, SAS, STAT or R.

  • Demonstrated ability to effectively and efficiently work with large volumes of complex data.

  • Knowledge of relational databases.

  • Knowledge of PeopleSoft systems.

  • Knowledge of web-site development using HTML, CSS, and JavaScript .

  • Knowledge of Oracle's Application Express (APEX).

  • Understanding of higher education and a commitment to data driven decision making and planning.

  • Strong critical thinking, organizational, and planning abilities and a desire to foster and thrive in a team environment that promotes efficiency, innovations, and best practices.

  • Excellent written and verbal communication skills to convey technical information to non-technical audiences.


Oversees collection and assessment of data for Institutional Research purposes.

  • Compiles, maintains, and analyzes institutional data in various formats

  • Produces reports and metrics based on department's needs; responds to time-critical ad-hoc requests

  • Loads, extracts, edits, and evaluates data for reporting and analytics

  • Maintains selected databases and document libraries, updating and ensuring data quality and accuracy

  • May participate in internal and external surveys as needed

  • May consult with others in designing methodology for research projects

  • Performs related duties as assigned.


Higher Education Assistant




Salary commensurate with education and experience.

CUNY's benefits contribute significantly to total compensation, supporting health and wellness, financial well-being, and professional development. We offer a range of health plans, competitive retirement/pension benefits and savings plans, tuition waivers for CUNY graduate study and generous paid time off. Our staff also benefits from the extensive academic, arts, and athletic programs on our campuses and the opportunity to participate in a lively, diverse academic community in one of the greatest cities in the world.


Click on "Apply Now" below which will bring you to the registration screen. If you are a new user, you must register to apply. If you already have a user ID, please use your existing ID to apply. Make sure to upload a cover letter, resume, and contact information for three (3) professional references (name, title, organization, phone number, and email). Please upload all documents in Word or PDF format as one file.


May 2, 2019


CUNY Job Posting: Managerial/Professional


CUNY encourages people with disabilities, minorities, veterans and women to apply. At CUNY, Italian Americans are also included among our protected groups. Applicants and employees will not be discriminated against on the basis of any legally protected category, including sexual orientation or gender identity. EEO/AA/Vet/Disability Employer.