IL
EPCM Developer
ICONMA, LLC
🇺🇸 United States
Hybrid
2 months ago
$71.38 – $76.38 / hour
- Oracle
- Excel
- ERP
- REST API
- Regulatory Compliance
2 months ago
Â
Responsibilities:
Module-Specific Technical Expertise
- Allocation Rules & Rule Sets: Mastery in designing, building, and sequencing allocation rules. This includes defining source and destination intersections, allocation methods (e.g., proportional, even split), and driver-based allocations.
- Custom Calculations: Proficiency in writing custom MDX-based formulas or calculation logic when standard point-and-click allocation rules are insufficient.
- Dimension Management: Deep understanding of PCM/EPCM dimension types, specifically system-defined dimensions like Rule, Balance, and Point of View (POV), alongside standard business dimensions (Product, Customer, Department).
- Model Validation & Execution: Ability to run and optimize multi-step calculation jobs, analyze execution statistics, and troubleshoot performance bottlenecks or circular references.
- Smart View Mastery: Advanced skills in using Oracle Smart View for Excel to extract, manipulate, and analyze complex multi-dimensional datasets.
- Allocation Tracing & Balancing: Expertise in using Rule Balancing reports and the visual Allocation Trace tool to audit and verify that costs map accurately from source to target without "leakage."
- Native Analytics: Experience building Profit Curves, Scatter Analyses, Dashboards, and Reports to visually present profitability segments (e.g., Whale Curves for customer profitability).
- Data Management / Data Integration: Strong knowledge of loading metadata and financial data from ERPs or General Ledgers into PCM, including configuring import formats, location mappings, and data load rules.
- EPM Automate & REST APIs: Ability to write scripts to automate monthly data loads, POV copies, model calculations, and application backups.
- Enterprise Data Management (EDM): Familiarity with how corporate governance tools sync dimensions across the wider EPM suite downstream into PCM/EPCM.
- Cost Accounting Frameworks: Strong foundational knowledge of Activity-Based Costing (ABC), shared services chargebacks, IT financial management (ITFM), and corporate overhead allocations.
- Transfer Pricing & Regulatory Compliance: Understanding of how tax transfer pricing or regulatory cost justifications (e.g., in utilities or insurance) translate into allocation rules.
- Core Distinctions to Keep in Mind
Why Should You Apply?
- Health Benefits
- Referral Program
- Excellent growth and advancement opportunities
EPCM Developer · ICONMA, LLC