Data Modeler 1

Job Description

Job Description

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.

Implement changes according to defined timelines in the modeling of Remote Terminal Unit (RTU) data in the SCADAMOM database

Implement changes according to defined timelines in the modeling of substation interconnections in the NETMOM database

Implement changes according to defined timelines in the modeling of Inter-Control Center Communications Protocol (ICCP) data in the OAGMOM database

Validate models, including interdependencies between the Supervisory Control and Data Acquisition (SCADA) and Network models critical to the safety and reliability of the power grid.

Develop and maintain user-interface displays in accordance with dispatcher specifications, including one-line diagrams, Intertie Protection Scheme (IPS) and Remedial Action Scheme (RAS) displays and tabular displays. This requires a working knowledge of e-terraHabitat display builders.

Provide support for the bi-weekly deployment of updated EMS databases and displays to the operational systems, coordinating closely with BPA Dispatchers at both Dittmer Control Center (DCC) and Munro Control Center (MCC) and assist with unscheduled/emergency deployments

Develop and maintain documentation related to all EMS database and display maintenance and troubleshooting.

Collaborate with EMS teams, Dittmer and Munro Dispatch, T&E, the field and other stakeholders to develop modeling and user display standards to promote reliability and consistency.

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.

REQUIREMENTS

Education & Corresponding Experience (required on matrix)

Associate's or Bachelor's Degree in Computer/Information Technology or a closely-related technical discipline is preferred:

1 year of experience is required with an applicable Bachelor's Degree.

3 years of experience is required with an applicable Associate's Degree.

5 years of experience is required without a degree or applicable degree.

Experience should include working with logical data models, not just physical/DBA experience

Required Technical Skills & Experience (required on matrix)

At least 1 year of "User Interface/User Experience” (UI/UX) design experience and at least 1 year of hands-on experience modeling and supporting real-time critical data; or

At least 1 year of experience providing support to an electric utility control center and at least 1 year of experience working with Industrial Control Systems (e.g., SCADA)

Preferred Skills & Experience (optional on matrix)

1 year of hands-on experience working with hierarchical databases in Client-Alstom products to model power grid information for use in a control center environment.

Experience conducting data modeling sessions with business users and technical staff, which includes conveying complex ideas both verbally and in written form.

Knowledge of and understanding of database management system administration with regard to performance, configuration and denormalization.

Experience leading efforts to verify system test data is loaded accurately and in timely manner.

Knowledge of Client-Alstom e-terraHabitat databases and displays.

Knowledge of NERC-CIP and FISMA requirements.

Experience with Microsoft Visual Studio.

Additional Requirements (not required on matrix)
Valid U.S. Driver's License is required.