Quick Overview
Seniority
Mid Senior
Work mode
Remote
Location
United States
Posted
21 hours ago
Microsoft Excel
Job Description
- ChartField and program mapping: Assess code definitions, crosswalks, splits and mergers, effective dates, valid combinations, code retirement, and historical comparisons.
- HCM and payroll accounting: Evaluate combination codes, job data, funding splits, Additional Pay, payroll-to-GL interfaces, and current, retroactive, off-cycle, and future-dated processing where applicable.
- Timekeeping and departmental systems: Trace program-code dependencies in Kronos, time collection interfaces, speed types, quick-fills, and departmental tools.
- Purchasing, billing, and financial close: Analyze open purchase orders and requisitions, billing/ARS, payables and receivables interfaces, accruals, reversals, and reporting impacts.
- High-volume data updates: Evaluate Excel-to-CI and appropriate alternatives; define sequencing, validation, reconciliation, exception handling, restart, recovery, and audit requirements.
- Production transition and history: Define treatment of open transactions, historical records, and comparative reporting; coordinate phased cutovers and coexistence of old and new codes.
Key Responsibilities
- Lead discovery workshops with Finance, Payroll, IT, Procurement, and departmental stakeholders; document the current state, affected inventory, requirements, decisions, and dependencies.
- Develop the old-to-new crosswalk and transformation rules for City approval, including mappings that depend on department, transaction type, or effective date.
- Produce functional and technical specifications identifying affected objects, interfaces, reports, business rules, triggers, sequencing, exceptions, downstream impacts, and acceptance criteria for City developers.
- Maintain the integrated project plan, milestones, resource dependencies, decision log, and risk/issue register; escalate capacity gaps and coordinate specialist input as needed.
- Recommend batch-update approaches and document run controls, validation queries or reports, reconciliation evidence, and recovery procedures with the City s technical team.
- Develop test scenarios, scripts, and expected results; coordinate functional, integration, regression, and user acceptance testing, defect triage, retesting, and business sign-off.
- Develop stakeholder communications, training materials, and job aids; facilitate readiness sessions and knowledge transfer for affected departments.
- Prepare implementation and cutover plans, rehearsals, readiness criteria, rollback/recovery steps, and production validation; support stabilization within the agreed engagement term.
- Maintain implementation documentation and provide a final report covering outcomes, unresolved risks, lessons learned, and recommendations for ongoing support.
Required Qualifications
- Demonstrated leadership of a ChartField, chart-of-accounts, program-code, or comparable financial coding restructure in a live PeopleSoft environment, with clear examples of personal responsibilities and outcomes.
- Strong PeopleSoft FSCM functional expertise and meaningful HCM/payroll accounting experience, including combination codes, funding distributions, Additional Pay, effective dating, and payroll-to-general-ledger reconciliation.
- Ability to trace functional and data dependencies across PeopleSoft applications, interfaces, reports, and customizations and translate findings into implementation-ready specifications.
- Practical experience designing and validating high-volume data updates using Component Interfaces, Excel-to-CI, or appropriate PeopleSoft loading methods, including error handling and reconciliation.
- Experience planning end-to-end testing, validating converted or updated data, supporting cutover, and resolving functional issues while maintaining operational continuity.
- Ability to lead project plans, workshops, risks, and stakeholder communications; work independently; and obtain timely City decisions and approvals.
Preferred Qualifications
- Public-sector or local-government finance, payroll, and departmental operating experience.
- Kronos or comparable timekeeping integration experience in a PeopleSoft environment.
- Experience with phased code transitions, historical crosswalks, and open-transaction handling across fiscal or payroll periods.
Similar jobs
- RT
ServiceNow Platform Architect
NewReveille Technologies
United States🇺🇸Hybrid21 hours agoTechnology - ST
ServiceNow Platform Architect
NewSTAFFXPERT LLC
Chattanooga, TN🇺🇸On-site21 hours agoStakeholder ManagementComplianceServiceNowTechnology - OH
Windchill Solution Architect
NewOmega Hires
United States🇺🇸Hybrid21 hours agoOracleSQLJava+2Technology - AC
Solutions Architect: IV (Lead) - Dynamics 365 Solutions Architect
NewApetan Consulting
United States🇺🇸Hybrid21 hours agoStakeholder ManagementGitScrum+6Technology - BN
Senior Vice President, Infrastructure Solution Engineer - BNY
NewBNY
Hoboken, NJ🇺🇸Hybrid21 hours agoJavaPythonTechnology - IF
Technical Solution Architect
NewiFLOW
Plano, TX🇺🇸Hybrid21 hours agoAWSOAuthSAML+8Technology - ER
Senior PeopleSoft Functional Solution Architect
NewERPA
United States🇺🇸Hybrid21 hours agoMicrosoft ExcelTechnology - QS
Principal Network Solutions Architect with Security Clearance
Quantum Sky Engineering LLC
Reston, VA🇺🇸Hybrid1 week agoMongoDBMySQLOpenStack+19Technology - IT
Senior Enterprise Solutions Architect (Salesforce) -- Multiple Locations (OH) /W2/
NewIntellisoft Technologies
Columbus, OH🇺🇸Hybrid21 hours agoAWSGoogle CloudAgileTechnology - BO
Director of Marketing Technology (Multi-Solution Architect)
NewBounteous, Inc.
United States🇺🇸Hybrid21 hours agoGDPRTechnology - CT
Ironclad Technical Lead / Solution Architect
NewCogniSoft Technologies
Chicago, IL🇺🇸Hybrid21 hours agoTechnology - PS
SAP AFS S4 HANA Solution Architect Onsite - Buffalo, New York
NewParamount Software Solutions, Inc
Buffalo, NY🇺🇸On-site21 hours agoTechnology