OneStream Developer / Lead

BN Associates Inc

NULL, CA

JOB DETAILS
SALARY
$50–$55
SKILLS
Acceptance Testing, Accounting, Accounting Close, Accounting Consolidation, Accounting Standards and Regulations, Analysis Skills, Application Programming Interface (API), Automation, Best Practices, Budget Management, Business Processes, Code Reviews, Communication Skills, Computer Science, Data Management, Database Extract Transform and Load (ETL), Dimensional Modeling, ERP (Enterprise Resource Planning), Finance, Financial Analysis, Financial Planning and Analysis (FP&A), Financial Reporting, Forecasting, Hyperion, Identify Issues, Integration Testing, Leadership, Mentoring, Oracle, Performance Tuning/Optimization, Power BI, Product Testing, Production Support, Project Tracking, Requirements Management, SAP BusinessObjects Planning and Consolidation (BPC), SAP ECC (fka SAP R/3 and SAP ERP), Software Administration, System Integration (SI), System Test, Team Lead/Manager, Team Player, Technical Leadership, Technical Writing, Time Management, Validation Testing
LOCATION
NULL, CA
POSTED
2 days ago

Role - OneStream Developer / Lead

Location- Santaclara CA (Day 1 onsite)

Duration - Long Term

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

Best Regards,

Satish Adari

Tel:703-381-6498

E-Mail: Satish.a@bnassociates.net

BN Associates Inc.,

13873 Park Center Rd Suite # 187, Herndon VA 20171

"Certified SBA 8(a), EDWOSB, WOSB, WBE and MBE"

About the Company

B

BN Associates Inc