Program Analyst, Evaluation and Reporting
Organization: CUNY School of Professional Studies
Functional Title: Program Analyst, Evaluation and Reporting
Salary Range: $40/hour
Hours: 20 hours/week, between 9am and 5pm
Program: Office of Professional Education and Workplace Learning
About the CUNY School of Professional Studies:
The CUNY School of Professional Studies (CUNY SPS) provides online and on campus degree and certificate programs that meet the needs of adults who are looking to finish or transition into a bachelor’s degree, earn a master’s degree or certificate in a specialized field, advance in the workplace, or change careers.
Home to the first fully online degree programs at the City University of New York, CUNY SPS offers fully accredited degree and certificate programs for students who want the flexibility and convenience of online education. CUNY SPS was ranked in the top 5% in the Nation in U.S. News & World Report’s list of the 2020 Best Online Bachelor’s Degree Programs.
Drawing on CUNY's nationally and internationally renowned faculty and practitioners, as well as industry and education partners, the School's programs provide opportunities for personal growth, job mobility, greater civic participation, and new ways to advance knowledge.
Within CUNY SPS, the Office of Professional Education and Workplace Learning (PEWL) designs custom workplace learning programs to help organizations achieve their goals. To our partnerships, we bring knowledge of research-based learning practices as well as experience in developing innovative programs.
CUNY SPS is recruiting a part-time program analyst who will support evaluation and reporting on training projects with NYC agency partners. Reporting to the Director of Monitoring, Evaluation, and Learning, the Program Analyst will develop, monitor, and report on program metrics such as registration, attendance, and other key performance indicators. The goal of this position is to assess training effectiveness in order to contribute to ongoing development and delivery of high-quality training.
The position is classified as Part-Time A with benefits. Please review benefits via the following links:
Duties and Responsibilities:
- Manage multiple attendance, registration, and survey data spreadsheets, of up to 10,000 rows, in Excel (40%)
- Routinely update, clean, de-dupe, and reconcile data
- Use complex formulas and pivot tables to track course completion, attendance, registration, and targets
- Create tables and dashboards to compare data across various criteria such as time periods and training cohorts
- Create data tables for reports
- Manage ongoing and routine evaluation activities (40%)
- Use Excel and Tableau to create and present weekly summary dashboards to internal program directors and external partners; data may include attendance and course satisfaction survey results
- Code and analyze quantitative and qualitative data
- Update survey tools as needed
- Attend project status meetings
- Write reports and presentations that translate data into cohesive findings and targeted recommendations. Customize reports to meet the needs of various stakeholders (20%)
- Other general responsibilities:
- Build collaborative relationships with internal stakeholders such as PEWL program directors, program coordinators, trainers, etc.
- Manage and prioritize work using project management software or similar tools
- Serve as a resource for evaluation, data analysis, and reporting
- Stay current on training evaluation methodologies
- Bachelor’s degree
- At least five (3) years of full-time experience in program or training evaluation, monitoring and evaluation systems, or impact assessment.
- Expert-level proficiency in MS Excel; ability to recode, merge, and analyze data using complex formulas; and display data using charts and pivot tables.
- Proficient in Tableau; ability to import data and create dynamic, user-friendly dashboards.
- Demonstrated experience in data management, recoding and analysis of quantitative data, and thematic coding of qualitative data.
- Demonstrated ability to analyze and interpret trends or patterns in both qualitative and quantitative data; and to make recommendations based on findings.
- Experience in survey design, sample selection, and use of survey design software such as Qualtrics.
- Excellent written and oral communication skills with the ability to thoughtfully translate findings, both verbally and in written form, to colleagues and stakeholders.