ADI Global is looking for a Lead Hyperion Systems Administrator to manage and update the financial reporting functionality within Hyperion applications as well as facilitate the processes and deliverables during the financial close and planning periods. 

 

JOB DUTIES:

 

Administration & Operations

• Support the Financial Close consolidation and Planning/Budgeting processes for the Oracle EPM environment.

• Maintain HFM application metadata hierarchies, assist in the development, modification and testing of business rules through change management.

• Financial report understanding and experience - Build/ Enhance/Troubleshoot Financial Reports, Smartview Reports and Web Analysis as needed. 

• Enable Global Month End Closing process via HFM / FDMEE, supervise financial submissions for all locations, guide site Controllers on technical / process topics, and investigate data validation issues.

• Work with Internal and External Audit to meet all SOX financial system requirements

• Knowledge and understanding of US GAAP standards & financial concepts regarding P&L, Balance Sheet, Roll forwards, USD Overrides, Intercompany, Cash Flow, Foreign currency & USD reporting.

• Ability to develop and maintain Hyperion Essbase and Planning environments, including outlines, load rules, calculation Scripts, Business Rules, Partitions, Web forms, and Security.

• Serve as technical expert for Oracle Hyperion EPM AWS landscape and responsible for the Hyperion application infrastructure.

• Responsible for configuration, patching, backup, recovery, and performance tuning of Hyperion landscape.

​

Application Development

• Solid knowledge/hands on experience of HFM, FDMEE,:

• Managing metadata.           

• Rule enhancements (VB & Jython scripting) & development experience. 

• Edit and/or write Forms/Grids, IC reports.

• Set-up, manage and troubleshoot FDMEE mappings & processes.

• Maintenance of rule files and calc scripts, MaxL scripts and Perl scripts

• Shared Services security.

• Serve as SME for all application functionality, attributes, general design, usage, and best practices.

• Ability to develop test data, test scripts and execute comprehensive testing of integrated systems.

• Maintain and continuously upgrade her/his knowledge of Hyperion and Oracle technologies, finance, external competitive landscape, Audits/Sox etc.

• Strong understanding of Oracle RDMS, SQL and Unix Shell scripting languages

 

Training & Support

• Provide global technical support of Hyperion user base and oversee all Hyperion related reporting processes.  

• Train global user community, publish reference materials and training documentation. Establish user training agendas and provide targeted training sessions as needed.

• Ability to create, update, and review functional and technical documents along with administrative SOPs.

 

YOU MUST HAVE

• 5+ years of experience in Administrating/Managing HFM Consolidation Systems & FDMEE
• 5+ years of experience in Consolidation & Reporting
• 5+ years of experience in Hyperion Planning

 

WHAT'S IN IT FOR YOU 

• Medical, Dental, Vision, Commuter Benefit, Pet Insurance and 401k participation from Day 1 

• 12 paid holidays each year 

• Four weeks parental leave without using vacation time 

• Employee discounts on company products and other retail/service providers 

• Monday to Friday working hours - no weekends 

• Opportunity to progress within a global business 

 

Resideo Technologies has announced its intention to spin off ADI Global Distribution and establish it as a separate, publicly traded company. Under this plan, ADI will continue its role as a leading global wholesale distributor serving commercial and residential markets, while Resideo will retain its manufacturing and product-solutions business. Upon separation, both companies will operate independently to better serve their respective markets and customers. The spin-off is currently targeted for completion in the second half of 2026, subject to customary conditions.

Resideo is a $6.76 billion global manufacturer, developer, and distributor of technology-driven sensing and control solutions that help homeowners and businesses stay connected and in control of their comfort, security, energy use, and smart living. We focus on the professional channel, serving over 100,000 contractors, installers, dealers, and integrators across the HVAC, security, fire, electrical, and home comfort markets. Our products are found in more than 150 million residential and commercial spaces worldwide, with tens of millions of new devices sold annually. Trusted brands like Honeywell Home, First Alert, and Resideo power connected living for over 12.8 million customers through our Products & Solutions segment. Our ADI | Snap One segment spans 200+ stocking locations in 17 countries, offering a catalog of over 500,000 products from more than 1,000 manufacturers. With a global team of more than 14,000 employees, we offer the opportunity to make a real impact in a fast-growing, purpose-driven industry. Learn more at www.resideo.com.

At Resideo, we bring together diverse individuals to build the future of homes. Resideo is an equal opportunity employer. Qualified applicants will be considered without regard to age, race, creed, color, national origin, ancestry, marital status, affectional or sexual orientation, gender identity or expression, disability, nationality, sex, religion, or veteran status. For more information on applicable U.S. equal employment regulations, refer to the "EEO is the Law" poster, "EEO is the Law" Supplement Poster and the Pay Transparency Nondiscrimination Provision. Resideo complies with applicable equal employment laws in all countries where we do business. For more information on how we process your information in the job application process, please refer to Recruitment Privacy Notice. If you require a reasonable accommodation to apply for a job, please use Contact Us form for assistance.