One Stream Administrator in Southfield, MI at Auria

Date Posted: 7/30/2020

Job Snapshot

Job Description

Job summary

The OneStream System Administrator is responsible for maintaining all functional aspects of the OneStream consolidation system.

Job Responsibilities:

The Consolidation System Administrator will be responsible for all aspects of the monthly and year end close function through interaction with US & other global entities. This position will play a vital role in supporting the annual budget & five plan process, which involves heavy reliance on the consolidation software and related templates.  

Position responsibilities include but are not limited to:  

  • Maintenance and administration of the OneStream application
  • Provide second and third level support as required for global users.
  • Coordination of month-end and year-end close procedures
  • Maintenance of user security and access rights, organization and entity structures, chart of accounts, mapping translations, reports and book sets, reporting categories for actual, budget, forecast, 5 year plan, etc. 
  • Creating excel templates linked to OneStream, to load data related to budget & long-range plans 
  • Preparation of program and operations documentation, implementation of solutions and delivery of training as necessary
  • Maintenance of Treasury published exchange rates
  • Maintenance of meta data structure in the OS software
  • Assist with support and deployment of ERP systems
  • Gather functional and technical requirements for portfolio of approved projects; document functional designs, test cases and results.
  • Travel – approximately 20%, including international
  • Provide after-hours support as required


Job Requirements


  • Bachelor’s degree in Information Technology or business related field
  • Minimum of 3+ years consolidation administration experience OneStream consolidation software (preferable) or any other consolidation software like HFM, Hyperion etc.
  • Proficient knowledge of VB.Net
  • Understanding of and ability to change basic logics in the consolidation system
  • Excellent working knowledge with MS office suites, Excel, PowerPoint & Word
  • Strong attention to detail
  • Strong organizational skills and referencing of work
  • Curiosity to question processes and drive change


  • Excellent verbal and written communication skills
  • Excellent analytical and organizational skills
  • Ability to work independently with little supervision
  • Self-motivated
  • Attention to detail and strong analytical and problem solving skills
  • Open, global mindset, capable of working on cross functional projects

Not ready to Apply?

If you’re interested in career opportunities, but not ready to apply, join our Talent Network to stay connected to us and receive updates on the latest job opportunities and company news.