API_WebAdmin3_TFAI_20260909_CORA.docx
*** | SUPPLEMENTAL LABOR MANAGEMENT OFFICE
ADDITIONAL PROCUREMENT INFORMATION (API)
Title & Level
Web Administrator 3 (N-IT)
Work Group Location
Vancouver, WA
Specialty
SharePoint/Business Intelligence Developer
Offsite Work Eligibility*
Routine Telework Eligible
Organization
TFAI
Number of Days Onsite
2-3 days per Week
Hours
Full-Time, up to 40 hours
Additional Information
Overtime
5% anticipated
On-Call
No
Travel
Up to 5% for meetings & trainings
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 Web Administrator assignment will provide support to the *** s (BPA s) Transmission Field Services, Business Controls and Information (TFAI) team and specifically, the Asset Data Management (ADM) team. ADM is responsible for providing an accessible, reliable and comprehensive asset data register. The Web Administrator will support the development and maintenance of the ADM Service Request System and supporting workflows, and support automation of other TF processes.
Organization
This assignment will be joining a team that is dedicated to our customer and our mission of driving the maintenance for our 15,000 miles of transmission lines and all of the many substations and their associated equipment throughout a six state region. Being in the data daily and working with our customers and partners to solve complex problems is the norm for this assignment. We are a heads down organization that enjoys collaborating with our customers to better determine and meet their needs. There are many challenges as several systems integrate to drive the maintenance of our systems. We model and test some of the solutions and then work with our IT partners to implement the new changes. We are on a compound with several of our customers so there is some travel to other locations (all of them are close enough to walk to). Ideally the candidate will have a depth of knowledge on data systems and how to configure them. They would also be energetic and be able to collaborate with our teammates while working closely with customers to determine their requirement and suggest courses of action for solution.
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.
With BPA Manager oversight and approval:
Identify Business & Data requirements and convert them into conceptual & logical data models.
Participate in design, development, and analysis of data architecture and warehousing approaches
Create, monitor, modify and troubleshoot necessary ETL processes needed by the BI projects
Analyze data to ensure information is accurate and reconcilable to its source of origin
Audits, reviews, and validates databases to ensure data integrity
Verify proper change and version control for code and reports
Identify, communicate, and resolve data quality and data reconciliation issues
Develop and verify standards and procedures for the storage and retrieval of institutional data are met. Alert the BPA manager of any deviations or concerns.
Create and maintain the documentation for each business unit s data model and ETL processes
Monitor and troubleshoot existing BI applications, including frameworks, cubes, and reports and ensure the availability of the systems for the end-users
Communicate regularly with technical, applications, and operational staff to ensure database integrity, security, and optimized performance at the application and database level
Design, build, enhance, and maintain PowerBI and dashboards working from specification documents and/or direct interaction with business users
Design and maintain SQL Server Analysis Services (SSAS) databases used in ad-hoc analytic research and automated reporting.
Write SQL Server queries and stored procedures to populate reporting datasets.
Decipher existing reports and database processes to assist users and owners in understanding reports
Design SharePoint solutions from conception to implementation
Develop SharePoint-based solutions from user needs in an Internet enabled application environment
Distinguish key interactions and connectives among enterprise Internet enabled applications solutions
Perform typical administrative and maintenance activities such as site creation, and permission management
Carry out assigned tasks with a professional demeanor reflected in excellent written and oral communication skills, listening skills, patience, analytical reasoning and problem solving abilities
Meet timelines, milestones, deliverables and provide timely (weekly) status updates
Understand and follow established processes and procedures including Change Management, Work Tracking and Time Management
Administer general system monitoring and verification
Act as a point-of-contact to troubleshoot SharePoint Services, sites and permissions, and other application and server issues
Recommend and apply configuration settings to meet business needs and security requirements
Create and administer enterprise search solutions using the SharePoint search capabilities
Provide support for both IT and business users for SharePoint sites.
Create Word documents, InfoPath forms, Excel spreadsheets, PowerPoint presentations and Visio flowcharts to document the designed SharePoint solutions and design appropriate training presentations and curriculum.
Support existing business systems and their users.
Administer general system monitoring and verification
Communicate with a wide variety of technical and business experts in both individual and group settings.
Provide formal training sessions to entry, mid, and advanced level users in both individual and small to large group settings
Perform typical administrative and maintenance activities such as site creation, permission management, backup/restore
Create and administer enterprise search solutions using the SharePoint search capabilities
Provide support for both IT and business users for SharePoint sites.
Support existing ADM SharePoint sites and their users.
REQUIREMENTS
Education & Corresponding Experience (required on matrix)
Bachelor s or Masters College Degree in computer science, information technology or a related technical field is highly preferred.
With an applicable Bachelor s or Master s degree, 10 years of experience in computer/information technology is required
Without an applicable Bachelor s or Master s degree, 14 years of experience in computer/information technology is required.
Required Technical Skills & Experience (required on matrix)
10+ years of experience in an enterprise web environment with 5+ years supporting SharePoint technologies is required.
Experience reviewing datasets, graphs, and charts for data quality.
Preferred Skills & Experience (optional on matrix)
Microsoft certification in SharePoint and/or Web Administration (MSCE)
Expert level knowledge of Microsoft SharePoint Server 2010 and supporting technologies
Working experience in training, support, and trouble-shooting for end-users
Working knowledge of content management, document management, and records management within a SharePoint environment
Technical requirements gathering skills in the Information Technology environment
Experience with InfoPath and workflow solutions
Experience with SharePoint Designer 2010 Site Workflow Solutions
Experience configuring and supporting SharePoint web applications, permissions, site collections, search, and web parts
Experience with SharePoint 2007 and/or 2010 Enterprise Services: Excel Services, Form Services, Business Connectivity Services, Web Services
Experience building graphs and charts to communicate information. Experience with reporting platforms like PowerBI
Experience with SQL including joins, inserts, updates, deletes, conditional logic, subqueries, temp tables, and data transformation functions
Demonstrated expert knowledge of BI areas including ETL design, analytics, and reporting
Proficient in SQL queries, DAX, SSAS Tabular, PowerBI, and Excel
Knowledge of software design concepts and methods including SDLC
Communication skills including training and technical documentation
Experience providing training either individually or in large groups to entry, mid, and advanced level users
Additional Requirements (not required on matrix)
Valid U.S. Driver s License is required.
Appendices
The following appendices apply to this assignment and may be downloaded from the Fieldglass Reference Library:
Offsite Work
Training Expectations (Worker is expected to keep current on the latest technologies and skills required for the assignment.)
Training Type
Details
Provided by
Cascade
BPA
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)
Kemper, Timothy J
Date
8/7/2026
CFTE Job Title
Web Administrator 3
Org
TFAI
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
C
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)
C
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
B
Optional: Slips, Trips & Falls Training (HRMIS 015076)
B
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
B
Defensive/Distracted Driving (HRMIS 017057)
B
Worker operates forklifts
Forklift Certification
Choose an item.
Worker operates a fire extinguisher
Fire Extinguisher Use
B
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