System Administrator 3

4. F_0139_HIRING_SAFETY_TRAINING_MATRIX_AppDev_v26.0513a.docx


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)


Crow, Joshua, K


Date


Click or tap here to enter text.


CFTE Job Title


IT Specialist, Application Developer


Org


JDP


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)


Choose an item.


☐


☐


☐


☐


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.


Choose an item.


☐


☐


☐


☐


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
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)


Crow, Joshua, K


Date


Click or tap here to enter text.


CFTE Job Title


IT Specialist, Application Developer


Org


JDP


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)


Choose an item.


☐


☐


☐


☐


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.


Choose an item.


☐


☐


☐


☐


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
*** | SUPPLEMENTAL LABOR MANAGEMENT OFFICE


ADDITIONAL PROCUREMENT INFORMATION (API)


Title & Level


System Administrator 3


Work Group Location


Vancouver, WA


Specialty


Software Developer


Offsite Work Eligibility*


Routine Telework Eligible


Organization


JDP


Number of Days Onsite


3 days per two weeks


Hours


Full-Time, up to 40 hours


Additional Information


Enter additional info regarding the offsite work arrangement, if applicable.

Overtime


5% anticipated

On-Call


Yes See Other Position Considerations for more details

Travel


Up to 5% to 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 contract assignment is within the Information Technology Operational Technology Organization (J-OT), Application Services (JD), Critical Business Systems Application Support and Development (JDP). In this role, a System Administrator 3's duties include developing and interpreting policies, procedures, and strategies governing agency-wide IT service delivery, while providing expert technical advice to management on critical IT issues. Shepherding the integration of IT programs and services, resolving complex interoperability issues, and designing systems that optimize the existing architecture. Developing clean software code, automating business processes, and managing project documentation. Working within an Agile development team, adhering to strict testing and deployment procedures to meet current and future business requirements. The ideal candidate has a willingness to learn new technologies and stay updated with industry trends and has a strong attention to detail, excellent time management skills and the ability to handle multiple projects and deadlines at the same time.


Organization


The Critical Business Systems (CBS) Operations and Development organization provides 24x7 operations, monitoring, support and troubleshooting of Bonneville's identified CBS portfolio, and the design, development, and enhancement of Critical Business Systems. This requires a sound, fundamental understanding of Power and Transmission business to provide customer focused system support. The organization is composed of multi-disciplined personnel to concentrate capabilities and improve service responsiveness. Additionally, the organization provides direction and leadership in the planning, development, and enhancement of Critical Business Systems and work processes


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:


System Architecture, Development: Design, implement, and maintain new features for the power scheduling application, adhering to established Clean Architecture and Domain-Driven Design (DDD) principles. Build and maintain data models and mapping relationships between several systems to support power flow studies and other automation efforts, aligning models where practical.


Back-End Development: Build and maintain CQRS (Command Query Responsibility Segregation) command and query handlers in the application layer. Implement and manage domain event propagation and integrate scheduled jobs.


Front-End Development: Develop and extend Angular components and services for sophisticated, operator-facing and customer-facing web portals used for data entry and operational monitoring.


Databases: Write and optimize complex SQL Server queries, stored procedures, and schema migrations within a multi-schema database environment. Facilitate data integrity and performance for high-volume transactional workloads.


Business Analysis and Collaboration: Participate in requirements analysis sessions with domain experts. Translate complex power scheduling business rules from functional specifications into a robust and maintainable domain model. Work collaboratively with users and technical staff to design streamlined user interfaces. Interpret design requirements and assist in technical design on related projects.


Code Quality and Testing: Contribute to rigorous peer code reviews with a focus on correctness, performance, and adherence to architectural patterns. Maintain and extend the comprehensive unit and integration test suites. Design, develop, test and deploy n-tier C# .Net applications utilizing the .Net 10 framework


Scripting and Automation: Use scripting languages like PowerShell for tool automation and efficient task management.


System Integration and Support: Debug production and pre-production issues across the full stack (API, application layer, data layer, SQL Server). Provide technical assistance to effectively resolve issues. Collaborate with integration teams on REST and WCF service contracts for data exchange. Analyze, test, and apply changes to the application environment under the prevailing change management procedures and requirements. Identify or resolve problems in applications at all system tiers (Application, Server, Database, and Network). Analyze data, identify quality assurance/quality control issues, and identify failure or maintenance trends, including issues that may have origins in upstream systems. Plan, coordinate, and implement system security measures to protect data, software, and hardware. Monitor system performance to determine whether adjustments need to be made, and to determine where changes will need to be made in the future.


Other:


Collaborate with project managers, business analysts, software developers, QA testers, and users throughout the System Life Cycle (SLC).


Provide emergency and backup support for existing systems and functions.


Create and maintain technical records, such as network charts, system specifications, and standard operating procedures (SOPs).


Explain complex technical concepts and processes to both technical and non-technical audience to foster understanding.


Communicate with internal stakeholders in small and large settings about new initiatives and improvements.


