OneStream Developer

Job Description Role Overview

The OneStream Developer / Lead is responsible for designing developing and supporting OneStream applications that power the organizations financial consolidation close planning budgeting forecasting and reporting processes. The role combines hands-on configuration and business-rule development with delivery responsibilities and - in the Lead variant - includes oversight of a team of developers and consultants. The position works closely with the OneStream Architect Finance stakeholders (FP&A Accounting Controlling) and IT teams to translate business requirements into scalable well-governed solutions.

• Design and develop scalable applications within OneStream

• Build and maintain:

  • Business Rules (-based) for calculations and logic

  • Cube Views for reporting

  • Dashboards and Workspaces for end users

  • Forms and Workflow configurations

• Configure metadata (dimensions hierarchies members)

• Develop reusable components and templates

• Implement and support:

  • Financial consolidation and close processes

  • Intercompany eliminations and currency translations

  • Planning budgeting and forecasting models

• Align system design with accounting standards and business processes

• Design and develop data integration pipelines:

  • Load data from ERP systems (SAP Oracle etc.)

  • Work with staging tables and transformation rules

• Develop and maintain:

  • Data Management sequences

  • Mapping tables and validation checks

• Ensure data accuracy reconciliation and auditability

• Analyze and optimize:

  • Business rules performance

  • Data load times

  • Cube calculation efficiency

• Troubleshoot:

  • Data inconsistencies

  • Workflow failures

  • System performance bottlenecks

• Participate in:

  • Unit testing

  • System Integration Testing (SIT)

  • User Acceptance Testing (UAT)

• Support production deployments and release cycles

• Manage migration across environments (Dev Test Prod)

• Lead a team of developers/consultants

• Assign tasks and track progress

• Conduct code reviews and enforce best practices

• Provide technical guidance and mentoring

• Act as a bridge between Architects functional teams and developers

• Work with finance teams (FP&A Accounting Controlling)

• Translate business requirements into technical solutions

• Conduct workshops and requirement-gathering sessions

• Provide user training and documentation

• Follow and enforce:

  • Naming conventions

  • Coding standards

  • Documentation practices

• Ensure compliance with:

  • Internal controls

  • Financial regulations

• Maintain audit trails and system integrity

• Strong hands-on experience with OneStream

• Expertise in:

  • scripting (Business Rules)

  • SQL / T-SQL

  • Relational databases (SQL Server preferred)

• Experience with:

  • Cube design and dimensional modeling

  • Workflow and security configuration

  • API integrations and automation

• Strong understanding of:

  • Financial consolidation

  • Close management processes

  • Planning budgeting forecasting

  • Financial reporting and analytics

• Analytical thinking and problem-solving

• Strong communication with finance & IT stakeholders

• Leadership and mentoring (for Lead role)

• Ability to work in fast-paced project environments

• Bachelors degree in Finance Accounting Computer Science or related field

• 4 6 years (Developer) / 6 10 years (Lead) in CPM/EPM tools

• Hands-on experience with at least 1 2 end-to-end OneStream implementations

• OneStream certification (preferred)

• Experience with other EPM tools (Hyperion SAP BPC Anaplan)

• Knowledge of:

  • Data warehousing concepts

  • Power BI / reporting tools

• Exposure to Agile/Scrum methodologies

• Fully functional OneStream applications

• Optimized and scalable business rules

• Accurate and reconciled financial data

• Documentation (technical functional)

• On-time project/module delivery