POSITION 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.
SharePoint and Microsoft Project Duties:
Assist the Transmission (T) business line as Microsoft Project and SharePoint specialist. Serve as a point of contact and technical resource for Transmission's Microsoft Project and the SharePoint applications. This work may include working with internal and external clients (e.g., vendor representatives, BPA IT, etc.); providing user help and troubleshooting; providing technical input and recommendations to clients and IT support; suggesting best practices for users; etc.
Support users working with the Project Web Application (PWA) and troubleshoot Project Professional and SharePoint issues before escalation to IT.
Interface with IT on Project and SharePoint Server related issues; escalate unresolved user problems as needed.
Assist with enforcing security by managing users and user groups for the applications, per established processes and criteria. Refer to team lead or BPA manager with any questions.
Create user categories and access permissions in applications, per established processes and criteria.
Create custom views in SharePoint, Project, and other applications.
Create scripts and macros in applications as needed to help with business requirements.
Work with report writers for data connections and data structure.
Support and work with Business Analysts to help build customized templates in applications.
Support management of Project and SharePoint sites, which may entail assisting with the administration of Project Web Applications and Project Sites in all environments involved in the Software Life Cycle (SLC), including Development, Testing, and Production.
Create and manage workflows in SharePoint Designer.
Solutions Development and Proposal:
Design and recommend solutions based on requirements and best practices.
Research and develop methods to automate repetitive manual data manipulations.
Define solutions that integrate the various Portfolio, Project, geographic information system (GIS) and Asset Management systems.
Complete documentation in support of the solution, including use cases, requirements, test plans, process maps, and desk procedures.
Assist in the development of Business Cases/Justifications for the identified improvement opportunities and present the proposed solutions in both verbal and written formats to stakeholders and sponsors.
Prepare functional and technical documentation for hand-off workgroups.
Work closely with project development teams to facilitate smooth operation.
Create documentation for users and maintenance manuals.
Design, build, and implement BPA-approved desktop solutions to support portfolio and project management, project scheduling, and project financial analysis.
Create custom user interfaces for web-based applications.
Design and build electronic forms to support business processes.
Mark documents and maintain filing system(s), files, emails, and records in accordance with compliance requirements. Share and disperse documents only to appropriate personnel (those with a Lawful Government Purpose (LGP) to know). Mark and maintain all official records in accordance with the Information Security (INFOSEC) and Information Governance & Lifecycle Management (IGLM) standards and procedures. Validate official records are accurately maintained for auditing purposes.
Implementation and Change Management:
Support development and implementation of change management plans by working across organizations to reduce employee resistance and empower management as change sponsors.
Facilitate, coordinate, and assist with various system verification activities such as systems and user testing.
Develop and deliver process and systems training to impacted employees.
Assist with system and data integration efforts to connect disparate systems that have various levels of SLC maturity.
Solution Maintenance:
Provide first line technical support to business users of the developed solutions.
Complete and improve user manuals, onboarding, and training documentation.
Analyze solutions and business practices for efficiency and effectiveness. Based on the analyses, recommend improvement initiatives.
Help communicate the project schedule and budget objectives to illustrate status.
REQUIREMENTS
Education & Corresponding Experience (required on matrix)
Bachelor's degree in information technology, business systems, or a closely related field is preferred.
5 years of experience is required with a bachelor's degree in applicable fields.
7 years of experience is required without a degree or applicable degree.
9 years of experience is required without a degree or applicable degree.
Experience should be consistent with the specific requirements of business systems analysis, project management, and/or business analysis, and progressively more technical in nature.
Required Technical Skills & Experience (required on matrix)
3 years of advanced or Expert level knowledge/experience in SharePoint, SharePoint Designer, Nintex Forms and Workflows, or Microsoft Project and Project Web Application.
1 year of advanced knowledge of and practical experience in Power BI.
1 year of experience in automating with Visual Basic for Applications (VBA).
1 year of experience working with Microsoft O365 applications.
1 year of experience working with Windows 11 desktop systems.
Familiarity with Data Modeling and Design.
Familiarity with Data Management and Reporting tools
SQL
SSMS (SQL Server Management Studio)
Preferred Skills & Experience (optional on matrix)
Experience in Azure Dev Ops (ADO)
Experience in Lean and Six Sigma process analysis
Familiarity with energy/utility industry
Expert proficiency in Excel, including pivot tables, charting, and reporting.
Knowledge of Microsoft technologies and cloud-based apps such as Microsoft Flow/Power Automate and Teams
Data Management and Reporting
Power BI
DAX/M
OData
CSOM
SSRS
Client-Side/Front-End Web Development (for deployment within a SharePoint Environment)
Additional Requirements (not required on matrix)
Valid U.S. Driver's License is required.