Careers Job Description
General Description
BACKGROUND
The City University of New York (CUNY) is the nation's leading urban public university, serving more than 540,000 students in degree, certificate, and continuing education programs at 24 colleges and institutions in New York City. The Office of the Senior University Dean for Academic Affairs (SUD) oversees a wide range of programs and initiatives across the University and in New York City, including adult literacy, service learning, early childhood professional development, workforce development, and continuing education programs. SUD also oversees a number of collaborative programs between the university and the New York City public schools, such as CUNY’s Early College Initiative and College Now; additionally, the unit manages the CUNY Language Immersion Program, CUNY Start, and the Accelerated Study in Associates Program (ASAP).
The Office of Research, Evaluation, & Program Support (REPS) was established in 2012 to partner with SUD programs and external organizations to provide evaluation services and data management support (http://www.cuny.edu/academics/evaluation/focus.html). Evaluation and research projects at REPS explore areas such as academic skills and achievement; college access, readiness, and success; career readiness; developmental education practice and policy; and educational equity among students and populations in New York City.
Using rigorous qualitative and quantitative social science research methods to assess program performance, REPS partners with programs to provide the process and outcome evaluation findings needed to develop, improve, and ultimately reach key project goals. REPS also supports programs by providing the reporting tools and data management essential to assessing program operations and effectiveness. Staff regularly shares research and evaluation findings with a range of stakeholders including program administrators, campus officials, external program partners, and a national audience of educators, researchers, and policymakers. http://www.cuny.edu/academics/evaluation/library.html
GENERAL DESCRIPTION
Under the supervision of the Director of Database Management, the Database and Application Developer will work cross-functionally with REPS staff to support evaluation, reporting, program, administrative projects and develop technology and data solutions as needed. He/she will be responsible for designing and developing new functionality for various REPS database application, as well as integrating other systems and implementing new tools and processes to support operations. REPS systems consist of local and web-based applications developed using a combination of the following technologies: HTML, JavaScript, AJAX, JQuery, CSS, JSON, Java, APEX, MS Access and Oracle Database. The Database and Application Developer will work closely with the data management team to plan, design, execute and launch new system functionalities or modify existing ones, including but not limited to the implementation of a business intelligence platform for reporting.
Other Duties
Planning/Design
- Work with the data management team to review current and create new front-end interfaces and functionality;
- Develop and design new functionality for the REPS database application to meet program and administrative needs;
- Assess current processes and develop technology solutions to create efficiencies, maximize data integrity and minimize manual data entry;
- Design, develop and unit test new features, enhancements and interfaces for Oracle APEX web application.
Management
- Maintain applications, including bug fixes, performance enhancements and runtime production support;
- Serve as the project lead on all tasks related to the database application and implementation of technology tools, provide guidance and feedback on the design and execution of new features;
- Work closely with REPS staff to support all stages of data collection, cleaning, coding, and file conversion into formats that are useful for program management, evaluation, and research;
- Maintain selected data sources and implement regular updates to ensure data quality;
- Assist with coordination and troubleshooting of database and software systems.
Documentation
- Create and maintain Standard Operating Procedures (SOPs) to ensure accuracy, consistency, and relevancy of all information stored across the REPS databases;
- Work with staff to create the end user documentation and training materials to be used throughout the life of the database.
Other tasks
- Provide technical and operational assistance to users, troubleshoot and resolve application and database related problems;
- Work with IT to solve technical problems;
- Perform other duties as assigned.
Qualifications
Required:
- Bachelor’s degree in Computer Science or related field required;
- Minimum 4 years of experience in data management with a strong background in relational database design along with knowledge of SQL Databases (Microsoft Access, Oracle database, Microsoft SQL Server);
- Strong understanding of relational data structures, theories, principles, and practices;
- Must have a strong background working with Oracle, SQL, and PL/SQL;
- Able to prioritize a heavy workload with minimum supervision;
- Strong project management and documentation skills.
Preferred:
- A solid understanding of Full Stack Development;
- Knowledge of data warehouse best practices, dimensional design/modeling and ETL architectures;
- The ability to write complex SQL queries, stored procedures, triggers and views and program in PL-SQL,VB/VBA;
- Experience with HTML, JavaScript, AJAX, JQuery, CSS, JSON, Java, APEX, MS Access and Oracle Database;
- Understanding of web architecture.
SALARY: $ 60,000.00 - 70,000.00; commensurate with experience.
EQUAL EMPLOYMENT OPPORTUNITY
We are committed to enhancing our diverse academic community by actively encouraging people with disabilities, minorities, veterans, and women to apply. We take pride in our pluralistic community and continue to seek excellence through diversity and inclusion. EO/AA Employer.
All applications must include a cover letter and CV/Resume and must be submitted for PVN# VA-1708-002002 at https://www.rfcuny.org/careers
RFCUNY Benefits
RFCUNY Employee Benefits and AccrualsAbout the Research Foundation
The Research Foundation of The City University of New York (RFCUNY) is a nonprofit educational corporation founded in 1963 to provide post-award fiscal and administrative support for CUNY’s research and sponsored programs. RFCUNY’s services allow CUNY researchers, faculty, and staff to focus on their intellectual curiosity and scientific discoveries, on projects and programs that serve our local and global communities, proposing concrete solutions to society’s most pressing challenges.
RFCUNY serves as a fiscal agent and works closely with all the CUNY campus Grants Offices to perform the core functions of post-award financial management for CUNY research projects and sponsored programs. These functions include legal assessment and signing of agreements where RFCUNY is named as a fiscal agent; setting up award accounts; preparing sub-awards and assisting PIs in monitoring the work of the recipients of sub-awards; supporting project directors with hiring and managing research project and sponsored program staff; supporting the purchasing and paying for goods and services with grant and program funds; managing financial aspects of projects including accounts receivable, financial reporting, invoicing, budget monitoring, and cost compliance with uniform guidance; ensuring that sponsor financial requirements are met; monitoring compliance with applicable project and financial management rules and laws; supporting the management of independent and external audits and financial reviews; and providing data, information, management expertise, and other supports to CUNY’s research and sponsored programs.
Equal Employment Opportunity Statement
Key Features
Office of Research, Evaluation & Program
Full Time
$60,000.00 - $70,000.00
Oct 14, 2017 (Or Until Filled)