OneStream Techno Functional Consultant

Skill:
One Stream Techno-functional Consultant

Exp-4+ Years

Notice-Immediate-30days

Location-Pune, Bangalore, Hyderabad & Kolkata

The Techno-Functional Consultant serves as the primary architect and implementer of the One Stream 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  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 One Stream 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  Business Rules for complex financial logic (e.g., Cash Flow, Intercompany Eliminations, and Custom Translations).
- Configure One Stream 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 One Stream.

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  or C# (specifically within the One Stream Business Rule framework).
- Data Management:
Advanced SQL skills for data extraction and performance tuning.
- Platform

Experience:

Hands-on experience with the One Stream Marketplace and Metadata management.
- EPM/CPM Background:
Prior experience with legacy systems (Hyperion HFM/Planning, Tagetik, or Anaplan) is a significant plus.