Job Title: Programmer/Analyst
PVN ID: PS-1603-001066
Category: Administrative Services
Location: CUNY SCHOOL OF PROFESSIONAL STUDIES

Job Description

General Description

The School of Professional Studies of the City University of New York (CUNY SPS) has launched eightteen degrees: ten bachelor's degrees open to students with 24 or more college credits who wish to complete their undergraduate studies, and eight master's degrees, with more programs currently in development. CUNY SPS leads the University in developing and operating online degree programs, and trains faculty throughout CUNY in online instruction. CUNY SPS is also the home of the Joseph S. Murphy Institute for Worker Education and Labor Studies, which offers higher education programs for working adults and union members, and serves as a nationally-recognized center for scholarship and resources for labor, academic, and community leaders seeking a deeper understanding of labor and urban issues.

In addition to offering degree programs, CUNY SPS partners with numerous New York City and New York State agencies to develop and deliver custom learning programs. One such partner is the New York State Office of Children and Family Services (OCFS) which provides family support, juvenile justice, child care and child welfare services that promote the safety and well-being of children and adults. Through its Bureau of Training and Development (BTD), OCFS also delivers classroom-based and online training to thousands of its employees statewide, as well as develops and maintains training systems that support registration, tracking, reporting, assessment, evaluation, and related functions. 

This position is physically located on-site at the NYS Office of Children and Family Services in Albany-Rensselaer, New York.

Other Duties

Reporting to the Systems Manager, the  Programmer/Analyst will provide training, data analysis, ad hoc reporting, and technical expertise to meet OCFS HR and Training needs. Specifically, s/he will:

  • Provide training and training support for the management, maintenance, and administration of HR systems (both off-the-shelf and proprietary in-house applications).
  • Gather and join data from various systems and perform required analysis utilizing SQL, Excel and Access.
  • Train staff in the development of various ad hoc reports.
  • Provide training support with software and hardware issues.
  • Document and record all CRM system issues and resolutions.
  • Provide training support for custom report design and programming, utilizing various tools, such as Cognos, Excel and Access.
  • Identify training issues for HR staff utilizing the Request to Fill (RTF) system.
  • Assist OCFS/HR staff with the use of computer applications, such as TRS, NYSTEP, RTF, Sharepoint and MS Office products.
  • Perform routine HR updates to the Statewide Learning Management System (SLMS).
  • Maintain the HR office Intranet website.
  • Provide training support for approximately 60 staff members throughout the HR program areas on applications including, but not limited to, Microsoft Outlook, MS Office and HCM.
  • Prepare and submit reports and paperwork in a timely fashion in compliance with policies and procedures.
  • Other duties as assigned.

May include variable hours and travel in NYS.

Qualifications

Requirements for the Position:

  • Bachelor’s degree in HR Information Systems (HRIS), or a related field plus three (3) years relevant experience; or a comparable combination of education and experience.
  • Proficiency in SQL, MS Excel and MS Access (including: SQL queries, Stored Procedures, Functions, Triggers, etc.; solid experience with VBA for Excel and solid experience with VBA for Access/SQL Data Analyst to work with large amounts of data to meet a variety of reporting needs within the organization; must be experienced with Excel -- verifiable experience doing v-Lookups, pivot tables, macros, formulas, VBA troubleshooting/bug fixes; and must be experienced with Access -- make modifications, add/delete tables, add details, and make form changes).
  • Must have a working knowledge of HTML and CSS (a knowledge of coding standards in HTML and CSS is required; applicant will be utilizing ColdFusion, HTML5, CSS3, Java, JQuery, Bootstrap and similar technologies).
  • Must have a working knowledge of Network Technical Support (a basic understanding of network support with the ability to assist end-users with common enterprise environment issues, such as login, printer, and connectivity issues).
  • Experience in generating reports from data warehouses and databases, as well as experience in associating data elements from various data sources to generate management-level reports.
  • Strong organizational skills, attention to detail and written communication skills.
  • Ability to learn new proprietary and non-proprietary software in a timely fashion.
  • Experience in hardware installation/maintenance and trainee support.
  • Demonstrated knowledge of network technology and experience working in government, especially social services or public sector HR environment.

Demonstrated ability to work effectively with diverse groups, handle multiple priorities and work well under pressure.

About the Research Foundation

The Research Foundation of The City University of New York (RFCUNY) was established as a not-for-profit educational corporation chartered by the State of New York in 1963. RFCUNY supports CUNY faculty and staff in identifying and obtaining external support (pre-award) from government and private sponsors and is responsible for the administration of all such funded programs (post-award).

RFCUNY stands between CUNY’s principal investigators (PIs) and the sponsors who support them and strives to fulfill its essential responsibilities to both groups. Working closely with individual PIs and Grants Officers on the campuses, RFCUNY oversees employment, accounting, audit, reporting, purchasing, and special responsibilities that include management of a planned giving program; liaison with governmental agencies and foundations; negotiation of agreements; facility construction and renovation; protection and commercialization of intellectual property; and compliance with applicable standards in research involving human subjects, animal care, environmental and radiological safety, and conflicts of interest.

Equal Employment Opportunity Statement

The Research Foundation of the City University of New York is an Equal Opportunity/Affirmative Action/Americans with Disabilities Act/E-Verify Employer. It is the policy of the Research Foundation of CUNY to provide equal employment opportunities free of discrimination based on race, color, age, religion, sex, pregnancy, childbirth, national origin, disability, marital status, veteran status, sexual orientation, gender identity, genetic information, marital status, domestic violence victim status, arrest record, criminal conviction history, or any other protected characteristic under applicable law.

Key Features

Department
CUNY School of Professional Studies
Status
Full Time
Annual Salary Range
$63,000.00 - $65,000.00
Closing Date
Oct 28, 2016 (Or Until Filled)
Bargaining Unit
No

Actions