WMATA - EPM Specialist II (Oracle Hyperion / EPM)

Location: Washington, DC (Onsite; occasional meetings in Alexandria, VA and Hyattsville, MD)
Work Authorization: Must be a U.S. Citizen or Green Card holder
Schedule: Full-time (40 hours/week)
Compensation: Salary is open and commensurate with experience

Overview

We are seeking an EPM Specialist II to support planning and budgeting systems, including Oracle Hyperion/EPM applications. This role focuses on system administration, reporting, data management, and supporting financial planning processes across budgeting and forecasting cycles.

Key Responsibilities

• Administer and support Oracle EPM/Hyperion Planning applications
• Maintain and enhance reports; migrate reports across environments
• Manage metadata, workflows, and data within EPM systems
• Support month-end, quarterly, and year-end financial reporting processes
• Analyze data trends and identify opportunities to improve data quality
• Troubleshoot and resolve system and data issues
• Serve as liaison between business teams and technical support teams
• Support budgeting and forecasting activities across finance teams
• Provide training and support for end users (e.g., SmartView, reporting tools)
• Document system changes and maintain tracking (e.g., Jira)
• Assist with validation and testing of system updates in QA environments

Qualifications

• Bachelor’s degree in Information Systems, Computer Science, Finance, or related field
• 5+ years of experience with Oracle EPM / Hyperion Planning
• Strong experience with financial planning, budgeting, and reporting systems
• Experience with SmartView, reporting tools, and EPM workflows
• Knowledge of SQL, scripting (e.g., MXL), or data querying (preferred)
• Experience with system administration, data management, and reporting
• Strong analytical, problem-solving, and communication skills

Nice to Have

• Experience supporting ERP migrations (e.g., PeopleSoft to Oracle Fusion)
• Background in finance, budgeting, or public sector environments

Required Skills

Required Experience

Skills/Qualifications

• High school diploma and/or related experience in the industry.
• Ability to read, write and communicate in English.
• Basic math skills including the ability to add, subtract, multiply, and divide in all units of measure, using whole numbers, common fractions, and decimals.
• Familiarity with basic computer skills in word processing and spreadsheet programs.
• Required to have unrestricted use of a licensed and insured vehicle in good, safe operating condition that can be used on the job for both personal and sample transportation in all ambient weather conditions. Must possess a valid current driving license and meet the requirements of AmSpec Safe Driving Policy.
• Must be ready to accept job assignments at any time, 24 x 7, including scheduled days off. Overtime must be worked as required to meet the needs of the branch office. Must be willing to work shifts if required by location.
• Must be able to work in refineries, terminals, and on-board marine vessels as necessary.
• Must respond to communications from the office and be available at all times.
• Attendance at monthly safety meetings is required.
• TWIC Card may be required to access terminals, refineries, rail yards, platforms, launch areas, and other third party host sites.

Working Conditions
The employee may be exposed to fumes, airborne particles, and toxic or caustic chemicals. AmSpec provides product
information, training and personal protective equipment to protect employees from exposure to potentially harmful levels
of those materials. The employee will be required to work outdoors in all levels of adverse weather conditions. Work may
be required to be performed in refineries, tank farms, terminals and on board barges, ships, railcars and tank trucks. The
noise level in the work environment may be high at times. Local and on occasion long distance travel may be required.

Physical Requirements

• Safety Sensitive position that requires pre-employment, random and annual drug and alcohol testing (including marijuana testing).
• Comply with the requirements of AmSpec D&A Policy.
• Pass an annual Pulmonary Fitness Test.
• Pass a physical examination by a physician designated by AmSpec, both before employment and at any time during employment upon request of AmSpec Services to confirm the Surveyor’s ability to perform the essential job functions of the position.
• Qualify annually for a Respirator Fit Test.
• Qualify annually, based on the results of an OSHA- designated blood test, for work in areas containing certain levels of Hydrocarbon Vapors.
• Be able to safely perform inspection work while wearing required safety equipment, regardless of ambient weather conditions.
• Ability to stand for extended periods; use hands to handle, or feel objects, tools, or controls; talk or hear; and to smell.
• Ability to walk, sit, stoop, kneel, crouch, crawl and reach with hands and arms frequently.
• Ability to climb storage tank ladders and stairs, typically up to 100 feet high while carrying 45 lb. of samples and/or inspection- related gear or equipment. Ability to climb vessel gangways, ladders, Jacob’s ladders, and stairs.
• Ability to work in the presence of odors, typical of petroleum or petrochemicals, without allergic reactions or nausea when such odors are within OSHA-designated permissible exposure limits (PELs).
• Ability to work in confined spaces (as defined by OSHA), wearing appropriate respiratory and skin protection equipment.