Senior Hyperion Developer

Freddie Mac
McLean, VA
Sep 06, 2019
Sep 13, 2019
Full Time
If you are a confident, poised, self-motivated and creative professional with a passion for communications and a belief that good communication is vital to driving change, we are your next destination employer! Apply to join us, the Data Analytics and Reporting Tools RFSO team! As a Senior Developer, you will be a part of the Hyperion Support team that will work on critical Freddie Mac Financial Budgeting and Forecasting applications. You will be engaging with a project team that's comprised of business, analysis, testing, and infrastructure partners, all working together to enhance the capabilities of different Hyperion Applications

Your work falls into two primary categories:

Software Development

  • Understand Business Requirements, participate in Requirements Analysis, design applications based on System Requirements and Architecture, prototype if necessary, develop, unit test and deploy the application.
  • Ability to develop Essbase applications and multi-dimensional databases from scratch using BSO and ASO.
  • Strong experience in analyzing, designing, updating, testing and migrating Essbase cubes in different environments and also proficient in performance tuning and optimization of Essbase applications.
  • Proficient in writing calculation scripts, business rules, Planning forms, Hyperion Financial Reports and automating Essbase cubes using MaxL, MDX, report scripts and load rules,
  • Solid understanding of Oracle EPM platform and different EPM component dependencies
  • Create and maintain Hyperion reports as needed to ensure reports are standardized and developed for optimum performance and data integrity that supports audits and other data needs.

Application Support
  • Research and investigate data discrepancies and provide data validation reports
  • Perform data loads/exports, including data validation and consolidation of data; this includes performing month-end close responsibilities.
  • Maintain metadata in Hyperion Essbase and Planning
  • Design and administer the security in the Hyperion environment.
  • Provide technical assistance by responding to inquiries regarding errors, problems, or questions with Hyperion.
  • Perform troubleshooting for Hyperion end users by evaluating problem situations in depth, arriving at independent conclusions leading to problem resolution and documentation.
  • Develop and document procedures pertaining to Hyperion systems applications and processes
  • Support ongoing financial processes such as annual budgeting, forecasting, closing, analysis, reporting, etc


  • 5+ years hands on technical experience with Hyperion Enterprise Performance Management Suite of products.
  • Solid Experience in Analysis, Design, Development and Deployment of Hyperion Planning/Essbase, Financial Reports, Smart View.
  • Strong technical skills including writing/creating calculation scripts, business rules, MAXL automation scripts, load rules, report scripts, web forms, financial reports
  • Expertise in RDBMS,PL/SQL, Datawarehousing/ETL solutions.
  • Strong analytical and complex problem-solving skills.
  • Solid experience using MS Office with an expert level in Excel.
  • Excellent communication skills and personality - we serve users in many countries around the work and in every functional area - excellent verbal and written communication skills and versatile personality is required.
  • A dedication for high quality service and end-product for our users.
  • A desire to always look for alternative and better ways to solve problems and provide solutions.
  • The ability to meet deadlines and prioritize competing deliverable.

Key to Success in this Role
  • Works under minimal supervision.
  • Able to provide technical guidance to the team.
  • Good communication and team player.
  • Strong written and oral communications skills.
  • Proactive in nature with customer satisfaction as primary goal.
  • Innovative in providing solutions, likes to take on challenges with calculated risk.
  • Quick learner of new technologies and tools.
  • Not a just developer, but a developer with a mindset to think holistically to build a reliable, flexible, and well performing system.

Top 3 Personal Competencies to Possess
  • Customer Focus - Engage with internal business partners to learn and deliver on their needs.
  • Drive for Execution - Focus on results that meet the business and corporate needs and moves the company to its future desired stateGrowth and Development - Know or learn what is needed to deliver results and successfully compete

Preferred Skills

Preferred Skills
  • Functional understanding of Accounting, Finance, and Planning & Budgeting
  • Finance knowledge - background in Finance and an understanding of the B/S and P&L
  • Experience with migration of on-premise Essbase solutions to Oracle Essbase cloud a big plus

Today, Freddie Mac makes home possible for one in four home borrowers and is one of the largest sources of financing for multifamily housing. Join our smart, creative and dedicated team and you'll do important work for the housing finance system and make a difference in the lives of others. Freddie Mac is an equal opportunity and top diversity employer. EOE, M/F/D/V.

Similar jobs