Onestream Developer - Invovia

Title: OneStream Developer /Architect

Location:Austin TX 78744

Duration:12+ months

Onsite

DESCRIPTION OF SERVICES: (Required)

TxDOT requires the services of [1] Application Architect hereafter referred to as Worker, who meets the general qualification of Application Architect 3 and the specifications outlined in this document.

The OneStream Architect is contract position working closely with the Financial and Information Technology (IT) Division TxDOT Toll Department to support the delivery and maintenance of the FIN Forecasting Phase II project. The Phase II effort with expand the existing OneStream application, workstreams, cubes, reports, and exporting of data.

The worker's responsibilities and skills must include:

Leading the configuration of OneStream including but not limited to: Workflows, Data Sources, Transformation Rules, Business Rules and Calculations, Dashboards, Data Management Sequences, Cube / Master Data, System Security

Create and build OneStream applications, cubes, dimensions, calculation scripts using vb.net or C# and SQL, data management jobs, workflows, and transformation rules.

Create and Modify Cube Views and Dashboards in OneStream

Modify and update Financial Model, data management, and dashboard extender business rules.

Creates and maintains controls and analysis through financial modeling and presentation, as well as financial systems design in response to business requirements.

Creating workflows from new data files.

Mapping and Transformation of data for new workflows

The workers' responsibilities and skills must include:

WORKER SKILLS AND QUALIFICATIONS (Required)

Minimum (Required): insert specific minimum skills for this Contract Position)

Years Skills/Experience

8 Experience with general IT SDLC processes

8 Experience with Financial Reporting tools such as Hyperion or OneStream

6 Experience with OneStream to create Cube

6 Experience with OneStream to create a Dashboard Maintenance Unit, and Dashboard Groups

Experience with OneStream to create financial statements through report books using OneStream

6 Use Spreadsheet/Excel add-In to create reports within OneStream

6 Experience with OneStream to create a Dashboard Maintenance Unit, and Dashboard

Groups

6 Experience with OneStream to configure different Data Adapter types

Cube View and Cube View MD

Method Query

6 Experience with OneStream to configure a BI Viewer Component

Pivot, Chart, Treemap and Pie Dashboard Items

Mastering Filtering and Drill-Down

Calculated Fields

6 Experience with OneStream to Load data into OneStream through file imports and data entry (Forms and Journals)

6 Experience with OneStream to refine the financial model in the application through Member Formulas

Preferred (Optional): insert specific preferred skills for this Contract Position)

Years Skills/Experience

OneStream Training Credentials: Designing an Application, Implementing, and Building Basic Reports

OneStream Training Credentials: Building Basic Dashboards

OneStream Training Credentials: Application Build for Administrators