What are the responsibilities and job description for the OneStream Developer / Lead - Santa Clara, CA - Fully Onsite position at United Software Group Inc?
Job Title: OneStream Developer / Lead
Location: Santa Clara, CA (100% onsite)
9 Months Contract
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:
- 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
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