Role overview

Qualifications

Bachelor’s degree in information technology, computer science, or related field preferred.
8 years of experience required with applicable bachelor’s degree, or 10 years required without a degree.
3 years of direct, hands-on work experience in administration and development of an Oracle EPM/Hyperion platform.
Demonstrated proficiency with EPM Automate.

Responsibilities

Contribute to planning and management of the agency's Oracle EPM Cloud environment.
Maintain and strengthen existing automation scripts in PowerShell and Windows Batch.
Develop new automation using EPM Automate and REST API.
Perform root cause analysis for production issues.

Key facts

Remote from: Oregon (USA)
Full time
Expert & Leadership (>10 years)
English

Hard skills

Oracle Enterprise Manager Windows PowerShell System Administration Python (Programming Language) Data Management Data Integration Lifecycle Management SQL (Programming Language) Informatics

Other skills

Problem Solving
Collaboration
Communication

About the company

Professional Resource Group, LLC

The value-add of any professional, beyond their technical contribution, is their ability to share their experience, to interact, to effectively communicate, to proactively participate, in order to achieve a desired collective goal. More than just the technical fit, we go further to ensure that each consultant has the personality and attitude to compliment your team. Matching ‘soft skills’ or ‘profiles’ is an art, and we excel at it. In fact, it’s the basis of our recruiting philosophy.

Company details

Company size51 - 200

Links

Website LinkedIn See all jobs

Your match analysis

See how your profile stacks up against this role.

We compared the job requirements to your profile to show where you're strong and where you fall short.

Job description

Job Title: System Administrator 3 - Oracle EPM Developer
Job Number: 12012
Location: Vancouver, WA and Longview, WA
Remote: - Must live in the service territory of WA, OR, ID, MT.
Overtime: 5%
Travel: Up to 5% local travel for meetings
Length: 5 years

MUST be US Citizen to be eligible to apply for Federal Background Check

Requires Real ID and or Valid Passport to interview

SUMMARY

This assignment serves as a specialized IT contractor to help maintain the technical health, reliability, and automation of the agency's critical Oracle Enterprise Performance Management (EPM) Cloud platform. The assignment will act as a technical point of contact for maintaining the stability of daily and nightly data processing cycles, which are essential for the agency's financial planning, budgeting, and reporting functions.
The assignment’s core responsibilities include monitoring system operations, performing advanced troubleshooting of automation failures, and proactively strengthening the existing framework of PowerShell and Windows Batch scripts. This assignment requires a blend of EPM administration skills and advanced scripting capabilities to enhance system reliability, advise in the streamlining of processes, and reduce manual intervention. The successful candidate will be a problem-solver who can work independently and collaborate effectively with both internal business users and the external implementation partner to maintain and improve this system

POSITION RESPONSIBILITIES

Contribute to the organization, planning, and management of the agency's Oracle EPM Cloud environment to ensure operational health, stability, and reliability.
Maintain, troubleshoot, and strengthen existing automation scripts written in PowerShell and Windows Batch to help ensure the reliability of nightly data processing and maintenance cycles.

Develop new automation using EPM Automate and REST API to streamline administrative tasks and improve system stability

Perform root cause analysis for production issues by investigating server logs and EPM Automate exit codes to resolve failures in a timely manner.
Collaborate with technical team members, the third-party implementation partner, and business users to translate requirements into functional capabilities.
Manage the migration of EPM artifacts (Calculation Scripts, Web Forms, Business Rules, Security) between environments using Life Cycle Management (LCM).
Define data staging requirements and collaborate with data warehouse and source system teams to ensure that data is properly structured, transformed, and validated prior to being loaded into the EPM application.
Assist with core application duties, including metadata management, user security provisioning, application maintenance, and performance tuning.

Mark documents and maintain filing system(s), files, emails, and records in accordance with compliance requirements. Share and disperse documents only to appropriate personnel (those with a Lawful Government Purpose (LGP) to know). Mark and maintain all official records in accordance with the Information Security (INFOSEC) and Information Governance & Lifecycle Management (IGLM) standards and procedures. Validate official records are accurately maintained for auditing purposes

Education & Experience

A bachelor’s degree in information technology, computer science, or a related field is preferred.
- 8 years of experience is required with an applicable bachelor’s degree.
- 10 years of experience is required without a degree or an applicable degree.

Experience must include direct work experience in information technology performing system administration

Required Skills & Experience

3 years of direct, hands-on work experience in the administration and development of an Oracle EPM/Hyperion platform.
Demonstrated proficiency with EPM Automate for executing administrative tasks and moving data/artifacts.
Advanced scripting experience in PowerShell, Python, and/or Windows Batch Scripting, including creating robust error-handling and logging routines.
Experience administering an Oracle EPM Cloud application (e.g., PBCS/EPBCS, FCCS) or a similar on-premises Hyperion Planning environment.
Experience troubleshooting EPM data load processes using Data Management / Data Integration.
Knowledge of EPM architectural components, including business rules, calculation scripts, and security models.
Experience with Life Cycle Management (LCM) for migrating application artifacts.

Experience defining data transformation and validation rules for integrating data from relational sources (e.g., data warehouses) into a multidimensional EPM/Essbase application

Preferred Skills & Experience

Oracle Cloud EPM Planning Certified Implementation Professional certification is strongly preferred.
Experience using REST APIs for EPM Cloud within PowerShell or another scripting language.
Knowledge of SQL for data validation and troubleshooting.
Experience maintaining Essbase Business Rules (Calculation Scripts). Foundational knowledge of Groovy scripting for EPM is highly desirable.
Familiarity with federal information security (INFOSEC) and data handling standards.
Prior experience acting as a liaison with software vendors or implementation partners.
General understanding of federal budgeting and financial planning processes

Additional Requirements:

Valid U.S. Driver’s License is required

Pre-Employment Requirement
All employment offers are contingent upon successful completion of our pre-employment screening that may include drug testing, background/criminal check, and if applicable, must meet eligibility requirements for access to classified information.

APR Staffing is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by law.

About APR Staffing
APR Staffing was born from the merger of two well-respected technical staffing firms in Portland. ieSolutions and Data Resource Group. Both companies have recently been award winners for the Portland Business Journal's Fastest-Growing Private Companies. The two firms, now as APR Staffing, make for one of the fastest-growing and most-respected professional and technical staffing companies in Oregon and Southwest Washington.

Collaborating with our customers, we augment their workforce with technical and administrative professionals. We provide only high-caliber, professional-grade resources throughout the Pacific Northwest.

Apply once. Then go straight to the hiring manager.

After you apply, unlock the direct contact details of the people who actually make the call. A quick follow-up makes you 5x more likely to land an interview.