OneStream Techno Functional Consultant

Job Title: OneStream Techno-Functional Consultant

Location: 100% Remote (Canada/Mexico/Colombia)

Role Overview

The Techno-Functional Consultant serves as the primary architect and implementer of the OneStream CPM platform. You will bridge the gap between complex financial requirements and technical system configuration. This role requires following skill set: the ability to discuss consolidation logic or budget forecasting, and the technical proficiency to write the VB.Net rules and SQL queries that power those processes.

Core Responsibilities 1. Solution Architecture & Design

• Lead discovery workshops to translate financial business requirements (Close, Consolidation, FP&A, Sales Ops) into a scalable OneStream technical design.
• Architect the Cube and Dimension structures, utilizing Extensible Dimensionality to support both corporate-level reporting and granular business unit requirements.
• Design end-to-end Workflows, ensuring a seamless user experience for data collection and certification.

2. Technical Development & Implementation

• Write, debug, and optimize VB.Net Business Rules for complex financial logic (e.g., Cash Flow, Intercompany Eliminations, and Custom Translations).
• Configure OneStream Stage for ETL processes, including complex data connectors, SQL transformations, and derivative mapping.
• Build sophisticated Dashboards and Cube Views using parameters and formatting strings to provide "at-a-glance" insights for executives.

3. Financial Logic & Compliance

• Ensure the system adheres to GAAP and IFRS standards for financial consolidation and reporting.
• Implement Marketplace solutions (e.g., Account Reconciliations, People Planning, or Lease Accounting) and customize them to fit specific business needs.
• Lead the validation of financial data to ensure "one version of the truth" between the legacy ERP and OneStream.

4. Project Leadership

• Act as the technical lead during UAT (User Acceptance Testing), quickly resolving bugs and adjusting logic based on user feedback.
• Provide "Knowledge Transfer" to client admins, teaching them both the functional "how-to" and the technical "why" behind the system configuration.

Required Qualifications Functional Excellence

• Education: Bachelor's degree in Accounting, Finance, or a related field (CPA, MBA, or CMA preferred).
• Domain Knowledge: Minimum 3 5 years of experience in Financial Close & Consolidation or FP&A.
• Communication: Ability to explain technical constraints to finance stakeholders and financial needs to IT teams.

Technical Excellence

• Programming: Proficiency in VB.Net or C# (specifically within the OneStream Business Rule framework).
• Data Management: Advanced SQL skills for data extraction and performance tuning.
• Platform Experience: Hands-on experience with the OneStream Marketplace and Metadata management.
• EPM/CPM Background: Prior experience with legacy systems (Hyperion HFM/Planning, Tagetik, or Anaplan) is a significant plus.