F_0139_HIRING_SAFETY_TRAINING_MATRIX [004].docx

*** | SUPPLEMENTAL LABOR MANAGEMENT OFFICE

ADDITIONAL PROCUREMENT INFORMATION (API)

Title & Level

Software Developer / Programmer 3

Work Group Location

Vancouver, WA

Specialty

ReactJS, SQL,JAVA, C#, .NET

Offsite Work Eligibility*

Routine Telework Eligible

Organization

JDD

Number of Days Onsite

3 days per two weeks

Hours

Full-Time, up to 40 hours

Additional Information

This position does require access to a control network so additional days in office may be required as needed to support the assigned system.

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 Software Developer / Programmer 3 position will support ***'s (BPA)Study Automation (ARES) Team within the Transmission Operations Development Group (JDD). This Study Automation Group, the ARES Team, is involved in the creation of business process automation and documentation by interpreting design specifications, assisting in technical design, coding software, following test and deployment procedures, complying with project documentation requirements, and working on a development team using a mix of development methodologies, including Agile, as a process automation software developer.. The ideal candidate would keep abreast of industry developments regarding appropriate network system infrastructure technology and sustain a high-level of attention to detail in preventing accidental system outages or problems

Organization

JDD is unique in that it is the only group at BPA that does custom design, development, and maintenance of grid operations software solutions. Our group consists of six sub-teams, of .Net and Java expertise across multiple systems. Candidates must have strong technical and team skills to be able to do the job. Utility experience is ideal. Our team members must be able to learn and understand the complex interactions between multiple interconnected systems in order to build creative solutions and find and fix unique problems. We look for people who possess intuition and sleuthing skills beyond the basic diagnostic skills. Candidates also need the ability to understand and fulfill the various compliance requirements that regulate our business, supporting the safety and security of our systems.

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:

Assist with gathering and transforming information/data for prototyping automation efforts.

Build and maintain data models and mapping relationships between several systems to support power flow studies and other automation efforts.

Align models where practical

Communicate the data models to our customers

Design, document, and communicate effective technical solutions meeting end-user requirements.

Design, develop, test and deploy n-tier C#.Net applications utilizing the .Net framework

Work collaboratively with users and technical staff to design streamlined user interfaces.

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

Ability to analyze data, identify quality assurance/quality control issues, and identify failure or maintenance trends, including issues that may have origins in upstream systems.

Productively integrate with an existing Agile development team.

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.

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

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

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

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

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

oProduce required project technical documentation.

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

Interpret design requirements and assist in technical design on related projects.

Provide infrequent technical training to peers.

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.

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

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.

Mentor and assist other team members with application development.

REQUIREMENTS

Education & Corresponding Experience (required on matrix)

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

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

7 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 Computer/Information Technology.

Required Technical Skills & Experience (required on matrix)

7 years of the following experience:

Developing with .NET framework, C#, ReactJS, and SQL

.NET programming within an experienced development team

Object Oriented design principles

Database Access (i.e. Entity Framework, NHibernate, ADO.NET)

.NET Remoting, COM, and DCOM

Microsoft Visual Studio IDE

Experience with T-SQL development to write complex queries involving multiple tables. Experience in Extracting, Transforming and Loading (ETL) data from Excel, flat files, BCP utility, DTS, SSIS, and SSRS services

Microsoft Office Suite applications, specifically PowerPoint, Access, and Project

Preferred Skills & Experience (optional on matrix)

Utility industry experience

Knowledge of and proficient skill in applying the following:

Designing and/or maintaining high availability systems having 24x7 support

Version Control Systems

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

Ability to create and maintain clearly written technical, user, and system documentation

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

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

Demonstrated ability to quickly become familiar with existing systems and codebases

Experience using or automating PowerWorld Simulator or other electric power system simulation software (such as Client PSLF and V&R ROSE) is preferred

Microsoft PowerShell

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

Web application development using MVC

Windows application development using WPF

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

Current experience practicing test-driven development using test automation frameworks/tools (i.e. NUnit, MSTest, Moq, Rhino Mock, TypeMock, Pester)

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

Windows Cluster Server administration

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

Ability to take over support of code written by other developers

Excel at solving problems by debugging, troubleshooting

Designing and implementing solutions to complex technical issues.

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 call-outs, 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.

In