PeopleSoft Financials Functional Consultant

Location: Toronto Canada

Duration: Long-Term Contract

Job Summary

We are seeking a PeopleSoft Financials Functional Consultant with solid 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.

📌 PeopleSoft Financials Functional Consultant (Toronto)
🏢 Confiar Services
📍 Toronto