Do you love providing technical consulting on complex projects? Enjoy working independently and as a team leader providing mentorship related to the business implications for applications and various systems?
We are looking for an Application Specialist to serve as the senior technical advisor to the Research and Technology Management (RTM), Information Systems Support (ISS) unit.
You will advise the Director and staff on technical merits surrounding RTM applications and support the IT requirements of RTM, including the analysis, design and testing of applications and user training. In addition, you will support internal applications, collaborate with other corporate systems and advise regarding technical matters.
Develop (analyze requirements, design code, document and test) VBA Access, MS-SQl server stored procedures and Web based applications using ASP and ASP.NET.
Create and maintain complex reports using MS Reporting Services
Devises and or modifies procedures to solve the most complex technical problems related to computer equipment capacity and limitations, operating time and form of desired results.
Creates detailed specifications from which programs will be written.
Maintain user accounts and security in Research and Technology Management applications and ensure security of departmental data with a thorough working knowledge standard methodologies and MSKCC policy.
Liaison with IT department to resolve hardware issues, security issues and other application issues.
Support nightly jobs and processes ensuring that failed jobs are analyzed and corrected for data integrity.
Perform SQL server DBA functions and work with central IT DBA to resolve issues.
Possess a deep understanding of the existing and new data structures and business processes associated with Research and Technology Management and affiliated MSK departments.
Configure and develop Huron applications according to user specifications.
Provide expert technical and data analysis skills with a complete understanding of ERA (Electronic Research Administration).
Undergraduate degree and 7-10 years work experience in system development in financial accounting systems. Knowledge of PeopleSoft HR, experience working with grants and contract applications, and experience with Oracle and/or Sybase databases.
Masters Degree in Information Technology preferred
The desire and capability to leverage your IT skills into new technologies
The ability to deeply understand the business functions and challenges faced by operations staff, and the competence to transform information technology into solutions. Current supported application business functions include: Outside interests disclosure (COI), Grants and Contracts, finance and budgets, various legal contracts and lab safety but are likely to expand.
Internal Number: 2019-32067
About Memorial Sloan-Kettering Cancer Center
As one of the world's premier cancer centers, Memorial Sloan-Kettering Cancer Center is committed to exceptional patient care, leading-edge research, and superb educational programs. The close collaboration between our physicians and scientists is one of our unique strengths, enabling us to provide patients with the best care available today as we work to discover more effective strategies to prevent, control, and ultimately cure cancer in the future. Our education programs train future physicians and scientists, and the knowledge and experience they gain at Memorial Sloan-Kettering has an impact on cancer treatment and the biomedical research agenda around the world.