OneStream Solutions Consultant

Smart IT Frame LLC; Houston (TX); On-site; USD 83,000 - 152,000; Full time

Job summary

Smart IT Frame LLC seeks a OneStream Solutions Consultant to bridge Finance and IT, leading design, configuration, and support of OneStream solutions in Houston. This contract role covers FP&A, consolidation, and reporting with strong technical know-how.

You will configure workflows, data rules, and integrations (SAP S/4HANA, SAP ECC, data warehouses). Expect collaboration with Finance, SAP, Infrastructure, and vendor teams, plus training and governance support.

Qualifications

• 5+ years in EPM/CPM solutions.
• 2+ years hands-on OneStream experience.
• Experience integrating OneStream with SAP S/4HANA.
• Experience in utility, energy, manufacturing, or large enterprise environments.

Responsibilities

• Gather and document business requirements from Finance, Accounting, FP&A, and Reporting teams.
• Design and configure: Planning and Budgeting, Forecasting, Account Reconciliations, Cash Flow Reporting.
• Assist in metadata maintenance.
• Support month-end close and financial reporting processes.
• Lead SIT, UAT, and deployment activities.

Skills

OneStream

Data Management

Workflow Configuration

Cube View Development

VB.NET

Security Configuration

Reporting and Drill-Back

Tools

SQL

REST APIs

OData Services

Azure

SAP Integration

Job description

Job Title: OneStream Solutions Consultant

Location: Houston, TX (Onsite)

Work Type: Contract

Job Description:

A OneStream Solutions Consultant serves as the bridge between Finance and IT, leading the design, configuration, integration, and support of OneStream solutions. The role combines deep Financial Planning & Analysis (FP&A), Financial Consolidation, and Reporting expertise with strong technical knowledge of OneStream architecture, integrations, data management, and automation.

Key Responsibilities

Functional

• Gather and document business requirements from Finance, Accounting, FP&A, and Reporting teams.
• Design and configure:
• Planning and Budgeting
• Forecasting
• Account Reconciliations
• Cash Flow Reporting
• Assist in metadata maintenance.
• Support month-end close and financial reporting processes.
• Provide user training and business process guidance.

Technical

• Configure OneStream application workflows, and business rules.
• Develop and support:
• Data Quality rules
• Cube Views
• XF Business Rules
• Maintain integrations with:
• SAP S/4HANA
• SAP ECC
• Data warehouses
• Flat files
• APIs/OData services
• Troubleshoot performance and data issues.
• Support security roles and governance.

Project Delivery

• Lead SIT, UAT, and deployment activities.
• Coordinate with Finance, SAP, Infrastructure, and vendor teams.

Required Skills

OneStream

• OneStream Platform Administration
• Data Management
• Workflow Configuration
• Cube View Development
• Business Rules (VB.NET)
• Security Configuration
• Reporting and Drill-Back Capabilities

Finance

• FP&A
• Budgeting and Forecasting
• Management Reporting
• Intercompany Accounting
• Cash Flow Reporting

Technical

• SQL
• VB.NET
• REST APIs
• OData Services
• Data Integration
• Azure or Cloud Platforms
• SAP Integration Experience

Preferred Experience

• 5+ years in EPM/CPM solutions.
• 2+ years hands‑on OneStream experience.
• Experience integrating OneStream with SAP S/4HANA.
• Experience in utility, energy, manufacturing, or large enterprise environments.