Hyperion Subject Matter Expert (SME)

BLN24McLean, VA

Apply with Sonara

Automate your job search with Sonara.

Submit 10x as many applications with less effort than one manual application.¹

Reclaim your time by letting our AI handle the grunt work of job searching.

We continuously scan millions of openings to find your top matches.

Overview

Schedule

Full-time

Career level

Senior-level

Remote

Benefits

Health Insurance

Dental Insurance

Vision Insurance

Job Description

Job Title: Hyperion Subject Matter Expert (SME)Company: BLN24About Us: We find strength in teamwork-a better you is a better usBLN24 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.

BLN24 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, color, 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.

Automate your job search with Sonara.

Submit 10x as many applications with less effort than one manual application.

Apply with Sonara Apply manually