Hyperion Subject Matter Expert Jobs

BLN24

Location:
United States, McLean

Category:
IT - Administration

Contract Type:
Not provided

Salary:

Not provided

Save Job

Apply Position

Job Description:

The Hyperion SME will serve as the technical authority supporting USDA Rural Development’s Hyperion Dependency Removal (HDR) Project under the DWITT BPA. This individual will lead the migration of legacy Oracle Hyperion Enterprise Performance Management (EPM) reports and infrastructure to modernized business intelligence platforms, ensuring continuity of reporting, analytics, and stakeholder access.

Job Responsibility:

Provide expert-level knowledge of Hyperion EPM architecture, reporting, and data integration
Conduct analysis of legacy Hyperion reports (~1,000 reports supporting ~3,500 stakeholders) and identify technical dependencies, including data connections, tables, and queries
Lead the conversion and consolidation of reports into USDA’s Modernized Technology Platforms (MTPs) Tableau, Oracle Business Intelligence Enterprise Edition (OBIEE), and BI Publisher
Design, develop, and validate data models to support streamlined reporting and enable parameter-driven, ad hoc reporting for stakeholders
Collaborate with USDA’s Data Engineering Branch (DEB) and business analysts to prioritize reports, define migration strategies, and support Agile delivery
Conduct User Acceptance Testing (UAT) with business stakeholders
obtain approvals prior to production deployment
Support the decommissioning of Hyperion servers and reports once dependencies are removed
Maintain detailed technical documentation (report specifications, SQL queries, MTP mapping, new report URLs) in SharePoint/Confluence
Provide ongoing technical advice and best practices to ensure successful transition and long-term sustainability

Requirements:

10+ years of hands-on experience with Oracle Hyperion EPM (reporting, metadata, administration)
7+ years of experience with BI platforms (Tableau, OBIEE, BI Publisher) and data migration
Strong SQL, data modeling, and ETL expertise
5+ years’ experience in Agile/SAFe delivery, sprint planning, and backlog management
Demonstrated ability to document complex technical processes for both technical and non-technical audiences
Excellent communication skills to interface with technical teams, business users, and federal stakeholders

Nice to have:

Prior federal government contracting experience, especially with USDA or related financial reporting/loan programs
Experience leading large-scale system decommissioning and modernization projects
Proficiency with collaboration tools such as Jira, Confluence, and SharePoint

What we offer:

Generous medical, dental, and vision plans
Opportunity to work in different sectors
Remote working opportunities

Additional Information:

Job Posted:
December 06, 2025

Work Type:

Remote work

View All Jobs In This Company

Job Link Share:

Hyperion Subject Matter Expert