OneStream Developer in Santa Clara, CA (100% onsite)

Job Description Role Overview

The OneStream Developer / Lead is responsible for designing, developing, and supporting OneStream applications that power the organization's 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 (VB.NET-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:

  • VB.NET 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

• Bachelor's 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