System Administrator 3

First Tek, Inc.

Portland, OR

JOB DETAILS
SKILLS
Administrative Skills, Adobe Flash, Alliance/Partner Marketing, Application Programming Interface (API), Architectural Services, Auditing, Automation, Billing, Budget Management, Budget Reporting, Budgeting, Business Intelligence, C Programming Language, CIM (Common Information Model), Cloud Applications, Cloud Computing, Computer Science, Conferences, Consulting, Data Management, Data Mart, Data Migration, Data Modeling, Data Processing, Data Quality, Data Warehousing, Documentation, Ergonomics, Error Handling, Federal Contracts, Federal Laws and Regulations, Financial Planning, First Aid, Government, Groovy Programming Language, Hand Tools, Hazard Analysis, Hazardous Materials/Substances, High Voltage (HV), Hyperion, IRC (Internet Relay Chat), Identify Issues, Information Systems/Technology IS/IT Administration, Information Technology & Information Systems, Information/Data Security (InfoSec), Interpret Regulations, Material Moving, Microsoft Windows Operating System, Negotiation Skills, On Site Support, Oracle DBA (Database Administrator), Oracle Enterprise Performance Management (EPM), Oracle Essbase (fka Hyperion Essbase), Oracle Hyperion Planning, Organizational Development/Management, Performance Reviews, Policy Development, Problem Solving Skills, Procedure Development, Process Development, Process Hazard Analysis (PHA), Process Management, Product Reviews, Project Evaluation, Purchasing/Procurement, Python Programming/Scripting Language, REST (Representational State Transfer), Record Keeping, Regulatory Submissions, Reimbursement, Reporting Skills, Requirements Management, Resource Management, Risk, Risk Management, Root Cause Analysis, SQL (Structured Query Language), Safety Systems, Safety Training, Safety/Work Safety, Scripting (Scripting Languages), Seminars, Service Delivery, Staff Training, Statement of Work (SOW), Surveillance, System Operations, Systems Administration/Management, Systems Reliability, Testing, Time Management, United States Department of Energy (DOE), Vehicle Driving, Vendor/Supplier Selection, Web Forms, Willing to Travel, Windows PowerShell, Work From Home
LOCATION
Portland, OR
POSTED
Today
F_0139_HIRING_SAFETY_TRAINING_MATRIX.docx

*** | SUPPLEMENTAL LABOR MANAGEMENT OFFICE

ADDITIONAL PROCUREMENT INFORMATION (API)

Title & Level

System Administrator 3

Work Group Location

Portland, OR

Specialty

Oracle EPM Developer

Offsite Work Eligibility*

Routine Telework Eligible

Organization

JLSR

Number of Days Onsite

1 days per Week

Hours

Full-Time, up to 40 hours

Additional Information

Onsite expectation is at least 1 day per week but may vary depending on business needs.

Overtime

5% anticipated





On-Call

No





Travel

Up to 5% local travel for meetings





FN Status

NOT open to Foreign Nationals





* Current telework, remote work and onsite support is based on BPA s business needs and is subject to change or termination at any time.

** Assignments with the Remote Designation must reside in WA, OR, ID or MT. Case-by-case exceptions may apply only when in the best interest of BPA.

OVERVIEW

Assignment

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.

Organization

Data Integration and Reporting (JLSR) provides reporting services, business intelligence, data warehousing, and data integration for the Chief Information Office (J) of the *** (BPA). The staff is responsible for BPA s reports development, data modeling, and reporting services as well as the management and the delivery of services supporting a BPA common information model through the implementation of data integration architectures such as data warehouses, data marts, and data migration and solutions.

ASSIGNMENT RESPONSIBILITIES

Note: All official drafts, documents and recommendations, as listed below, must be reviewed, finalized and approved / accepted by appropriate BPA manager or other federal personnel with the authority to do so.

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.



REQUIREMENTS

Education & Corresponding Experience (required on matrix)

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 Technical Skills & Experience (required on matrix)

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 (optional on matrix)

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.

Appendices

The following appendices apply to this assignment and may be downloaded from the Fieldglass Reference Library:



Remote Work Program

Training Expectations (Worker is expected to keep current on the latest technologies and skills required for the assignment.)

Training Type

Details

Provided by

