Job Description
We are seeking a highly skilled Technical Analyst / Developer to support and enhance our NetSuite Planning & Budgeting (NSPB) platform. This role is responsible for ensuring optimal application performance, maintaining and developing calculation rules/scripts, supporting data integration processes, and driving continuous improvement across our planning ecosystem.
The ideal candidate brings a strong technical foundation in NetSuite Planning & Budgeting (NSPB), Oracle EPM/Hyperion Planning or Essbase, experience with multi-dimensional modeling, and a passion for performance tuning and system optimization. This role partners closely with FP&A, Accounting, and IT to deliver a high-performing planning and forecasting environment.
Key Responsibilities Performance Optimization & Multi-Dimensional Modeling
- Serve as the primary technical SME for NSPB application design, configuration, and maintenance.
- Manage dimension and metadata maintenance (hierarchies, member properties, aliases, attributes).
- Optimize calculation performance, aggregation processes, and business rules.
- Tune data retrieval performance in Smart View / NSB UI (e.g., reduce query times, optimize grids & filters).
- Conduct performance diagnostics (query logs, calc logs, data load logs, aggregation traces).
- Recommend improvements to cube design, dimensionality, sparse/dense settings, and caching behaviors.
- Perform periodic cube restructures to maintain optimal performance across periods and model changes.
Rule / Script Development
- Develop, enhance, and maintain NSPB Business Rules and data maps.
- Translate FP&A business logic into performant calculation logic (driver-based models, allocations, spreading, FX conversions, eliminations).
- Build and optimize complex calculation scripts, including Hybrid/BSO-style logic adapted for NSPB architecture.
- Support automation of recurring calculations (e.g., allocations, workforce plans, CapEx schedules, revenue models).
Data Integration & Automation
- Manage and optimize data flows between NetSuite ERP, NSPB, and third-party systems.
- Support Planning & Budgeting Sync and EPM Connector integrations; troubleshoot saved searches, data mapping, and import jobs.
- Develop automated routines for metadata updates, data refreshes, and scheduled jobs.
- Support integration transformation logic using SQL, Python, Power Query, or ETL tools where appropriate.
Troubleshooting & Root Cause Analysis
- Serve as an escalation point for system issues, integration failures, calc rule errors, and performance degradation.
- Perform root cause analysis for load failures, incorrect data aggregation, missing metadata, or slow retrieve times.
- Develop/expand structured runbooks, validation scripts, and performance dashboards/logs.
Cross-Functional Support
- Partner with FP&A and Accounting teams to translate planning requirements into scalable technical solutions.
- Support monthly/quarterly planning cycles by ensuring system readiness and stable performance.
- Train end users on Smart View, forms, data validation, and error troubleshooting.
- Maintain clean documentation for rules, metadata, integration flows, and performance tuning changes.
Qualifications Required
- 3–6+ years supporting Planning & Forecasting/EPM systems in a technical capacity.
- Hands-on experience with NetSuite Planning & Budgeting (NSPB) or Oracle Planning Cloud / EPBCS / Hyperion Planning.
- Strong understanding of multi-dimensional models (BSO/Hybrid), metadata management, and performance tuning techniques.
- Experience writing and optimizing: Calculation scripts (Calc Manager), Groovy rules, Business Rules (forms, data maps, allocations) and Data management/metadata automation
- Hands-on experience improving: Aggregation times, Retrieve/query performance, Cube restructure and optimization
- Proficient in SQL, Excel/Power Query, Smart View, and logic validation.
Preferred - Experience with Oracle Essbase (BSO/ASO), including load rules, data exports, calc scripts, and outline tuning.
- Background working with financial processes (forecasting, budgeting, consolidations, workforce planning).
- Experience with NetSuite ERP Saved Searches, Planning & Budgeting Sync, and data import job tuning.
- Scripting/automation skills in Python, VBA, or ETL tools.
- Understanding of intercompany eliminations, FX translation, and driver-based planning models.
Additional information: - Homebased
- M to F, 8pm to 5am PH Time
