*** | SUPPLEMENTAL LABOR MANAGEMENT OFFICE

ADDITIONAL PROCUREMENT INFORMATION (API)

Title & Level

Software Developer 2

Work Group Location

Portland, OR

Specialty

Reports and Analytics 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

This team meets onsite every Thursday for meetings.

Overtime

5% anticipated

On-Call

No

Travel

Up to 5% 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 full-time contract assignment will support the Data Integration and Reporting (JLSR) organization within ***'s (BPA's) IT department. This assignment involves contributing to the organizing, planning, and managing of a large, complex reporting environment, and performing project technical requirements, design, development and testing tasks similar to those performed by the rest of the development team.

Organization

Data Integration and Reporting provides reporting services, business intelligence, data warehousing, and data integration. The staff provides reports development and reporting services as well as the management and 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/integration 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.

Collaborate with technical team members and customers in order to translate user requirements from both internal and external BPA clients into functional capability. Confirm JLSR resources are available to provide representation to organizations within BPA.

Perform project technical requirements; design, development, and testing tasks for fixed and analytic reports.

Develop static and dynamic reports from a three-tier client-server application that uses a web server, application server, and SQL database engine architecture.

Write scripts and modify Microsoft Visual Studio methodology templates to provide customization of check-in policies, custom reports, and repetitive testing.

Create and modify existing reports and dashboards using the Power BI Desktop tool.

Troubleshoot and communicate report interoperability problems in existing web-driven applications using SQL as the backend for data access.

Develop customer focused BI analytics solutions.

Develop presentation layers in concert with customer requirements and best practices and approaches.

Act as a point of contact and oversee technical schedule segments to ensure project milestones are completed on time by escalating issues to the team lead and project manager if necessary.

Provide issue resolution in coordination with the team lead and project manager.

REQUIREMENTS

Education & Corresponding Experience (required on matrix)

Bachelor of Science in Information/Computer Technology or a related technical discipline is preferred.

3 years of Information Technology experience is required with a Bachelor's degree in a specified degree..

5 years of Information Technology experience is required without a degree or an applicable degree..

Required Technical Skills & Experience (required on matrix)

Demonstrated experience with the following is required:

Power BI Server and desktop tool

Microsoft Visual Studio 2019, 2022 and SQL Server Data Tools (SSDT)

Microsoft SQL Server 2016, 2022 or later

SQL Reporting Services 2012, 2016, and 2022

Scripting (VB scripting/Java Scripting, and Powershell)

Report Design / Information/database Design Skills

Preferred Skills & Experience (optional on matrix)

Microsoft Analysis Services 2008 - 2022

Oracle Cloud infrastructure (EPM)

Data Modeling/Dimensional Modeling/ER Diagrams

Web design, content layout, ASP.NET

HTML background

SharePoint design experience

SDS (System Design Specification)

Software development coordination with clients and management

Microsoft Certified Solution Developer (MCSD) for Microsoft.NET certification.

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

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)

Buss, Matthew A

Date

8/27/2026

CFTE Job Title

Software Developer 2

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 l