Attendance at all conferences, workshops, training, etc. must be pre-approved by SLMO. Requests will be reviewed on a case-by-case basis. Approval is subject to the most current guidance provided to SLMO by BPA or DOE and is subject to change at any time. SLMO reserves the right to negotiate attendance on billable/non-billable hours and reimbursement of travel costs with the supplier. Reimbursable travel costs must adhere to the Federal Travel Regulations and be submitted via an expense sheet in Fieldglass.

CLOSELY ASSOCIATED RESPONSIBILITIES & REQUIRED ASSOCIATED MITIGATION MEASURES

The following is a list of potential inherently governmental risk areas and the measures that SLMO-Compliance has determined must be in place, via processes and procedures, to mitigate the associated risks. The BPA manager s acceptance of the API or CWSD serves as their attestation that all applicable mitigation measures listed below are or will be established and adhered to in their organization.

Area of potential Closely Associated / Inherently Government function

Mitigation Measures

Access to Confidential / Sensitive Information

CFTE must sign NDA (Non-Disclosure Agreements) at beginning of assignments. (Does not apply to Craft assignments)

CFTE must complete annual Information Security and Privacy Awareness training.

CFTE must complete and pass background investigations of an appropriate level.

Acquisition Planning / Source Selection

CFTE are not permitted to serve as voting members for acquisition selections.

All purchasing decisions must be made by appropriate federal personnel (Contracting Officers).

All acquisition documents (requirements,
SOW s, evaluation criteria, etc.) must be reviewed, finalized and approved by appropriate BPA federal personnel.

Only Contracting Officers are authorized to obligate BPA funds.

Agency / Org Planning

All drafts, documents, materials and recommendations must be reviewed, finalized and approved by appropriate BPA federal personnel.

Budget / Finance Prep

Only Federal Employees may determine budget priorities & allocations.

BFTE must control and finalize / approve all budgets and related documentation, including that for projects, programs and Organizations.

Contract Management

All Contractual documents, including invoices must be finalized / approved by appropriate Federal personnel.

All contract-related decisions (modifications, changes, performance) must be determined by appropriate federal personnel (COs).

Decision Making

CFTE may provide input and recommendations to decision-makers.

Only appropriate federal personnel may make decisions which obligate BPA resources or to a specific course of action.

Direction & Control
(directing BFTE)

CFTE are not permitted to direct the actions of federal employees (BFTE) or have any control or input into their performance.

Work of BFTE must be assigned by federal manager, supervisor, Program / Resource manager or another appropriate designee.

Disposing Govt. Property

All decisions regarding the disposal of BPA property must be made by appropriate federal personnel; and all property dispositions must be directed and controlled by the Investment Recovery Center (IRC).

Dissemination of Agency/Policy Information / Training

All training and any information that is to be disseminated must be either 1) per established policy, process, procedure, or practice; or, 2) reviewed, finalized and approved by appropriate BPA federal personnel.

Inspection / IT Testing

Processes and procedures must ensure Federal personnel review inspection findings and CFTE recommendations before acceptance or rejection of material(s) / item(s).

HR Support

CFTE may assist with HR functions per established procedures, processes and guidelines (e.g., timekeeping).

All work products must be reviewed and finalized by appropriate federal employees.

Policy Development

BPA s process for Policy development includes multiple levels of federal review prior to acceptance / adoption.

Interpretation of Policy/Regulations

Only BPA federal employees may determine the applicability and interpretation of regulations.

CFTE are not permitted to interpret regulations for or on behalf of BPA. Regulations are interpreted by federal personnel and communicated via standards, guides, policies and processes.

Representing BPA

Contract workers are required to identify themselves and their employer in signature blocks, in introductions and have a nameplate outside their cubicle.

CFTE must receive written VP approval to represent BPA at outside events, such as workshops, seminars or conferences.



Page 4 of 4 F_0121_API_TEMPLATE_030626
CFTE NON-CRAFT HIRING SAFETY TRAINING MATRIX



CONTRACT FULL TIME EQUIVALENT (CFTE)

NON-CRAFT HIRING SAFETY TRAINING MATRIX



Purpose:

The Contract Full Time Equivalent (CFTE) Hiring Safety Training Matrix is a hazard assessment for CFTE personnel routine tasks. It is intended to set a common understanding on training requirements between the CFTE personnel and the *** (BPA) managers/supervisors. BPA Requesting Managers should complete this form and coordinate with BPA Supplemental Labor Office during the procurement process to ensure the CFTE position includes a list of required trainings associated with identified tasks, conditions, and exposures. Each task, condition, and exposure indicate which training courses are required, who shall provide those trainings, and when those trainings shall occur.

