Lead PeopleSoft HR Developer (Techno-Functional)

Columbia University in the City of New York; New York (NY); On-site; USD 150,000 - 168,000; Full time

Job summary

Columbia University in the City of New York seeks a Lead PeopleSoft HR Developer (Techno-Functional) to work with PAC PeopleSoft HRMS & Payroll teams, developing code, testing, and troubleshooting for TLAM and Payroll modules.

The role requires deep functional knowledge of Oracle/PeopleSoft, TLAM, HR and Payroll processes, acting as senior business analyst for the PAC team.

Qualifications

• Five to seven years of related experience.
• 5+ years with PeopleSoft 8.x and HR applications development.
• Experience on enterprise-wide projects and full lifecycle projects.
• Strong SQL and integration experience.
• Excellent written and verbal communication.

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.
• Conduct 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.
• 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.
• Leads testing efforts.
• 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.

Skills

PeopleSoft HR

Oracle SQL

PeopleTools

HRMS

Payroll

SDLC

Education

Bachelor's degree

Tools

PeopleTools 8.x

TLAM

Oracle SQL

Job description

• 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 work with changing priorities and with multiple projects.
• Ability to be precise and attentive to detail is essential.
• Ability to work with minimal supervision.
• Ability to work weekend and off-hour work on occasion.

Preferred Qualifications

• Working with an enterprise wide, large-scale implementation.
• Experience working with PeopleSoft Implementations in a Higher Education or Public sector environment.
• Experience in supporting application release management or project roll-out or occasional operational. processing during the non-business hours or weekends.
• Experience working within a matrix environment.
• Demonstrated leadership ability.

Equal Opportunity Employer / Disability / Veteran

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