Lead PeopleSoft HR Developer (Techno-Functional)

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

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.