This form is intended only as a reference document for contractors.

BPA Requesting Manager

(Last, First MI)

Wilde, Rebecca L

Date

5/26/2026

CFTE Job Title

System Administrator 3

Org

JLSR

PPE provided by Supplier or Contractor?

Yes No

If yes, list required PPE: Click or tap here to enter text.



Identify which Supplier or Contractor medical surveillance programs are required, if any*

Respirator User

Asbestos

Lead

Silica

Hearing Conservation

Other: Click or tap here to enter text.

No Medical Surveillance

*BPA Requesting Managers may use equivalent Job Title Position Hazard Assessments or project Job Hazard Analyses as indicators for which medical surveillance programs may be required. Direct any questions regarding medical surveillance program requirements to the BPA Industrial Hygienist, ***, or ***.

Instructions for BPA Requesting Manager: This template has been pre-populated with tasks and hazards generally associated with CFTE non-craft positions. BPA Requesting Managers must review this document during the CFTE procurement process. The BPA Requesting Manager will:

Select the checkbox next to each task/condition/exposure that may be encountered during the normal course of the assignment.

Identify if the mitigation for applicable tasks/conditions/exposures will be provided by BPA or the Contractor (supplier).

Indicate when the mitigation must occur (pre-hire, post-hire, pre-task).

Pre-Hire Training should be completed prior to the CFTE starting their assignment.

Post-Hire training should be completed prior to exposure to a hazardous environment and/or conducting work at a BPA worksite.

Pre-Task Training should be completed prior to conducting the associated task.

Once complete, the BPA Requesting Manager will send the completed document to the Supplemental Labor Management Office.

The listed tasks, conditions, and exposures are not all inclusive. New processes, unusual tasks, or equipment may trigger the need for specialized training. Consult with your local Safety Manager or BPA Safety Training Manager for guidance.

BPA provided safety training will be the same training provided to Federal Workers.

For the General Comments section, BPA Requesting Managers can list anything that was not already covered and provide clarification to the BPA COR to better understand the CFTE position. It may include tasks, conditions, and/or exposures that are unique to a particular position, work site, or person.

For more information on the PHA process/requirement, reference the Safety and Occupational Health Manual, Safety Management Systems Chapter.

Direct any questions regarding training requirements or issues related to this form to the BPA Safety Training Manager, ***, or ***.

Office & Remote Work/Telework Hazards

Task / Condition / Exposure

Required Training

Contractor (C) or BPA (B) Provided

Pre-Hire Training

Post-Hire Training

Pre-Task Training



Exposed to a fire in the building

BPA manager will advise of evacuation protocol and designated gathering location. Annual fire drills will be conducted.

B









Exposed to an earthquake while in the building

BPA manager will advise of evacuation protocol and designated gathering location.

B









Operating office tools (paper cutter, paper punch, staplers, etc.)



None Identified

Choose an item.







Task / Condition / Exposure

Required Training

Contractor (C) or BPA (B) Provided

Pre-Hire Training

Post-Hire Training

Pre-Task Training



Performing tasks that may result in repetitive motion injuries, prolonged sitting and computer use

Optional: SUFS Move Safe (HRMIS 016633)

B









Ergonomics

Recognize the hazards and know when it is appropriate to stretch and take breaks; ensure a proper desk, chair, and equipment adjusted at the appropriate level; ensure proper lighting. Any ergonomic assessment to be provided by the supplier.

C









Performing tasks that may result in slips, trips or falls such as carrying boxes and walking on stairs or slick surfaces

Review SOHM Chapter 9

Choose an item.











Optional: Slips, Trips & Falls Training (HRMIS 015076)

Choose an item.









Adding electronic devices that were not previously part of the home (monitors, chargers, computing equipment, etc.)

None Identified. On-the-job familiarization (if using BPA-issued equipment).

Choose an item.







Travel / Field Operation Hazards

Task / Condition / Exposure

Required Training

Contractor (C) or BPA (B) Provided

Pre-Hire Training

Post-Hire Training

Pre-Task Training



Driving vehicles on public and/or non-public roads

Review SOHM Chapter 19

Choose an item.











