Hyperion Smart View Coordinator ( Financial Reporting )

7 days left

Washington D.C
Feb 09, 2021
Mar 04, 2021
Full Time
*** Please note, this is not a developer position.

Metro's Capital Improvement Program invests in the improvement and maintenance of the critical infrastructure and assets that enable the delivery of safe, reliable, and efficient Metrorail, Metrobus, and MetroAccess services. The approved program encompasses hundreds of projects and billions of dollars each year. This is an exciting opportunity to join the team that manages the finances of Metro's capital program. Metro is seeking a candidate who has a current experience as a "power-user" of Hyperion SmartView. The incumbent will support the management of capital program expenditures and funding by creating and maintaining SmartView reporting templates, data, and reporting data hierarchies that enable program managers and analysts to quickly locate and analyze financial data for purposes of budgeting, forecasting, funding, and managing capital projects. The incumbent will be accountable for the integrity of data and template functionality that supports capital program management. Work will be primarily in Hyperion SmartView and will require collaboration with IT resources to ensure dimensions, their members and reporting data structures are accurately maintained for SmartView reporting. The incumbent will support any ongoing and periodic upgrades, patches, and user acceptance testing for Hyperion changes impacting the capital program. PeopleSoft Financials experience is a plus. Advanced MS Excel skills are preferred.


  • Bachelor's degree in Information Systems, Business Administration or Accounting

  • Five or more (5+) years of experience with reporting tools (e.g. Smart View, Hyperion Financial Reports, OBIEE or equivalent) to include, three or more (3+) years of application development or administration experience and;
  • Three or more (3+) years of experience with Budgeting, Forecasting and Financial Reporting applications

  • N/A

  • N/A

Medical Group:

Satisfactorily complete the medical examination for this position, if required. The incumbent must be able to perform the essential functions of this position either with or without reasonable accommodations.


The Hyperion Administrator, Capital Planning develops reports and templates using the Smart View functionality of the Hyperion Planning application, including the creation and maintenance of capital budgets, forecasts and analysis. The incumbent manages month end, quarterly and year-end financial and managerial reporting processes from a system power user perspective, providing customer support as needed and ensures timely and accurate data submissions and management of process flows.

Essential Functions
  • Partners with Capital Budgeting team to define requirements of planning and analysis tools in Smart View and work with IT team to development, design, test and implement other technical solutions as needed. Provides coordination and supports forecast processes, as well as assists business unit planners with completing their forecasts and budgets.
  • Works with all key stakeholders to update, recommend and develop practices for more consistent and efficient process development and maintenance of budgets, forecasts, procurements, long-range capital plans and other Hyperion templates.
  • Prepares all Hyperion applications for business activities including scenario preparation, loading data files, running calculation scripts, reconciling and verifying data, trouble-shooting, implementing enhancements, and assisting with end-user reporting.
  • Troubleshoots production-level problems and resolves simple to highly complex technical issues related to Hyperion Smart View applications. Coordinates with IT resources as required to resolve system issues and minimize downtime.
  • Ensures integrity of budget, forecast, and actual data loaded to Hyperion for use in month-end reports and analysis. Works to create and improve business and operational processes.
  • Develops/revises user training materials and conduct training as necessary to support end-users of Smart View templates used by capital program managers. Participates in the monthly and annual Financial Close to provide support with report writing, query development and running the monthly interim and year-end reports.

Other Functions
  • May conduct project worksite visits to verify and report on status of program/project activities

The essential duties listed are not intended to limit specific duties and responsibilities of any particular position. Nor is it intended to limit in any way the right of managers and supervisors to assign, direct and control the work of employees under their supervision.

Evaluation Criteria

Consideration will be given to applicants whose resumes demonstrate the required education and experience. Applicants should include all relevant education and work experience.

Evaluation criteria may include one or more of the following:
  • Skills and/or behavioral assessment
  • Personal interview
  • Verification of education and experience (including certifications and licenses)
  • Criminal Background Check (a criminal conviction is not an automatic bar to employment)
  • Medical examination including a drug and alcohol screening (for safety sensitive positions)
  • Review of a current motor vehicle report


WMATA is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other status protected by applicable federal law.

This posting is an announcement of a vacant position under recruitment. It is not intended to replace the official job description. Job descriptions are available upon confirmation of an interview.

Similar jobs