Oracle EPM - AM
KPMG Ignition Tax in the United States partners with KPMG Global Services (KGS) to deliver Oracle Tax Reporting Cloud Service (TRCS) and the broader Oracle EPM suite.
As a non-client-facing Senior Associate, you will focus on hands-on configuration, data integration, and quality assurance-bringing together TRCS, Financial Close (FCCS), and Oracle's integration toolset (Data Exchange, Data Management, EPM Integration Agent, Oracle Integration Cloud, REST / SOAP APIs).
You will work primarily with U.S. engagement teams, translating functional tax requirements into robust, scalable technical designs that follow KPMG Powered Enterprise and Oracle OUM/ACT delivery standards.
Key Responsibilities
- Oracle EPM Build & Configuration
Configure TRCS tax automation, hierarchies, security, and workflow.
Build calculation scripts, business rules, and member formulas (Essbase). - End-to-End Data & System Integration
Design and deploy integrations using Oracle Data Exchange, Data Management / FDMEE, EPM Integration Agent, and Oracle Integration Cloud (OIC).
Develop and maintain REST / SOAP API calls, EPM Automate scripts, and scheduled jobs for continuous data flows.
Map and transform data from multiple ERPs (Oracle ERP Cloud, SAP, Workday, etc.) into TRCS / FCCS tax and finance models. - Solution Design Support
Convert Functional Design Documents into detailed Technical Design Documents that cover data mappings, integration specs, and control points.
Ensure traceability from ASC 740 and tax-provision requirements through to configuration and reporting. - Testing & Quality Assurance
Author unit, SIT, and performance test scripts; execute tests and log defects in JIRA.
Manage migration artifacts (Dev Test Prod) via Lifecycle Management (LCM) and OIC pipelines; capture evidence for SOX & KPMG QA reviews. - Documentation & Knowledge Management
Produce configuration workbooks, integration run-books, and user guides.
Contribute reusable integration templates and lessons learned to KPMG's global EPM knowledge base. - Collaboration & Mentoring
Participate in daily U.S. / India stand-ups; provide progress updates, raise blockers, and manage time-zone hand-offs.
Coach junior team members on Oracle EPM and integration best practices.
Daily Activities
Configure dimensions, data forms, integrations, and security in TRCS / Data Exchange.
Run and troubleshoot data loads; reconcile tax balances and address data exceptions.
Update RAID items in JIRA / ServiceNow and participate in design walkthroughs and peer reviews.
Automate integration jobs and monitor schedules, ensuring data is available for tax close cycles.
-