Support Federal Information Security Management Act (FISMA) standards and North American Electric Reliability Corporation critical infrastructure protection (NERC-CIP) compliance when performing assigned work.


Analyze and propose technical designs that satisfy functional and non-functional requirements which also optimize the long-term maintainability of the system.


Productively integrate with an existing Agile development team.


Confer with system users about how to solve existing system problems.


Mentor and assist other team members with application development.


Provide infrequent technical training to peers.

With BPA manager/team lead oversight and approval, when needed, assume the role and responsibilities of a technical lead, which includes the following:


Break down technical work into tasks and provide reasonable time estimates for completion.


Communicate status of project development work to project team, users, information system owners and others.


Analyze and propose technical designs that satisfy functional and non-functional requirements which also optimize the long- term maintainability of the system.


Identify and escalate technical bottlenecks and impediments to the project manager and information system owner.


Produce required project technical documentation.


Review other developers' code and provide technical constructive feedback where necessary to verify their code follows BPA and team coding standards and programming best practices.


REQUIREMENTS


Education & Corresponding Experience (required on matrix)


A degree in Computer Science, Information Technology, Engineering or a directly related field is preferred.


8 years of experience is required with an applicable bachelor's or associate degree.


10 years of experience is required without an applicable bachelor's or associate degree or no degree.


Applicable Certifications may count for 1 year of experience.


Experience must include direct work experience in information Technology performing System Administration.


Required Technical Skills & Experience (required on matrix)


7 years of the following experience:


Developing in C# leveraging the latest features of .NET 10 to build high-performance, secure, and maintainable enterprise applications.


Designing and implementing RESTful API's using modern standards, including expertise in middleware, authentication/authorization protocols, and end-to-end API lifecycle management.


Use TypeScript to maintain or build scalable applications capable of using at least one major frontend framework (e.g., React, Angular, or Vue.js).


Strong adherence to Object-Oriented Design (OOD) and SOLID principles to create clean, scalable, and maintainable code.


Expertise in designing and maintaining Microsoft SQL Server databases. This includes writing and optimizing complex T-SQL queries, stored procedures, and strategically implementing indexes for performance.


Experience with data access frameworks such as Entity Framework, NHibernate, or ADO.NET for database communication.


Proficient in Extract, Transform, Load (ETL) processes and experience with tools like Bulk Copy Program (BCP) and SQL Server Integration Services (SSIS) for data migration and integration from various sources (e.g., flat files, Excel, other systems).


Proficient with Git and common branching strategies for collaborative development.


Experience with implementing and maintaining Continuous Integration/Continuous Deployment (CI/CD) pipelines using tools like Azure DevOps and Jenkins


Expertise in using Microsoft Visual Studio IDE for development, debugging, and testing.


Familiarity with using SQL Server Data Tools (SSDT) in Visual Studio to manage database schemas as code.


Experience using Microsoft Office's large suite of applications, including specifically PowerPoint, Visio, and Project.


Experience using SharePoint for enhanced document sharing and collaboration.


Work in conjunction with other IT development professionals and support teams.


Strong verbal and written communication skills, with the ability to clearly articulate technical concepts to both peers and external customers.


Preferred Skills & Experience__(optional on matrix)


Experience with Agile development practices such as SCRUM


Experience working in an environment utilizing formal change management and operating under strict separation of duty principles.


Experience working in 24/7 high availability environment.


Knowledge of and experience working with:


Windows application development using WPF


Angular, Bootstrap, and responsive design principles


MuleSoft


Azure DevOps for Agile management, deployment pipelines, and source control


Visual Studio 2026 and Visual Studio Code


Version Control Systems (e.g., TFS, Subversion, Git, Mercurial)


WinForms


Exposure to other programming languages (i.e. C++, Java)


Windows Cluster Server administration


PowerShell and related scripting


Web services and socket-based protocols (e.g., XPATH, XML Schemas, XSLT, WCF, SOAP)


Web application development using MVC


Proven experience collaborating with software developers, testers and users throughout the System Life Cycle (SLC)


Demonstrated Ability to:


Create and maintain clearly written technical, user, and system documentation


Analyze information and use logic to address work related issues and problems, with understanding of impact on current and future programs and processes.


Produce code that coworkers can maintain and must be agreeable to peer reviews


Quickly become familiar with existing systems and codebases


Take over support of code written by other developers


Problem solving by debugging and troubleshooting


Provide a sustainable IT infrastructure by supplying cross training and functional documentation.


Design and implement solutions to complex technical issues


Experience working with NIST/FISMA standards/guidelines


Experience applying NERC-CIP standards


Governmental processes and (electric) utility experience


Additional Requirements (not required on matrix)

Valid U.S. Driver's License is required.


Other Assignment Considerations


On Call - Emergency and backup support - Required to provide limited personal contact information (phone numbers only) for emergency callouts, carry a BPA supplied cell phone/pager (if applicable), and work non-core hours when requested. May be required to work on an after-hours on-call rotation with other team members.


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.)


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