The Role
The Hyperion SME will lead the migration of legacy Oracle Hyperion reports to modernized BI platforms, ensuring ongoing analytics and stakeholder access, while also providing expert advice and maintaining documentation.
Summary Generated by Built In
Job Title: Hyperion Subject Matter Expert (SME)
Company: BLN24
About Us: We find strength in teamwork-a better you is a better us
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:
Required Qualifications:
Preferred Qualifications
What BLN24 brings to the Game:
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.
Company: BLN24
About Us: We find strength in teamwork-a better you is a better us
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) 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.
Required Qualifications:
- 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.
Preferred Qualifications
- 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 BLN24 brings to the Game:
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.
Top Skills
Bi Publisher
ETL
Oracle Business Intelligence Enterprise Edition
Oracle Hyperion Epm
SQL
Tableau
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
BLN24 is a digital creative agency that is an 8(a) minority-owned small disadvantaged business (SDB). We add value by merging our commercial and government experience to create award-winning solutions for clients with the most important missions globally. BLN24 is a first-class communication, marketing, and technology agency for federal agencies and Fortune 500 companies.
Founded by two former Booz Allen Hamilton employees, BLN24’s
industry-lead marketing and communications strategies along with
production and visual design has been on web and print advertisement
campaigns as well as television networks across the nation.
