Location: 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.

Key Responsibilities

1. Application Development & Configuration

• 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

2. Financial Process Implementation

• 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

3. Data Integration & ETL

• 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

4. Performance Optimization & Troubleshooting

• Analyze and optimize:

• Business rules performance

• Data load times

• Cube calculation efficiency

• Troubleshoot:

• Data inconsistencies

• Workflow failures

• System performance bottlenecks

5. Testing & Deployment

• 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)

6. Leadership Responsibilities (Lead Role)

• 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

7. Stakeholder & Business Interaction

• 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

8. Governance & Best Practices

• Follow and enforce:

• Naming conventions

• Coding standards

• Documentation practices

• Ensure compliance with:

• Internal controls

• Financial regulations

• Maintain audit trails and system integrity

Required Skills

Technical Skills

• 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

Functional Knowledge

• Strong understanding of:

• Financial consolidation

• Close management processes

• Planning, budgeting, forecasting

• Financial reporting and analytics

Soft Skills

• 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

Qualifications

• 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)

Nice-to-Have Skills

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

• Knowledge of:

• Data warehousing concepts

• Power BI / reporting tools

• Exposure to Agile/Scrum methodologies

Key Deliverables

• Fully functional OneStream applications

• Optimized and scalable business rules

• Accurate and reconciled financial data

• Documentation (technical + functional)

• On-time project/module delivery