CIT Group Inc.

Systems Analyst - Hyperion/Essbase/VBA

Job ID
# Positions
Job Family
Information Technology - IT Development


Founded in 1908, CIT (NYSE: CIT) is a financial holding company with more than $65 billion in assets. Its principal bank subsidiary, CIT Bank, N.A., (Member FDIC, Equal Housing Lender) has more than $30 billion of deposits and more than $40 billion of assets. It provides financing, leasing and advisory services principally to middle market companies across a wide variety of industries primarily in North America, and equipment financing and leasing solutions to the transportation sector. It also offers products and services to consumers through its Internet bank franchise and a network of retail branches in Southern California, operating as OneWest Bank, a division of CIT Bank, N.A.


The Systems Analyst – Hyperion/Essbase/VBA will be primarily responsible for the maintenance and development of custom financial reports and input templates utilizing the Hyperion\Essbase reporting tools. These custom reports and templates utilize the SmartView addin and Visual Basic to provide users with automated tools for retrieving and loading data to our cubes. Secondary to this role, the position will be involved in the development of new Essbase cubes, as well as changes to existing cubes. In addition, the position will be participating in all phases of the build out of data interfaces to and from the cubes.


This role will require the ability to coordinate and facilitate design sessions with key Business Users to gather and document business/data requirements for new automated input templates and reports, or enhancements to existing ones. The individual in this position will also assist the system admins in the monitoring and running of daily and monthly processes, system maintenance and troubleshooting system issues.


Another key responsibility will be periodic status reporting to Management, as well as to Business and Team Leaders. The individual will also function as a “Team member” for any Hyperion related systems projects and User support.


This position would be ideal for an individual who has a well-rounded background that includes experience with SmartView and VBA, as well as a strong understanding of the overall Hyperion application.  Additional beneficial skills include familiarity with the PeopleSoft General Ledger application (vers 8.4) and knowledge of the Hyperion Planning module.


  • 3+ years experience creating Hyperion reports (Hyperion Vers or higher).
  • Solid experience with Excel and Visual Basic for Applications (VBA).
  • Strong experience with the entire Microsoft Office Professional Suite.
  • Strong experience using the SmartView Add-in tool and related API.
  • Proficiency in the Essbase Administrative (EAS) tools (outlines, security, calculations, load rules, etc.).
  • Exposure to Accounting and Finance concepts
  • Experience with Data Modeling and System Development Life Cycle.
  • Project Management experience including developing work-plans, managing multiple resource tasks, documenting, designing, testing and implementing both process & technical solutions.
  • Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment.
  • Strong communication, organizational and interpersonal competencies along with detail-oriented and problem solving skills in the technology arena.
  • Proficient in software documentation, from Design documents to User Procedures
  • Experience with application testing including the creation of test scripts and documenting test results.
  • Experience with SQL databases, JavaScript, HTML and SharePoint site administration would be a plus but are not required.


Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed