*** | SUPPLEMENTAL LABOR MANAGEMENT OFFICE

ADDITIONAL PROCUREMENT INFORMATION (API)

Title & Level

Business Analyst 2

Work Group Location

Vancouver, WA

Specialty

Reporting & Analytics

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% travel to attend 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 assignment will support 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 Business Analyst in this assignment will support new reports development for ADM stakeholders, along with quality assurance data analysis. This assignment will assist in achieving the team's goals of providing accurate and complete data to enable improvements of asset management capabilities.

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.

Support the planning and development of a large and complex reporting environment. Provide recommendations for enhancements and support any implementations of this reporting environment; providing on-going training, guidance and technical management of the environment.

Collaborate with the Transmission Asset Data Management (ADM) team, its customers and stakeholders to design, develop, recommend and coordinate reporting solutions.

Communicate, coordinate and collaborate with business teams to translate ambiguous business problems into actionable requirements and to develop customer-focused analytics.

Analyze data from multiple data sources to confirm data integrity, analyze root causes, uncover new patterns and answer key questions.

Identify quality assurance/quality control issues and identify failure or maintenance trends. Present compiled information to ADM team for awareness and analysis.

Gather and document reporting requirements and work with IT counterparts to develop reporting solutions.

Perform routine testing to validate reporting upgrades and verify enhancements meet requirements and do not negatively impact the business.

Keep abreast of Business Intelligence best practices, and identify and utilize them in reports, metrics and dashboard solutions.

Provide basic end user instruction and support for utilizing reporting and analytics solutions.

Collect, organize, and validate data and model results to establish data reporting completeness, accuracy and quality.

Communicate technical information (supported systems data, reporting and analysis results, etc.) verbally and in writing to a wide variety of technical and business experts, as well as non-technical users, in both individual and group settings.

REQUIREMENTS

Education & Corresponding Experience (required on matrix)

degree in Information or Computer Technology, Information Technology, Business Management or a closely-related field is preferred.

With an applicable Bachelor's degree, 5 years of experience is required.

With an applicable Associate's degree, 7 years of experience is required.

Without an applicable degree, 9 years of experience is required.

Experience should be consistent with the specific requirements of business analysis and progressively more technical in nature.

Required Technical Skills & Experience (required on matrix)

Demonstrated experience with report, information and database designs

Preferred Skills & Experience (optional on matrix)

Experience and knowledge in the following:

Web design, content layout

HTML background

SharePoint design

SQL Serving Reporting Services

Hyperion

Business Intelligence concepts

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

Asset Suite

BPA

Cascade

BPA

Concur

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.