OneStream Software Developer

Minimum (Required): insert specific minimum skills for this Contract Position) Years Skills/Experience 6 Experience with general IT SDLC processes 6 Experience with Financial Reporting tools such as Hyperion or OneStream 4 Experience with OneStream to create Cube 4 Experience with OneStream to create a Dashboard Maintenance Unit, and Dashboard Groups Experience with OneStream to create financial statements through report books using OneStream ITSAC Level (1, 2, 3) (Required): DESCRIPTION OF SERVICES: (Required) TxDOT requires the services of [1] Software Developer hereafter referred to as Worker, who meets the general qualification of Software Developer 2 and the specifications outlined in this document. The OneStream Software Developer 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: Assist with 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) 4 Use Spreadsheet/Excel add-In to create reports within OneStream 4 Experience with OneStream to create a Dashboard Maintenance Unit, and Dashboard Groups 4 Experience with OneStream to configure different Data Adapter types ? Cube View and Cube View MD ? Method Query 4 Experience with OneStream to configure a BI Viewer Component ? Pivot, Chart, Treemap, and Pie Dashboard Items ? Mastering Filtering and Drill-Down ? Calculated Fields 4 Experience with OneStream to Load data into OneStream through file imports and data entry (Forms and Journals) 4 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 TERM OF SERVICE (Required): 12 mo. 2080 hrs. Note: Working overtime may be expected in order to meet tight deadlines. WORK HOURS AND LOCATION 8 a.m. to 5 pm., 6230 E Stassney Road Austin TX 78744 Work will be performed onsite in Austin, during normal business work hours. Candidate may be required to work evenings or weekends to meet business needs and deadlines. Working remotely is accepted in accordance with TxDOT's policies. If the resource is in the Austin area, current requirement is to be in the office a minimum of twice a week.