Hyperion Subject Matter Expert (SME)

McLean, VA
Contracted
Technology
Experienced
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:
  • 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.
 
Share

Apply for this position

Required*
We've received your resume. Click here to update it.
Attach resume or Paste resume
Attach resume as .pdf, .doc, .docx, .odt, .txt, or .rtf (limit 5MB) or Paste resume

Paste your resume here or Attach resume file

To comply with government Equal Employment Opportunity and/or Affirmative Action reporting regulations, we are requesting (but NOT requiring) that you enter this personal data. This information will not be used in connection with any employment decisions, and will be used solely as permitted by state and federal law. Your voluntary cooperation would be appreciated. Learn more.
Invitation for Job Applicants to Self-Identify as a U.S. Veteran
  • A “disabled veteran” is one of the following:
    • a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or
    • a person who was discharged or released from active duty because of a service-connected disability.
  • A “recently separated veteran” means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.
  • An “active duty wartime or campaign badge veteran” means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.
  • An “Armed forces service medal veteran” means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.
Veteran status


Voluntary Self-Identification of Disability
Voluntary Self-Identification of Disability Form CC-305
OMB Control Number 1250-0005
Expires 04/30/2026
Why are you being asked to complete this form?

We are a federal contractor or subcontractor. The law requires us to provide equal employment opportunity to qualified people with disabilities. We have a goal of having at least 7% of our workers as people with disabilities. The law says we must measure our progress towards this goal. To do this, we must ask applicants and employees if they have a disability or have ever had one. People can become disabled, so we need to ask this question at least every five years.

Completing this form is voluntary, and we hope that you will choose to do so. Your answer is confidential. No one who makes hiring decisions will see it. Your decision to complete the form and your answer will not harm you in any way. If you want to learn more about the law or this form, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

How do you know if you have a disability?

A disability is a condition that substantially limits one or more of your “major life activities.” If you have or have ever had such a condition, you are a person with a disability. Disabilities include, but are not limited to:

  • Alcohol or other substance use disorder (not currently using drugs illegally)
  • Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, HIV/AIDS
  • Blind or low vision
  • Cancer (past or present)
  • Cardiovascular or heart disease
  • Celiac disease
  • Cerebral palsy
  • Deaf or serious difficulty hearing
  • Diabetes
  • Disfigurement, for example, disfigurement caused by burns, wounds, accidents, or congenital disorders
  • Epilepsy or other seizure disorder
  • Gastrointestinal disorders, for example, Crohn's Disease, irritable bowel syndrome
  • Intellectual or developmental disability
  • Mental health conditions, for example, depression, bipolar disorder, anxiety disorder, schizophrenia, PTSD
  • Missing limbs or partially missing limbs
  • Mobility impairment, benefiting from the use of a wheelchair, scooter, walker, leg brace(s) and/or other supports
  • Nervous system condition, for example, migraine headaches, Parkinson’s disease, multiple sclerosis (MS)
  • Neurodivergence, for example, attention-deficit/hyperactivity disorder (ADHD), autism spectrum disorder, dyslexia, dyspraxia, other learning disabilities
  • Partial or complete paralysis (any cause)
  • Pulmonary or respiratory conditions, for example, tuberculosis, asthma, emphysema
  • Short stature (dwarfism)
  • Traumatic brain injury
Please check one of the boxes below:

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.

You must enter your name and date
Human Check*