Hyperion Subject Matter Expert (SME)
BLN24 is an award-winning Management Consulting Firm that supports the U.S. Federal Government in successfully achieving their mission and goals. Our service and solutions delivery start with understanding each client’s end-state, and then seamlessly integrating within each Agency’s organization to improve and enhance strategic and technical operations and deployments. Position Overview:
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. Key Responsibilities:
- 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), 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 (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.
BLN24 benefits are game changing. We like our team to play hard and that means they need to be taken care of — physically, financially, and emotionally. We make sure to keep them in the game by giving them access to generous medical, dental, and vision plans.
- You can join one of the fastest growing companies headquartered in the Washington DC Metro Area. We give you the opportunity to work in different sectors, so you have the chance at variety while maintaining stability.
- Flexibility at BLN24 allows each individual the opportunity to balance quality work and their personal lives. Depending on projects, we allow remote working opportunities so you can always be in the game no matter where you call home.
Recommended Jobs
Senior Director, Nat'l Intelligence BD — Hybrid
A leading technology solutions provider is seeking a Business Development Senior Director to lead growth in the Intelligence Community. This role involves identifying new business opportunities, devel…
Assistant Manager
Rita's Italian Ice amp; Frozen Custard is looking for a full-time or part-time Assistant Manager for its Vienna (and Leesburg and Chantilly) location. The positions offer a positive, fun work environm…
1586 - Project Manager
Sigma Defense is seeking a Project Manager to provide the required support to the Capability Development and Innovation (CD&I) division within the Secretariat for Special Operations under the Off…
Cybersecurity Engineer, Contract Manager
Cybersecurity Engineer, Contract Manager Location: 100% On-site – Arlington, VA Work Hours: 0900 – 1700 Company: Nationwide IT Services, Inc. (NIS) Clearance Required: Active Secret Cle…
Deputy Program Manager
Ops Tech Alliance (OTA) is seeking a Deputy Program Manager to assist the FASTC PM managing the Contractor processes that enable performance under the contract and subordinate task orders. The DPM wi…
MACHINE OPERATOR (Harrisonburg)
As a Fortune 500 company, Packaging Corporation of America (PCA) is an ideas and solutions company. Our corrugated packaging business seeks to be the leader in helping our customers large and small p…
Pain Territory Business Manager, Fairfax, VA
**Job Description****General Summary:**The Pain Territory Business Manager (TBM) is responsible for establishing and maintaining relationships with Health Care Professionals (HCPs) to promote the safe…
Senior Manager, Continuous Improvement
Led by Rodolphe Saadé, the CMA CGM Group, a global leader in shipping and logistics, serves more than 420 ports around the world on five continents. With its subsidiary CEVA Logistics, a world leader…
DRIVERS WANTED - CDL & NON-CDL - MULTIPLE POSITIONS AVAILABLE
DRIVERS WANTED – CDL & NON-CDL – MULTIPLE POSITIONS AVAILABLE LOCAL, REGIONAL & OTR OPPORTUNITIES – IMMEDIATE OPENINGS Looking for better pay, better lanes, or a better company? We work with mu…
Power Distribution & Make Ready Designer (Remote) (Roanoke)
Description: Power Distribution & Make Ready Designer Overhead Utility Pole Design Joint-Use Engineering NESC-Compliant Make-Ready Work Location: Roanoke, VA (Remote) Are you an experien…