PeopleSoft Financials Functional Consultant

Job summary

Configure and support PeopleSoft Financials modules, including GL, AP, AR, Billing, Project Costing, and Purchasing, while gathering requirements and designing auditable functional solutions. Support financial close, reporting, testing, upgrades, production issues, integrations, security controls, and incident analysis in coordination with business stakeholders and technical teams.

Job details

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.

What you’ll do

Configure and support PeopleSoft Financials modules, including GL, AP, AR, Billing, Project Costing, and Purchasing, while gathering requirements and designing auditable functional solutions. Support financial close, reporting, testing, upgrades, production issues, integrations, security controls, and incident analysis in coordination with business stakeholders and technical teams.

Requirements

Requires 6–8 years of PeopleSoft Financials experience, strong functional knowledge across the listed modules, SQL skills, and experience with PeopleSoft tools and financial close processes. Candidates should have completed at least two implementation or upgrade lifecycles and bring strong analytical, communication, documentation, and stakeholder-management skills.

Listed skills

• Accounts receivable · Preferred
• Billing · Preferred
• SQL · Preferred
• Oracle · Preferred
• Financial Reconciliation · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• PeopleSoft Financials
• General Ledger
• Accounts Payable
• Accounts Receivable
• Billing
• Project Costing
• Purchasing
• SQL
• Oracle
• PeopleSoft Data Model
• Application Designer
• PS Query
• Application Engine
• Integration Broker
• Process Scheduler
• Financial Reconciliation

Job areas

• Finance & Accounting
• Technology
• Consulting
• Data & Analytics

More jobs from Confiar Services