Hyperion Subject Matter Expert (SME)

BLN24-posted 3 months ago
Mclean, VA
11-50 employees
Resume
Match Score
Upload and Match ResumeTrack Jobs with Teal

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.

  • 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.
  • 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.
  • 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.
  • Generous medical, dental, and vision plans.
  • Remote working opportunities depending on projects.
  • Flexibility to balance quality work and personal lives.
Track Jobs with Teal

Job Search Resources

•
Resume Builder
•
Resume Examples
•
Cover Letter Examples

Tools

Career Hubs

Guides

Company

© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service