OneStream Developer

Job Title:

OneStream Developer /

Lead 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