Data Modeler

Description

• 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
• Implement changes according to defined timelines in the modeling of Remote Terminal Unit (RTU) data in the SCADAMOM database, substation interconnections in the NETMOM database, and of Inter-Control Center Communications Protocol (ICCP) data in the OAGMOM database.
• Develop and maintain documentation related to all EMS database and display maintenance and troubleshooting.
• 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.
• 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.
• 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.
• Validate models, including interdependence between the Supervisory Control and Data Acquisition (SCADA) and Network models critical to the safety and reliability of the power grid.

Requirements

• 3 years of experience is required with an applicable Associate’s Degree.
• Knowledge of GE-Alstom e-terraHabitat databases and displays.
• 2 years of experience directly supporting database modeling in a science/engineering organization.
• 1 year of experience directly supporting the development and maintenance of GE-Alstom e-terraHabitat hierarchical databases and displays, OR
• Experience should include working with logical data models, not just physical/DBA experience
• 1 year of hands-on experience working with hierarchical databases in GE-Alstom products to model power grid information for use in a control center environment.
• 1 year of experience is required with an applicable Bachelor’s Degree.
• 5 years of experience is required without a degree or applicable degree.
• Experience leading efforts to verify system test data is loaded accurately and in timely manner.
• Knowledge of NERC-CIP and FISMA requirements.
• Knowledge of and understanding of database management system administration with regard to performance, configuration and denormalization.
• Experience conducting data modeling sessions with business users and technical staff, which includes conveying complex ideas both verbally and in written form.
• Experience with Microsoft Visual Studio.
• Associate’s or Bachelor’s Degree in Computer/Information Technology or a closely-related technical discipline is preferred:

Benefits

• Health Spending Account (HSA)
• 401(k) Retirement Plan – Pre-tax and Roth post-tax contributions available
• Transportation benefits
• Critical Illness, Accident, and Hospital
• Life Insurance (Voluntary Life & AD&D for the employee and dependents)
• Time Off/Leave (PTO, Vacation or Sick Leave) Workplace Type This is a fully onsite position in Mead,WA. Application Deadline This position is anticipated to close on Dec 30, 2025.
• Medical, dental & vision
• Employee Assistance Program
• Short and long-term disability

Training + Development

Interview process

Visa Sponsorship

Security clearance