HFM Decommissioning Lead (Oracle Hyperion Financial Management)

Remote • Posted 15 hours ago • Updated 15 hours ago
Contract Independent
Contract W2
2 Months
No Travel Required
Remote
$70 - $80/hr
Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

  • HFM Decommissioning
  • SQL

Summary

Mandatory Skills - Oracle Hyperion HFM (8+ yrs hands-on: application design, metadata, rules, consolidation, intercompany, journals, security); HFM data & metadata extraction (HFM extracts, Smart View, FDMEE/Data Management, database-level); end-to-end EPM migration/archival/decommissioning; financial close & consolidation; data validation & reconciliation; SOX/audit & data retention; SQL & data modeling; client-facing Finance/IT leadership communication

Nice to Have Skills - Archival/reporting platforms (Azure, Databricks, Snowflake, SQL Server, Oracle DB, Power BI); Oracle EPM Cloud (FCCS/Planning) or OneStream; Oracle licensing/support-contract termination; CPG or large multinational consolidation; CPA or Oracle EPM certification

Start Date – ASAP

 

Project duration – 8 weeks

Working Hours - Standard US business hours, full-time (40 hrs/week); overlap with Pacific Time

JD - Current-State Assessment

•     Assess the current HFM environment, including applications, versions, environments (Prod/Non-Prod), and infrastructure.

•     Inventory integrations, upstream/downstream dependencies (e.g., FDMEE/Data Management, EPMA, Smart View, Financial Reporting, ERP sources), and any residual jobs or connections.

•     Profile data volumes, years/periods/scenarios held, and historical usage patterns, including who still accesses HFM and why.

2. Data & Metadata Retention Definition

•     Define the historical financial data to be retained (scenarios, years, periods, entities, accounts, currencies, intercompany, journals).

•     Define the metadata required to interpret the data correctly: hierarchies, dimensional structures, member properties, alternate hierarchies, and consolidation/translation rules.

•     Identify other artifacts to preserve, such as business rules, member lists, journal templates, security classes, FR reports, and process-control/audit history.

3. Archival Approach & Recommendation

•     Evaluate and recommend an archival target outside HFM (e.g., relational database, cloud data platform, or data lake with a reporting layer) that is sustainable and cost-effective.

•     Design the target data model so archived data stays usable for reporting and lookups, including flattened hierarchies and point-in-time metadata.

•     Lead extraction of data and metadata from HFM and loading into the archive.

4. Post-Retirement Finance Access

•     Define how Finance users will access historical information after HFM is retired, including required reports, standard extracts, and a self-service or request-based retrieval process.

•     Gather and prioritize reporting needs with Finance stakeholders and design the replacement reports/extracts.

5. Validation & Reconciliation

•     Design and run a validation and reconciliation framework comparing archived data against HFM (balances, consolidated results, intercompany, and journals) before shutdown.

•     Document reconciliation results, resolve variances, and obtain formal Finance sign-off.

6. Audit, Retention, Security & Compliance

•     Identify record-retention, SOX/audit, security, and compliance requirements with Clorox Audit, Legal, and InfoSec.

•     Ensure the archive enforces the right access controls, retention periods, and audit trail.

7. Decommissioning Plan & Execution

•     Build and run the decommissioning plan covering application, infrastructure, integrations, licenses, user access, and operational dependencies (monitoring, backups, support contracts).

•     Coordinate cutover, read-only/freeze periods, final backups, and server/environment shutdown with Clorox IT.

•     Support license and support-contract termination planning.

8. Documentation, Knowledge Transfer & Engagement Management

•     Produce documentation of the archive design, data dictionary, retrieval procedures, and reconciliation evidence.

•     Deliver knowledge transfer to Clorox Finance and IT support teams.

•     Contribute to the proposal: approach, scope, timeline, resource model, assumptions, and cost estimate. Then track progress, risks, and status reporting against it.

Key Deliverables

•     HFM current-state assessment report (environment, integrations, dependencies, volumes, usage)

•     Data and metadata retention matrix

•     Archival approach recommendation and target-state design

•     Historical data access model, with report/extract specifications

•     Validation and reconciliation plan, results, and Finance sign-off

•     Audit, retention, security, and compliance requirements summary

•     Decommissioning plan and execution checklist

•     Documentation package and knowledge transfer sessions

Required Qualifications

•     8+ years of Oracle Hyperion EPM experience, with deep hands-on HFM expertise (application design, metadata, rules, consolidation, intercompany, journals, security).

•     Proven experience extracting HFM data and metadata at scale (e.g., HFM extracts, Smart View, FDMEE/Data Management, database-level extraction).

•     Experience leading at least one EPM migration, archival, or decommissioning project end to end.

•     Strong understanding of financial close and consolidation processes, and the ability to work directly with Corporate Finance and Controllership.

•     Experience designing data validation and reconciliation frameworks for financial data.

•     Working knowledge of SOX controls, audit support, and data-retention requirements.

•     Strong SQL and data modeling skills.

•     Excellent communication skills, and experience leading client-facing workstreams and presenting to Finance and IT leadership.

Preferred Qualifications

•     Experience with modern archival/reporting targets such as Azure, Databricks, Snowflake, SQL Server, Oracle DB, or Power BI.

•     Exposure to Oracle EPM Cloud (FCCS/Planning) or OneStream, and to coexistence or migration scenarios.

•     Familiarity with Oracle licensing and support-contract termination considerations.

•     Consumer packaged goods (CPG) or large multinational consolidation experience.

•     Bachelor’s degree in Accounting, Finance, Information Systems, or a related field. CPA or Oracle EPM certification a plus.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: PTPQGQPbcJOWzmY
  • Position Id: 9143411
  • Posted 15 hours ago
Contact the job poster
KT

Kyper Tech

Recruiter @ Kyper Technologies

Create job alert
Never miss an opportunity! Create an alert based on the job you applied for.