Lead PeopleSoft HR Developer (Techno-Functional)

• 559806

• Manhattanville

• Columbia University Information Technology

• Full Time

• Opening on: Sep 25 2026

• Grade 14

• Job Type: Officer of Administration
• Regular/Temporary: Regular
• Hours Per Week: 35
• Standard Work Schedule: Standard
• Building: Studebaker
• Salary Range: $150,000 - $167,500

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.

A strong internal candidate has been identified for this position, however, we are still accepting applications from other qualified candidates.

Position Summary

Reporting to the Sr. Director, Finance, HR & EDM Applications; the Lead PeopleSoft HR Developer (Techno-Functional) will work with the People at Columbia (PAC) PeopleSoft HRMS & Payroll Functional and Development teams to develop application code, unit test and troubleshoot issues for Columbia University’s PeopleSoft Human Resources application. The Lead PeopleSoft HR Developer (Techno-Functional) will have deep functional knowledge of Oracle/Peoplesoft, TLAM, Human Resources and Payroll business processes and will act as the senior business analyst for the PAC team.

Responsibilities

• Act as Subject Matter Expert and primary contact for system users for functional and technical support covering various HCM modules like TLAM and Payroll.
• Provide ongoing support and expertise PeopleSoft TLAM/Payroll.
• Strong Knowledge of TLAM configuration management principles.
• Conducts impact analysis, application development and unit testing to ensure the quality of the PAC systems application’s current design and development standards.
• New process/code development; custom enhancements to existing code, application patches/fixes/upgrades.
• Data and/or process analysis; code documentation; performance tuning; enhancements.
• Works closely with the project managers, functional team members and system administration teams to design, develop, test and implement project related changes.
• Works in a technical and business analyst capacity with a good understanding of HRMS and Payroll business processes, functionalities, relational databases and PeopleSoft table structure.
• Develops business requirements documentation, process workflow diagrams, and functional specifications, user acceptance test scripts, and other supporting documentation required for HRMS and Payroll changes.
• Prepares functional and technical documentation necessary to support business process changes or creation.
• Quickly understand the business issues and data challenges of the client’s organization and industry.
• Leads testing efforts.
• Updates documentation and modifies impacted processes for database platforms when necessary.
• Creates and reviews Technical and Functional Designs; unit testing; bundling/un-bundling of code using PeopleTools 8.58 or later versions of Tools and Oracle.
• Weekend and off-hour work may be necessary on occasion.
• All other duties as assigned.

Minimum Qualifications

• Bachelor’s degree required and/or its equivalent required.
• Minimum 5-7 years’ related experience.
• 5+ years’ relevant work experience with PeopleSoft 8.x (v. 9.0 is plus) development experience with People Soft HR applications.
• Experience working on enterprise wide projects a must.
• Two full lifecycle PeopleSoft HR, Payroll and/or Finance implementation experience.
• 5 years’ experience with PeopleSoft development tools and Oracle SQL.
• 5+ years’ PeopleSoft development and integration experience with upgrades and patches.
• 5+ years’ experience developing PeopleSoft interfaces into legacy and 3rd party systems.
• Strong knowledge of application development tools.
• Excellent knowledge of PeopleSoft HR Database model.
• 5 years’ experience on full PeopleSoft implementations with recent experience (prior 2yrs) using PeopleSoft HR.
• Excellent understanding of a systems development life-cycle methodology.
• Excellent written and verbal communication skills.
• Demonstrated ability to work in a fast-paced, deadline driven environment.
• Demonstrated excellence in a variety of competencies including teamwork/collaboration, analytical thinking, communication and influencing skills, and technical expertise.
• Ability to wo…