OneStream Consultant
Job Location:
Job Location:
Chicago, IL - USA
Monthly Salary:
Not Disclosed
Monthly Salary:
Posted on:
3 hours ago
Posted on:
Vacancies:
1 Vacancy
Vacancies:
Job Summary
Role Overview
We are seeking a highly skilled and motivated OneStream Consultant to join our Enterprise Performance Management (EPM) team. The ideal candidate will be a techno-functional expert with hands-on experience in OneStream XF capable of designing developing and optimizing financial consolidation and planning solutions.
Key Responsibilities
Solution Design & Development
o Design and implement OneStream CPM solutions for Financial Close Consolidation and FP&A.
o Build and maintain metadata cube views dashboards forms quick views and workflow profiles.
o Develop and manage business rules including:
o Custom Consolidations
o Intercompany Eliminations
o Currency Translations
o Cash Flow Automations
o Event Handler Rules
Integration & Automation
o Integrate OneStream with external systems (e.g. SAP Oracle) via REST APIs SQL or file-based ETL.
o Ensure data integrity perform reconciliation and troubleshoot integration issues.
Stakeholder Collaboration
o Work closely with finance and business stakeholders to gather requirements and deliver analytics solutions.
o Participate in Agile/SCRUM ceremonies and provide regular updates to senior management.
Testing & Documentation
o Support UAT system testing and issue resolution.
o Maintain documentation for solution design test scripts admin guides and training materials.
Support & Maintenance
o Provide ongoing support for OneStream applications including upgrades performance tuning and user training.
o Troubleshoot system errors and document enhancement opportunities.
Required Skills & Qualifications
2 implementation experience with OneStream on Consolidation and planning and 10-15 years in EPM platforms.
Proficiency in:
o OneStream Design Studio Cube Views Dashboards Workflow
o SQL C# Python
o Smart View and Excel Add-In
Strong understanding of financial consolidation principles and planning processes.
Experience with metadata management data reconciliation and audit compliance.
Familiarity with marketplace solutions like BI Blend Thing Planning People Planning.
Ability to translate finance business requirements into technical OneStream solutions.
Preferred Skills
Experience with other EPM tools like Hyperion Anaplan SAP BPC.
Knowledge of OneStream extensibility framework and Dashboard Extender Rules.
Prior participation in OneStream official training (e.g. Application Build for Consultants).
Exposure to Agile methodologies and sprint-based development.
Soft Skills
Strong analytical and problem-solving ability.
Effective communication and presentation skills.
Self-starter with a collaborative mindset and ability to work independently.
