Share this Job

Hyperion Planning (Oracle PBCS) Sr Administrator, Financial Systems Job

DATE: Aug 2, 2019

CITY: Columbus, OH, US, 43219

Company: DSW

Req #: 87360 
Location Name: Home Office, Columbus 
Department: Finance 


Designer Brands Inc. is one of North America’s largest designers, producers and retailers of footwear and accessories. The company operates a portfolio of retail concepts in nearly 1,000 locations under the DSW Designer Shoe Warehouse, The Shoe Company, and Shoe Warehouse brands and operates leased locations in the U.S through its Affiliated Business Group. Designer Brands designs and produces footwear and accessories through Camuto Group, a leading manufacturer selling in more than 5,400 doors worldwide. The Camuto Group owns licensing rights for the Jessica Simpson® footwear business, and footwear and handbag licenses for Lucky Brand® and Max Studio®. In partnership with a joint venture with Authentic Brands Group, Designer Brands also owns a stake in Vince Camuto®, Louise et Cie®, Sole Society®, CC Corso Como®, Enzo Angiolini® and others. More information can be found at


Job TitleHyperion Planning (Oracle PBCS) Sr Administrator, Financial Systems


Reports To:  Sr. Manager, Financial Systems


We are looking for a highly qualified and highly motivated Hyperion / PBCS EPM Administrator to work in the Financial Planning and Analysis group. The Hyperion / PBCS EPM Administrator will be responsible for customizing and administering our planning and budgeting system which supports the Finance organization at Designer Brands Inc.


Job Duties:

  • Development and administration of PBCS / Hyperion budget and planning tool in support of the Finance organization
  • Development duties include implementation of BSO/ASO cubes in PBCS environment
  • Administration of current state PBCS environment in support of budget / forecast models
  • End user training, report writing (Smartview, HFR) and support
  • Analyzing requirements, writing functional specifications, conducting tests, troubleshooting issues and interfacing with business users
  • Experience in creating and maintaining complex financial reports using Oracle reporting tools and other BI/Analytic tools.
  • Expanded role in business intelligence / analytics & data warehouse for future state reporting solution
  • Participate in the upcoming Oracle Cloud implementation project and integration with PBCS / reporting platforms
  • Deep functional and technical knowledge of financial systems and business processes, especially around planning, budgeting and forecasting
  • Oracle's Enterprise Planning & Budgeting Cloud Service (EPBCS) or Planning & Budgeting Cloud Service (PBCS) or Hyperion EPM tools (Hyperion Planning, Essbase, Smartview, FDMEE, EPM Automate, other) -> development and administrative capacity
  • Oracle's reporting tools including Smartview, Hyperion Financial Reports (HFR), OBIEE, BI Cloud, Oracle Analytic Cloud preferred
  • Experience in automating PBCS operations using EPM Automate and Data Management (FDMEE module)
  • Development experience including end-to-end implementation lifecycle to include requirements gathering, configuration, design, build, test and go-live stages
  • Able to work in a fast-paced environment with a diverse team; work independently under minimal supervision and flexible to participate as a team member in other projects regarding Oracle Cloud, ERP, BI/Analytics, Salesforce, other
  • Understanding of P&L, balance sheet and cash flow development across multiple industries
  • Ability to advise users on best practices in planning, budgeting and forecasting
  • BI / Analytic experience using packaged software (i.e. Tableau, Business Objects, Cognos, Other) preferred
  • Familiarity with data loading and integration tools
  • Ability to create and update existing calc scripts, business rules, web forms, and reports
  • Highly skilled in Microsoft Excel
  • Experience in creating and maintaining workflows (for Hyperion Planning and HFM)
  • Ability to manage user security roles and access
  • Ability to perform monthly metadata maintenance
  • Experience with Chart of Accounts (COA) setup and supporting the integration of acquisitions (both the company’s and the inherited systems)
  • Ability to perform ad hoc and routine financial close tasks
  • Experience in ensuring data accuracy and integrity
  • Excellent verbal and non-verbal communication skills
  • Understanding of best practices for business processes and technology
  • Advanced analytical, diagnostic and technical skills


The ideal candidate will have 3+ years of hands on technical experience with Hyperion Planning (Oracle PBCS), HFM (Oracle FCCS) and/or Essbase



Nearest Major Market: Columbus

Job Segment: System Administrator, Financial, Oracle, Database, ERP, Technology, Finance