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
Sales Development Representative (SDR - Software - Saas)
About Recite Me In today’s digital age, we believe everyone should be able to access web content in a way that works for them. Our mission is to make the online world accessible for all. And we…
Attorney | Workers' Compensation | Hybrid | 148405
Mission Recruiting is partnering with a respected regional defense firm seeking a Workers’ Compensation Defense Associate ready to take ownership of a full litigation caseload. This is a growth-drive…
Front of House Team Member - Old Town
At Call Your Mother we believe that great food is made even better with amazing service and having fun together. CYM is a neighborhood bagel shop and deli with locations in the DC area and Denver, …
IT Project Manager / Analyst SETA
Position Title: IT Program Analysis / Project Management Clearance:TS/SCI Position Description: As an IT Program Analyst, your pivotal role involves providing essential support and analysis to ens…
Veterinarian - General Practice
Gunston Animal Hospital in Lorton, VA is looking for an Associate Veterinarian to join our team! ***$20k Sign-On, $10k Retention, $2k Relocation, $2k Lifestyle Incentive*** ***20 PTO Days,…
Junior developer
Job Family *: * SAAS/PAAS/Cloud Consulting Travel Required *: * Up to 25% Clearance Required *: * None What You Will Do *: * We are looking for a hands-on softw…
Client Service Coordinator
Full job description Are you an experienced Client Service Representative looking for a positive, team-oriented workplace where you can grow your career? Centralia Animal Hospital in Chester, VA, …
Dentist
We are searching for an enthusiastic and highly skilled dentist to join our practice for 3-4 days/week. We service our patients in a first-class facility with a focus on delivering the highest quali…
Physician Leader, Primary Care - $300k+ in Base + Bonus & $50k Retention
Overview: $300k+ includes Base Comp and Quality Bonus. Plus a $50k Retention Bonus Full-time, Monday - Friday, no weekends or evenings. As a Physician Leader, you will have clinical oversight of…