# OFSAA EPM Consultant

> Unison Group · Singapore, Singapore · — · Posted 2026-04-22

**Salary:** SGD 96,000–120,000

**Workplace:** on_site

**Department:** Bharat

## Description

-   Implement end-to-end EPM solutions for PFT/FTP/Allocations under guidance of IC4 leads.
-   Configure OFSAA Rule Framework components including:

-   Allocation and driver rules
-   Transfer pricing pools and pricing rules
-   Transformation rules
-   Profitability and costing calculation logic

-   Configure and maintain metadata (DIM/FCT structures), hierarchies, and mapping rules.
-   Develop SQL/PLSQL scripts, packages, functions, and procedures for:

-   Data transformation & enrichment
-   Rule logic support
-   Batch execution
-   Exception handling

-   Optimize SQL logic for medium-to-large workloads and improve execution efficiency.
-   Support and enhance data pipelines (STG → FCT → Reporting layer).
-   Work with ETL engineers (ODI/Informatica) to implement mapping and ingestion logic.
-   Perform data profiling, cleansing, reconciliation, and lineage documentation.
-   Run EPM batch cycles including PFT/FTP/Allocations.
-   Analyze logs, SQL traces, and performance bottlenecks and apply tuning fixes.
-   Understand performance optimization for partitions, indexes, and materialized views.
-   Write and execute unit tests and SIT test plans.
-   Validate profitability/FTP/Allocation rule outputs against functional requirements.
-   Assist in defect triage, RCA, and support the UAT cycle.
-   Prepare technical design documents, build workbooks, and mapping specifications.
-   Support deployment across environments (DEV → SIT → UAT → PROD).
-   Maintain version-controlled build scripts and change management documentation.

## Requirements

-   Strong hands-on SQL/PLSQL expertise (complex joins, aggregations, performance tuning).
-   Experience configuring OFSAA Rule Framework components (allocation, FTP, PFT).
-   Understanding of DIM/FCT metadata models and mapping concepts.
-   Familiarity with ETL tools (ODI/Informatica) or PL/SQL-based data ingestion pipelines.
-   Experience working with large data volumes and performance tuning concepts:

-   Indexing strategy
-   Partitions and subpartitions
-   Column statistics and gathering plans
-   Query execution plans

-   Familiarity with OCI/Exadata environments (preferred).
-   Understanding of financial/treasury data such as:

-   GL & cost center hierarchies
-   Product hierarchies
-   Driver-based allocations
-   Transfer pricing models

-   Ability to convert functional logic into scalable technical execution.
-   4–7 years of experience in OFSAA EPM implementations.
-   Hands-on experience in PFT/FTP/Allocations/Costing/MIS.
-   Experience in multi-entity/multi-GL EPM implementations.
-   Degree in Computer Science, Engineering, Information Systems, or equivalent

## Apply

[Apply at Unison Group](https://apply.workable.com/unisongroup/j/A5B7FF8C91/apply)

---
Powered by [Workable](https://www.workable.com)