Job #: 8934
Title: Business Systems Analyst 3
Specialty: Cascade, Control, & Communication Systems and Compliance
Location: Vancouver, WA
Application Due Date: 3/28/2019
Job Length: 1+ Year Contract
ieSolutions is an Equal Opportunity Employer (EOE). M/F/D/V. Security Clearance Requirement: Applicants selected will be subject to a government security investigation and must meet eligibility requirements for access to classified information. U.S. Citizenship Required.
This contract Business Systems Analyst 3 position will provide analyst support to the PSC Technical Services (TTCT) organization within the Transmission Technology (TT) group of the Client. This position will provide research and analysis of historical data on the installed database of System Protection and Control (SPC) and Power System Control (PSC) equipment in addition to the additional design of processes and forms to track a variety of NERC requirements and compliance efforts at Client. This can entail determining the extent of the missing data in the system, as well as developing and implementing new processes or procedures to track compliance. Because there are limited existing databases, the BA in this position will need to utilize creative approaches to compliance documentation and verification. In addition, this position will provide recommendations for solutions to problems or gaps in data. The Business Systems Analyst position will provide data management and process controls for good data stewardship, and technical input and support in identifying process improvements and system alignment between Information Technology tools used for compliance reporting. The position will collaborate with Engineers in System Control Engineering (TEC), the Security and Compliance team in TT, as well as Engineers and Craftsmen in TF (Transmission Field Services), to support Client management decision making and recommend requirements and improvements for program or project development.
This position will provide Project Management and Change control associated with several TEC/TT NERC CIP, PRC, and Federal Information Security Management Act (FISMA) projects: Firmware tracking, Vulnerability assessments and password management; as well as providing detailed analysis of the Cascade and BES (Bulk Electric System) data to determine where equipment is located and how much of a risk Client has for non-compliance with NERC and Client requirements and standards. To successfully advance the aforementioned work, the BA in this position will perform the following:
o Coordinate activities for Client manager-assigned projects that enable goals or objectives to be accomplished within the prescribed time frame and funding parameters, escalating concerns to appropriate Client manager / personnel.
o Compile, review and analyze information in order to collaborate with Client team members to, create/draft technical documentation to support system requirements, system design, system security, and operational manuals for a wide variety of software applications and may include the updates to SPC ADP computer system documentation.
• Requirement Support:
o Conduct interviews and lead workshops to elicit business requirements.
o Analyze, facilitate, model and organize information in order to elicit requirements; work with appropriate parties to facilitate resolution of conflicting team positions; and, distinguish solution ideas from business needs.
o Decompose high-level information into details and abstract up from low-level information to distinguish between solution ideas and business needs.
o Lead requirements validation sessions and present back the findings.
• Solution Development and Proposal:
o Design architecture and solutions based on requirements and best practices.
o Focus on efficiency of various workgroups involved in Project Execution.
o Look for ways to automate repetitive manual data manipulations.
o Use Rapid System Development methods to build prototypes.
o Develop solutions that integrate the various Portfolio; Project; GIS and Asset Management systems.
o Complete all documentation in support of the solution, including use cases, requirements, test plans, process maps, and desk procedures.
o 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 key stakeholders and sponsors.
• Solution Build:
o Prepare functional and technical documentation for hand-off to IT workgroups.
o Work closely with appropriate development teams to ensure a smooth build.
o Create documentation for user and operational manuals.
o Design, build and implement desktop tools and systems to support portfolio and project management; project scheduling and project financial analysis.
o Build business intelligence objects and reports from various source systems.
o Create user interfaces in both Project Web Access (PWA) and SharePoint.
o Design and build electronic forms to support business processes.
o Create queries and reports for extracting, manipulating, and reporting of business architecture-related information.
• Implementation and Change Management:
o Support development and implementation of change management plans that reduce employee resistance and empower management as change sponsors.
o Focus on the people side of change, including changes to business processes, systems and technology, job roles and skills, and organization structures.
o Facilitate various system verification activities such as systems and user testing.
o Develop and deliver process and systems training to impacted employees.
o Lead system and data integration efforts to connect disparate systems that have various levels of SLC maturity.
o Collaborate and work closely with project sponsor(s), Client manager, the applicable Project Manager(s), project and business teams and stakeholders to remove obstacles impacting timely project completion and to facilitate successful implementation(s).
• Solution Maintenance:
o Provide first line technical support to business users of the developed solutions.
o Complete and improve user manuals, onboarding and training documentation.
o Analyze solutions and business practices for efficiency and effectiveness. Based on the analyses, initiate continuous improvement initiatives.
o Promote the adherence to System Life Cycle (SLC) processes.
o Help the project meet business, schedule, and budget objectives.
o Investigate, gather data, evaluate and analyze whether Client has successfully implemented solutions and/or mitigated risks initially identified; provide findings and any additional solution recommendations as noted or requested.
• Compliance Activities:
o Interview Field personnel to determine what equipment is installed in the field, if the information is not present in the Cascade or BES systems; update system information as appropriate.
o Support other Client North American Electric Reliability Corporation Critical Infrastructure Protection (NERC CIP) or other compliance teams to gain understanding on:
The need for a new Client process or revision to existing Client procedure(s).
New forms or revisions to existing forms that may be needed related to new Client processes.
o As new or revised solutions are proposed and/or adopted for NERC CIP, PRC or FISMA related work:
Gather and document requirements.
Develop or maintain tools, such as spreadsheets, Access databases and SharePoint sites to support implementation of Client management-approved solutions, plans or efforts.
Assist with drafting new or revising existing processes and procedures as requested.
Monitor project schedules to track completed tasks and forecast additional work that may be required
o Develop, draft and recommend records management procedures and schedules for filing, protection and retrieval of records associated with the SPC and PSC equipment in the field related to NERC. Maintain files and records in accordance with and up to the standards of Information Governance & Lifecycle Management (IGLM) requirements.
o Design, draft and recommend forms, reports and/or tools to track progress and verify completion of Field Service Site Inspection works.
o Review, research and study existing processes and propose changes if necessary to achieve alignment between TEC and TT groups; present findings and recommendations.
o For NERC - study existing procedures and processes; document findings and prepare recommendations for new systems or procedures to facilitate compliance with NERC requirements; assist Client personnel with implementation of management-approved recommendations.
o Monitor and track versions and revisions of specialized Software, validating updates are processed in a timely manner.
o Provide assistance on compliance and cyber security quality assurance related issues that may arise:
Identify data quality issues within our asset management systems of record as they apply to compliance and cyber security.
Write quality assurance reports to identify data quality issues within the Cascade system and I2CM Access Database.
o Review incoming data from various sources; apply business rules to manipulate and analyze data, as well as produce reports.
• Communicate with upstream data owners to request follow-up information as needed.
Education & Corresponding Experience:
• A degree in Information Technology, Business Systems, or related field is preferred:
o With an applicable Bachelor’s degree, 8 years of experience is required.
o With an applicable Associates degree, 10 years of experience is required.
o Without an applicable degree, 12 years of experience is required.
• Experience should be consistent with the specific requirements of business systems analysis and progressively more technical in nature.
Required Technical Skills & Experience:
• 5 year experience in the following:
o Conceptualizing and planning initiatives for data integration, gathering, and organization experience.
o Creating Access Databases (with experience modeling robust and intuitive user interfaces), SharePoint sites, advanced Excel spreadsheets, Visio flowcharts and MS Project input.
o Expert level proficiency with MS Excel, including Pivot Tables, Charting and Reporting.
o Automating with VBA (Visual Basic for Applications).
o Business workflow and data workflow management.
o Technical writing skills and the ability to present information in various forms such as textual, graphical and statistical.
o Database structure with experience writing complex queries for data from both native and Open Database Connectivity (ODBC) databases.
o Information Technology business analysis or Cyber-Security business analysis.
o Executing multiple work deliverables with varying and aggressive deadlines and/or responsibilities.
o Project management and/or business analysis and/or business systems analysis experience.
• Advanced skills in:
o Access database design and administration.
o Visio and/or other Flowchart Tools.
o Knowledge of and practical experience in SSRS and/or SQL.
o Logical process modeling concepts sufficient to aid in the documentation of requirements.
o Organizing cross functional meetings.
o Research a variety of data systems, design “queries” and overall missing data research.
o Executing multiple work deliverables with varying and aggressive deadlines and/or responsibilities.
• Knowledge of:
o Microsoft Project Server and Project Web Application (PWA).
o Modeling business process requirements, verification of deliverables.
Preferred Skills & Experience:
• 1 year energy/utility industry experience.
• Experience with NERC CIP or other NERC Reliability Standards or FISMA compliance.
• Knowledge of GIS and Asset Management Systems.
• System Administration including MS SharePoint Site-Level Administration and/or Project Web Application (PWA) Administration.
• Data Modeling and Design, including Relational Database Design, Dimensional Database Design, OLAP Configuration, and/or Tabular & Multi-Dimensional Models.
• Data Management and Reporting, including SQL (T-SQL and PL/SQL), DAX, SSRS (SQL Server Reporting Services), PerformancePoint, Power View, SSMS (SQL Server Management Studio), and/or Oracle SQL Developer.
• Front-End Web Development (for deployment within a MS SharePoint Environment), including HTML, CSS, Java / JQuery, and/or InfoPath.
Valid U.S. Driver’s License is required.
Overtime: 5% anticipated
Travel: Travel Up to 10% local travel
Public Trust Required: Selected candidate must be able to pass the Public Trust (SF-85P) Personnel background investigation in order to qualify for and/or retain this position.
Training Expectations: Worker is expected to keep current on the latest technologies and skills required for the position.