United States  |  International

Careers

JOB TITLE: Finance Manager / Essbase Administrator

Job Responsibilities

Essbase Administrator

  •  Maintain end user security, including creating and deleting user accounts and creating and maintaining security filters and user groups/roles for Essbase
  • Update the Essbase database outline to be consistent with Lawson changes
  • Troubleshoot Essbase for system and performance issues; identify and resolve information flow and data integrity issues
  • Provide end user support for questions and issues related to the Essbase financial databases to include one-on-one assistance and group training
  • Work closely with IT regarding server maintenance, including planned and unplanned outages, system patches and upgrades, restoration of databases from backup files, etc.
  • Conceptualize and build, with the assistance of outside consultants, Essbase cubes with proper documentation
  • Build ad hoc reports using Hyperion Essbase Smartview and the Excel Addin

 

Financial Planning and Analysis

 

  • Prepare monthly consolidated financial reports and P&L narratives for management and internal team
  • Act as a resource between the brand finance staff, Focus  IT and Technisource to assist with the administration of the FICS sales reporting system
  • Perform ad hoc financial analysis as required
  • Provide information to management by assembling and summarizing data; making presentations of findings, analyses, and recommendations
  • Assist in the preparation of annual budgets and quarterly forecasting, analyzing variance to budgets/forecasts
  • Upload budgets and forecasts to Essbase financial reporting software (using Smart View and/or Excel Addin)
  • Document processes and assist in systems/process implementations as required
  • Participate in special projects and perform other job related duties as assigned

 

Qualifications

  •  Required: Bachelor’s degree with a major in Finance or Accounting from an accredited college or university
  • Master’s degree preferred
  • 5+ years progressive experience in financial planning & analysis and reporting roles
  • Proven Essbase system administration ability

 Skills & Knowledge

  • Advanced MS Excel and financial modeling skills including pivot tables and look ups
  • Ability to build, organize and retrieve reports using Hyperion Essbase/Smartview financial reporting application
  • Proficiency in Essbase Administrative tools (calc scripts, security, load rules, MaxL scripting, etc)
  • A working knowledge of relational database structures and the ability to query data using SQL
  • Knowledge of Lawson accounting (or similar) general ledger module
  • Demonstrated experience building financial models
  • Strong understanding of Income Statement, Balance Sheet and Statement of Cash Flows
  • Ability to effectively interact and follow up within the group and the company
  • Ability to set priorities and organize work to meet strict deadlines
  • Excellent interpersonal and communication skills (written and oral)
  • Ability to manage and prioritize multiple tasks in a dynamic environment
  • Demonstrated ability to work independently as well as in a collaborative team environment
  • Demonstrated strong analytical and problem solving skills
  • Must be able to work additional hours as needed

 

Apply Now