Systems Analyst-System Dev

Columbia University; New York (NY); On-site; USD 95,000 - 103,000; Full time

Job summary

Columbia University Human Resources (CUHR) seeks a Systems Analyst to support the enterprise HRIS. The role collaborates with the Systems Development team to maintain, upgrade, and enhance HRIS applications, focusing on technical support for the HRIS function.

Responsibilities include creating test scripts, validating data integrity, liaising between HR and IT to implement changes, designing system integrations, and training users across the university.

Qualifications

• Bachelor’s Degree and/or a minimum of 3 years of experience with an Enterprise HRIS.
• Experience with PeopleSoft HRIS is preferred.
• Familiarity with core PeopleSoft HCM modules (Payroll for NA, Workforce Administration, Manager Self Service, Employee Self Service).
• Knowledge of PeopleSoft Query Manager and related tools (SQL Developer, Data Warehousing, Application Designer, Application Engine, Component Interfaces, Process Scheduler, Application Workflow Engine).
• Bachelor of Science in Information Systems.

Responsibilities

• Create technical, interface-related test scripts and carry out testing using extraction and reporting tools.
• Identify variances and research discrepancies to ensure the soundness of HR Systems, including accuracy, integrity, and confidentiality.
• Serve as a liaison between Human Resources and Information Technology to implement user requests and system enhancements.
• Assist HRIS team with technical design and development of system integrations and enhancements, including upgrades, updates, module implementations, and customizations.
• Support the development of functional specifications/requirements, create/execute test scripts, and perform end-user testing.
• Gather business requirements, demonstrate proof of concept, provide technical assistance in configuration, conduct user acceptance testing, and assist migration of the solution.
• Partner with Communications to develop system training materials and presentations for users across the University.

Education

Bachelor’s Degree in Information Systems

Tools

PeopleSoft HRIS

SQL Developer

Data Warehousing

Application Designer

Application Engine

Process Scheduler

Job description

• Job Type: Officer of Administration
• Bargaining Unit:
• Regular/Temporary: Regular
• End Date if Temporary:
• Hours Per Week: 35
• Standard Work Schedule:
• Building:
• Salary Range: $95,000 - $103,000

The salary of the finalist selected for this role will be set based on a variety of factors, including but not limited to departmental budgets, qualifications, experience, education, licenses, specialty, and training. The above hiring range represents the University's good faith and reasonable estimate of the range of possible compensation at the time of posting.

Position Summary

Columbia University Human Resources (CUHR) is dedicated to providing quality service to develop, manage, and support the University's vibrant community—so our faculty and staff can do great work.

The Systems Analyst will work closely with the Systems Development team to support the enterprise-wide Human Resource application. The Systems Analyst will focus on providing technical support to the HRIS function including but not limited to system maintenance, upgrades, administration, and enhancement of HRIS applications.

Responsibilities

• Create technical, interface-related test scripts and carry out the testing using extraction and reporting tools to build and test scenarios.
• Identify variances and research discrepancies to ensure the soundness of the HR Systems, including accuracy, integrity, and confidentiality.
• Serve as a liaison between Human Resources and Information Technology to effect programming changes and implement users’ requests and system enhancements.
• Assist the HRIS team with the technical design and development of system integrations and enhancements, including upgrades, updates, module implementations, and customizations.
• Support the development of functional specifications/requirements, create/execute test scripts, and perform end-user testing.
• Gather business requirements, demonstrate proof of concept, provide technical assistance in configuration, conduct user acceptance testing, and assist the HRIS team in migrating the solution.
• Partner with the Communication team to develop system training materials and presentations for users across the University.

Minimum Qualifications

• Bachelor’s Degree and/or a minimum of 3 years of experience working with an Enterprise HRIS system.

Preferred Qualifications

• Experience with PeopleSoft HRIS. Familiarity with the core PeopleSoft HCM module: navigation, methods to update and correct information, searching for help, etc.
• Working knowledge in any one of the following PeopleSoft HCM modules: Payroll for North America, Workforce Administration, Manager Self Service, and Employee Self Service.
• Some knowledge of PeopleSoft’s Query Manager, SQL Developer, Data Warehousing, Application Designer, Application Engine, Component Interface, Process Scheduler, and Application Workflow Engine.
• Bachelor of Science inan Information Systems discipline.

Other Requirements

• The ideal candidate must be inquisitive and possess an ardent desire to learn. Possess practical knowledge of HRIS and excellent analytical and project management skills.
• Experience partnering with other functional areas, particularly Finance and IT.
• Ability to analyze complex business requirements and translate them into technical designs and solutions.
• Excellent problem-solving and troubleshooting skills, with a strong attention to detail.
• Excellent communication, relationship-building, people skills, and the ability to deal with information in a confidential manner.
• Proficient usingsomeintermediate/advanced features found in Microsoft Office Suite, such aspivot tables, statistical and logical formulas, conditional formatting, etc.

Equal Opportunity Employer / Disability / Veteran

Columbia University is committed to the hiring of qualified local residents.