Job #: 8923
Location: Vancouver, WA
Job Length: 1+ years
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. 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 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 it has for non-compliance with NERC and our requirements and standards. To successfully advance the aforementioned work, the BA in this position will perform the following:
⦁ Coordinate activities for manager-assigned projects that enable goals or objectives to be accomplished within the prescribed time frame and funding parameters, escalating concerns to appropriate manager / personnel.
⦁ Compile, review and analyze information in order to collaborate with 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.
⦁ Conduct interviews and lead workshops to elicit business requirements.
⦁ 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.
⦁ Decompose high-level information into details and abstract up from low-level information to distinguish between solution ideas and business needs.
⦁ Lead requirements validation sessions and present back the findings.
Solution Development and Proposal:
⦁ Design architecture and solutions based on requirements and best practices.
⦁ Focus on efficiency of various workgroups involved in Project Execution.
⦁ Look for ways to automate repetitive manual data manipulations.
⦁ Use Rapid System Development methods to build prototypes.
⦁ Develop solutions that integrate the various Portfolio; Project; GIS and Asset Management systems.
⦁ Complete all 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 key stakeholders and sponsors.
⦁ Prepare functional and technical documentation for hand-off to IT workgroups.
⦁ Work closely with appropriate development teams to ensure a smooth build.
⦁ Create documentation for user and operational manuals.
⦁ Design, build and implement desktop tools and systems to support portfolio and project management; project scheduling and project financial analysis.
⦁ Build business intelligence objects and reports from various source systems.
⦁ Create user interfaces in both Project Web Access (PWA) and SharePoint.
⦁ Design and build electronic forms to support business processes.
⦁ Create queries and reports for extracting, manipulating, and reporting of business architecture-related information.
Implementation and Change Management:
⦁ Support development and implementation of change management plans that reduce employee resistance and empower management as change sponsors.
⦁ Focus on the people side of change, including changes to business processes, systems and technology, job roles and skills, and organization structures.
⦁ Facilitate various system verification activities such as systems and user testing.
⦁ Develop and deliver process and systems training to impacted employees.
⦁ Lead system and data integration efforts to connect disparate systems that have various levels of SLC maturity.
⦁ Collaborate and work closely with project sponsor(s), management, the applicable Project Manager(s), project and business teams and stakeholders to remove obstacles impacting timely project completion and to facilitate successful implementation(s).
⦁ 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, initiate continuous improvement initiatives.
⦁ Promote the adherence to System Life Cycle (SLC) processes.
⦁ Help the project meet business, schedule, and budget objectives.
⦁ Investigate, gather data, evaluate and analyze whether the client has successfully implemented solutions and/or mitigated risks initially identified; provide findings and any additional solution recommendations as noted or requested.
⦁ 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.
⦁ Support other North American Electric Reliability Corporation Critical Infrastructure Protection (NERC CIP) or other compliance teams to gain understanding on:
⦁ The need for a new process or revision to existing procedure(s).
⦁ New forms or revisions to existing forms that may be needed related to new processes.
⦁ 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 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.
⦁ 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.
⦁ Design, draft and recommend forms, reports and/or tools to track progress and verify completion of Field Service Site Inspection works.
⦁ Review, research and study existing processes and propose changes if necessary, to achieve alignment between TEC and TT groups; present findings and recommendations.
⦁ For NERC - study existing procedures and processes; document findings and prepare recommendations for new systems or procedures to facilitate compliance with NERC requirements; assist personnel with implementation of management-approved recommendations.
⦁ Monitor and track versions and revisions of specialized Software, validating updates are processed in a timely manner.
⦁ 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.
⦁ 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.
⦁ Bachelor’s Degree in Information Technology, Business Systems, or a related technical discipline is required. Bachelor’s Degree in a technical, business or related field can be substituted for 4 years of required experience.
⦁ 12 years’ experience in a combination of work-related, on-the-job training, and/or vocational training. Experience should be consistent with the specific requirements of business systems analysis and progressively more technical in nature.
5 years of experience in the following:
⦁ Conceptualizing and planning initiatives for data integration, gathering, and organization experience.
⦁ Creating Access Databases (with experience modeling robust and intuitive user interfaces), SharePoint sites, advanced Excel spreadsheets, Visio flowcharts and MS Project input.
⦁ Expert level proficiency with MS Excel, including Pivot Tables, Charting and Reporting.
⦁ Automating with VBA (Visual Basic for Applications).
⦁ Business workflow and data workflow management.
⦁ Technical writing skills and the ability to present information in various forms such as textual, graphical and statistical.
⦁ Database structure with experience writing complex queries for data from both native and Open Database Connectivity (ODBC) databases.
⦁ Information Technology business analysis or Cyber-Security business analysis. o Executing multiple work deliverables with varying and aggressive deadlines and/or responsibilities.
⦁ Project management and/or business analysis and/or business systems analysis experience.
Advanced skills in:
⦁ Access database design and administration.
⦁ Visio and/or other Flowchart Tools.
⦁ Knowledge of and practical experience in SSRS and/or SQL.
⦁ Logical process modeling concepts sufficient to aid in the documentation of requirements.
⦁ Organizing cross functional meetings.
⦁ Research a variety of data systems, design “queries” and overall missing data research.
⦁ Executing multiple work deliverables with varying and aggressive deadlines and/or responsibilities.
⦁ Knowledge of:
⦁ Microsoft Project Server and Project Web Application (PWA).
⦁ Modeling business process requirements, verification of deliverables.
Preferred Skills & Experience
⦁ 1 year of 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.
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.
Founded in 2002, ieSolutions is recognized as one of the largest locally owned Talent Staffing Services company headquartered in Portland, Oregon. We deliver our best each day to provide Reliable, Fair, Collaborative and Compassionate services to our customers, candidates and employees.
Collaborating with our customers, we augment their workforce with technical and administrative talent. We provide information technology, engineering, operation, technician, analyst, project management and administrative talent to our clients throughout the Pacific Northwest.
Our employees receive a competitive compensation package which includes health benefits, disability insurance, access to a 401k plan, paid-time-off and a continued professional development/education benefit.
ieSolutions is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by law.