PeopleSoft Financials Functional Consultant

PeopleSoft Financials Functional Consultant

Location: Toronto Canada

Duration: Long-Term Contract

Job Summary

We are seeking a PeopleSoft Financials Functional Consultant with strong techno-functional experience across General Ledger, Accounts Payable, Accounts Receivable, Billing, Project Costing, and Purchasing. The consultant will work closely with finance, procurement, and project accounting stakeholders to gather requirements, perform fit-gap analysis, design functional solutions, configure PeopleSoft modules, and coordinate with technical teams to deliver reliable and auditable financial solutions.

Key Responsibilities

• Configure and support PeopleSoft General Ledger, including ChartFields, chart of accounts, journal processing, approvals, allocations, combination editing, period close, and consolidation.
• Support Accounts Payable processes including supplier setup, vouchers, 2-way/3-way matching, withholding, payment cycles, and AP-to-GL reconciliation.
• Support Accounts Receivable including customer setup, pending items, payment application, deposits, aging, collections, and dunning.
• Configure and support PeopleSoft Billing and Project Costing, including bill types, billing cycles, invoice generation, project/activity setup, cost collection, and revenue recognition.
• Support PeopleSoft Purchasing across requisitions, purchase orders, approvals, receiving, procurement contracts, items, and categories.
• Perform fit-gap analysis and prepare functional specifications, configuration workbooks, design documents, interface requirements, conversion requirements, and reporting specifications.
• Develop and optimize complex SQL queries to investigate data issues, reconcile financial balances, and support audit and reporting requirements.
• Build and maintain PS Query and financial reports for controlled and reusable access to financial and procurement data.
• Support month-end, quarter-end, and year-end financial close, including journal processing, reconciliation, and troubleshooting.
• Develop test scenarios and execute unit, integration, regression, and UAT testing.
• Support PeopleSoft upgrades, PUM images, tax updates, regulatory changes, and production issues.
• Work with technical teams on Application Engine, Integration Broker, Process Scheduler, interfaces, and batch process performance.
• Support PeopleSoft security and access controls, including segregation of duties.
• Participate in incident, defect, and root-cause analysis within Agile/ITIL support environments.

Required Qualifications

• 6–8 years of PeopleSoft Financials experience in a techno-functional or functional BA capacity.
• Strong experience across GL, AP, AR, Billing, Project Costing, and Purchasing.
• Strong SQL skills with Oracle or SQL Server, including complex joins, subqueries, aggregations, and basic query tuning.
• Good understanding of the PeopleSoft Financials data model.
• Experience with Application Designer, PS Query, Application Engine, Integration Broker, Process Scheduler, and reporting tools.
• Minimum 2 full PeopleSoft implementation or upgrade lifecycles.
• Strong understanding of accounting fundamentals, subledger-to-GL reconciliation, and financial close processes.
• Experience working with JIRA, ServiceNow, or similar incident/change/defect management tools.
• Strong analytical, communication, documentation, and stakeholder-management skills.
• Comfortable working in a hybrid day-shift environment in Washington, DC, with no travel.

Preferred / Certification

• PeopleSoft Certified Implementation Specialist – Financials or equivalent PeopleSoft certification.
• Additional certification in Database, SQL, Cloud, or related technology is preferred.