Senior Oracle Functional Analyst – A2R

This is a fully remote position, open to applicants in United States.

📋 Description

• Oversee functional analysis for A2R lifecycle standardization related to real property, GPP&E, and OM&S whenever applicable.

• Conduct agency discovery to pinpoint A2R adoption gaps, identify missing data, address stalled CIP/WIP balances, reconcile disconnected APSR/financial records, and assess manual off-system processes.

• Implement standardized discovery queries across DPAS/ELMS staging tables, GL journal sources, Projects, and Fixed Assets.

• Create functional designs for the integration of APSRs with DAI, including systems such as ELMS, GCSS MC, and others.

• Ensure traceability from physical accountability to financial accounting, and ensure compliance with DoDI 5000.64, SFFAS, and USSGL mapping requirements.

• Remedy partially implemented agencies by constructing Fixed Assets books, configuring capital project types/templates, addressing Projects/FA usage issues, and rectifying CIP/WIP backlogs.

• Establish and govern definitions for A2R events, attribute requirements, accounting treatments, and authoritative data sources.

• Collaborate with technical teams on automation for capitalization, DPAS inbound interface patterns, Account Generator alignment, and conduct regression testing.

• Perform root cause analysis on discrepancies within the asset lifecycle and develop remediation plans along with traceable documentation updates.

• Support program-level governance through standardized discovery intake and tracking for A2R-specific Help Desk/SCR/PSR.

• Contribute to the reusable DFAS/DTRA configuration playbook.

• Develop training materials, SOPs, and documentation for each event in the lifecycle.

⛳️ Requirements

• A minimum of 5 years of functional experience with Oracle EBS/DAI Federal Financials, encompassing Projects, Fixed Assets, Payables, and GL.

• Proficient in CIP/WIP lifecycle management, capitalization workflows, and asset accounting.

• Expertise in Acquire to Retire (A2R)/asset management.

• Familiarity with Order to Cash (O2C), Procure to Pay (P2P), and Budget to Report (B2R) modules.

• Extensive knowledge of federal fixed asset policies and accounting standards, including USSGL, SFIS, SFFAS, DoDI 5000.64, and FFMIA.

• Experience in identifying and resolving CIP/WIP challenges, including stalled projects, missing acceptance forms, improper cost allocations, disconnected APSR/DAI records, and reliance on manual journal vouchers.

• Capability to produce functional specifications, lifecycle documentation, acceptance criteria, agency discovery reports, and audit-ready evidence packages.

• Strong understanding of APSR to DAI integration patterns, such as DPAS inbound, necessary data elements, staging table behavior, and reconciliation workflows.

• Ability to collaborate effectively with both functional and technical teams, conduct stakeholder interviews, and lead agency-level remediation planning.

• Exceptional communication skills, with the ability to support audit inquiries, validate compliance, and demonstrate traceability.

• Eligibility to obtain and maintain IT II Non Critical Sensitive security clearance or Tier 3 (T3) investigation suitability.

• Previous experience in DAI or similar federal environments is preferred.

• Experience in supporting posting logic modernization, audit readiness initiatives, and compliance dashboards is preferred.

• Knowledge of JSON/relational modeling and familiarity with DevSecOps/test automation concepts is preferred.

• Possess an analytical, detail-oriented, and methodical approach to tasks.

• Strong facilitation and communication abilities.

• Demonstrate proactivity and reliability in compliance-focused environments.

🏝️ Benefits

• Competitive compensation package that includes a profit participation program.

• Comprehensive medical, dental, and vision coverage.

• Basic life insurance and accidental death & dismemberment insurance.

• Matching contributions through a 401(k) plan.

• Participation in the CGI share purchase plan.

• Paid vacation leave, which ranges from 10 to 20 days annually.

• 80 hours of floating holiday leave each year.

• At least 80 consecutive hours of paid sick/safe leave.

• Paid parental leave, varying from 20 to 70 consecutive business days.

• Bereavement leave, which ranges from 1 to 7 days per year.

• Paid jury duty leave, up to the time summoned.

• Opportunities for learning and tuition assistance.

• Wellness and well-being programs.