Job Description
General Description
This position works cross-functionally with the Office of Academic Affairs (OAA) staff to support evaluation, reporting, administrative projects, and to develop technology and data solutions. This position is responsible for designing and developing new functionality for various OAA database applications, as well as integrating other systems and configuring servers, migrating them, and updating various add-ons.
Specific duties include:
- Work with the data management team to review current front-end interfaces and to develop new interfaces and functionality;
- Develop and design new functionality for the OAA database applications 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 applications;
- 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;
- Create and maintain Standard Operating Procedures (SOPs) to ensure accuracy, consistency, and relevancy of all information stores across OAA databases;
- Work with staff to create the end user documentation and training materials to be used throughout the life of the database;
- Provide technical and operational assistance to users, troubleshoot and resolve application and database related problems.
Other Duties
N/A
Qualifications
Requires bachelor’s degree in Electrical Engineering, Electronics Engineering, Computer Science or related field, and four years of related experience.
Experience must include:
- Four years of data management with a strong background in relational database design;
- Four years of SQL databases (Microsoft Access, Oracle database, Microsoft SQL Server);
- Two years of Tableau Server administration, architecture, installation, migration, and upgrades
- Two years of experience developing web applications with Oracle APEX;
- Two years of experience designing and developing cloud-native, scalable, and highly available distributed systems.
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
$100,500.00 - $100,500.00
Jul 28, 2023 (Or Until Filled)