Defensive/Distracted Driving (HRMIS 017057)

Choose an item.









Worker operates forklifts

Forklift Certification

Choose an item.









Worker operates a fire extinguisher

Fire Extinguisher Use

Choose an item.









Worker operates hand tools

None Identified

Choose an item.









Worker uses personal protective equipment

Personal Protective Equipment

Choose an item.









Worker may be exposed to shock and arc-flash hazard

Shock & Arc Flash Awareness

Choose an item.











Shock & Arc Flash Basic

Choose an item.











Shock & Arc Flash Advanced / Refresher

Choose an item.









Worker may contact but will not disturb Asbestos Containing Material (ACM) or Potentially Asbestos Containing Material (PACM) 2

Asbestos Awareness

Choose an item.









Worker required to work in remote areas where bear encounters may take place

Bear Pepper Spray Training

Choose an item.









Worker exposed to rodent and bird droppings1

Biological/Vermin/Hanta Virus

Choose an item.









Worker exposed to hot and/or cold environments





None Identified

Choose an item.







Task / Condition / Exposure

Required Training

Contractor (C) or BPA (B) Provided

Pre-Hire Training

Post-Hire Training

Pre-Task Training



Worker exposed to chemicals, such as herbicides or pesticides;

Herbicide Cert. Ref. 4-hr

Choose an item.











Herb Certification 8-hr

Choose an item.











Hazardous Communication

Choose an item.









Worker exposed to lead2

Lead Awareness

Choose an item.











Lead Worker Training

Choose an item.









Worker exposed to mercury

None Identified

Choose an item.









Worker exposed to noise2

Hearing Conservation (Initial)

Hearing Conservation (Annual)

Choose an item.









Worker exposed to silica2

Silica - Awareness

Choose an item.









Worker works at heights higher than 4

Fall Protection, Awareness

Choose an item.











Fall Protection, General

Choose an item.











Fall Protection, Advanced

Choose an item.











Ladder Safety

Choose an item.











Fall Protection, Advanced (TLM)

Choose an item.









Worker is required to take first aid and may be called on to render first aid for: workers on high voltage lines and/or equipment; worker works in remote areas

First Aid/CPR/AED

(Red Cross or AHA Accredited)



Required only if specified in the API

Choose an item.









Worker performs work alone in remote areas

Wilderness Adv. First Aid

Choose an item.









Worker may prepare, transport or receive hazardous materials

DOT 1: Introduction, Classification, and the Hazardous Materials Table

DOT 2: Packaging, Labeling, Marking, and Placarding

DOT 3: Shipping Papers

DOT 4: Loading and Storage

DOT: Security for Shipment of Hazardous Materials

Hazardous Materials: Shipping Lithium Batteries under DOT Exemptions

DOT Hazardous Material Awareness for the General Hazmat Employee









Choose an item.







1 BPA workplace manager to review Hantavirus Prevention Procedure 420-240-1 before performing task.

2 These exposures may require enrollment in a Medical Surveillance Program. Ensure page 1 is marked accordingly.

Other Specific Hazards

Task / Condition / Exposure

Required Training

Contractor (C) or BPA (B) Provided

Pre-Hire Training

Post-Hire Training

Pre-Task Training



SAMPLE: Worker may make infrequent visits to field locations or substations

Worker complete the PPE assessment in the SOHM to determine need for PPE such as hard hat, safety glasses, hearing protection, safety vests, Arc Flash clothing or steel-toed boots.

B



X





Click or tap here to enter text.

Click or tap here to enter text.

Choose an item.









Click or tap here to enter text.

Click or tap here to enter text.

Choose an item.









Click or tap here to enter text.

Click or tap here to enter text.

Choose an item.









Click or tap here to enter text.

Click or tap here to enter text.

Choose an item.









Click or tap here to enter text.

Click or tap here to enter text.

Choose an item.









Click or tap here to enter text.

Click or tap here to enter text.

Choose an item.









Click or tap here to enter text.

Click or tap here to enter text.

Choose an item.









Click or tap here to enter text.

Click or tap here to enter text.

Choose an item.









Click or tap here to enter text.

Click or tap here to enter text.

Choose an item.







General Comments

BPA Requesting Manager Comments/Additional Considerations:

Click or tap here to enter text.



F_0139_HIRING_SAFETY_TRAINING_MATRIX_121624

About the Company

F

First Tek, Inc.