Hyperion Subject Matter Expert; SME

Job Title

Hyperion Subject Matter Expert (SME)

BLN
24

We find strength in teamwork— a better you is a better us. BLN
24 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.

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 modernised 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 Modernised 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 prioritise 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 modelling, 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 programmes.
• Experience leading large‑scale system decommissioning and modernisation projects.
• Proficiency with collaboration tools such as Jira, Confluence, and SharePoint.

BLN
24 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 BLN
  24 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.

BLN
24 is an Equal Opportunity Employer. We believe people are our strength and understand diverse talents are key to our success. We are an equal‑opportunity employer and place a high value on diversity and inclusion at our company. We do not discriminate on the basis of any protected attribute, including race, religion, colour, national origin, gender, sexual orientation, gender identity, gender expression, age, marital or veteran status, pregnancy or disability, or any other basis protected under applicable law.

In accordance with applicable law, we make reasonable accommodations for applicants’ and employees’ religious practices and beliefs, as well as any mental health or physical disability needs.