Sr Technical OneStream Specialist

The Ideal Candidate:
Platform & Modeling

• Proficient in One Stream XF/Unity Platform: decision modeling, data book, designs, workflows, allocation and intercompany processes, and currency translation.
• Experience with data integration and ERP sources (SAP, Oracle) and direct connections with SAP HANA.

• Strong Understanding of SAP Integrated Business Planning (IBP) concepts: demand planning, supply planning, inventory optimization, and sales& operation planning (S&OP).
• Ability to align IBP planning streams with financial consolidation in One Stream.

• Expertise in financial consolidation, entity mapping, intercompany eliminations, currency translations, and reporting pack design.
• Knowledge of One Stream financial data model, account schedules, and period close processes.

• Experience building statistical and driver‑based forecasts, scenario planning, and what‑if analyses.
• Ability to integrate demand plans for IBP with financial forecasts and capacity constraints.

• Proficient with SAP HANA data modeling, CDS views, and HANA‑native data provisioning (SDA, SDA2).
• Scripting and automation: SQL XBRL, One Stream Automation, and EPM scripting.
• Familiar with ETL/ELT concepts and data lineage, audits, and data quality controls.

• Strong Excel, Power BI/Tableau for reporting, One Stream KPI dashboards and financial reports.
• Project lifecycle: requirements gathering, design, build, test, user acceptance, and deployment.
• Stakeholder communication across FP&A, IT, and business units.

• Ons Stream
  • Data books, workflows, allocations, currency translation, security, validation rules
  • Consolidation Model, dashboards, reports, close processes.
• IBP
  • Demand Planning, S&OP, supply planning, SAP IBP integration.
  • Demand Plans, supply plans, capacity constraints.
• SAP HANA
  • Data modeling, CDS views, SDA/SDI data provisioning.
  • HANA views, source‑to‑target mappings, native queries.
• Financial Consolidation
  • Intercompany eliminations, translation, minority interest, consolidation ledger.
  • Consolidated trial balance, equity method, close package.
• Forecasting
  • Time‑series, driver‑based forecasting, scenario planning.
  • Forecast models, scenario comparisons, forecast accuracy metrics.
• Data Integration
  • ETL/ELT, data quality, lineage, SAP ERP integration.
  • Data maps, reconciliation reports, board packs, KPI dashboards.
• Reporting & Visualization
  • Excel, Power BI, One Stream dashboards.
  • Management reports, board packs, KPI dashboards