OFSAA EPM Consultant

Company : Unison Group

Job Type : Full Time

Singapore, Singapore

Number of Applicants

000+

Apply Now

Let AI Supercharge Your Job Hunt!

JobCopilot scans 500,000+ company career sites daily to find jobs for you

Never miss an opportunity Save hours by auto-filling applications forms Land more interviews with tailored applications

Activate JobCopilot

Job Description - OFSAA EPM Consultant

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.

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

Original job OFSAA EPM Consultant posted on GrabJobs ©. To flag any issues with this job please use the Report Job button on GrabJobs.

Apply Now

Auto-Apply to Similar Jobs

Share Job

Get your Resume Reviewed for Free

Automate Job Applications for Similar Jobs

Auto-Apply to Consultant Jobs with your AI JobCopilot

Auto-Apply with AI

Similar Consultant Jobs in Singapore

Get your Resume Reviewed for Free

Email address

Why are you reporting this job?

I think it’s a discriminatory or offensive

I think it’s fraudulent or a scam

I think it’s trying to sell something unrelated to the job / it’s asking for money

I think it contains incorrect or broken information

Other

All Job Ads are subject to GrabJobs’s Terms of Service. We allow users to flag postings that may be in violation of those terms. Job Ads may also be flagged by GrabJobs moderation team. However, no moderation system is perfect, and flagging a posting does not ensure that it will be removed.

Setup your job alert:

Frequency

By activating job alerts, I agree to GrabJobs Terms & Privacy Policy. I can unsubscribe to job alerts anytime. Skip

OFSAA EPM Consultant

Job Description - OFSAA EPM Consultant

Similar Consultant Jobs in Singapore

Mobile Apps