Data Modeler 1

First Tek, Inc.
  • Spokane, WA
  • Instant Apply
30+ days ago

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.

 

Numbers & Facts

LocationSpokane, WA

Skills

  • Auditingunmatched
  • Business Modelunmatched
  • Communications Protocolsunmatched
  • Control Systemsunmatched
  • Data Modelingunmatched
  • Database Management Software/Systems (DBMS)unmatched
  • Documentationunmatched
  • Driver's Licenseunmatched
  • Electrical Utilityunmatched
  • Identify Issuesunmatched
  • Information Modelsunmatched
  • Information Technology & Information Systemsunmatched
  • Intrusion Prevention Systemsunmatched
  • Leadershipunmatched
  • Model Validationunmatched
  • Record Keepingunmatched
  • Supervisory Control and Data Acquisition (SCADA)unmatched
  • System Testunmatched
  • Systems Administration/Managementunmatched
  • Test Dataunmatched
  • Time Managementunmatched
  • User Interface/Experience (UI/UX)unmatched

Level up your application

Professional resume templates

Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

Free resume templates

Resume Builder

Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

Resume Builder