Data Modeler

Requirements:

• We prefer an associates or bachelors degree in computer/information technology or a closely related technical discipline. Required experience varies by education: 1 year with an applicable bachelors degree, 3 years with an applicable associates degree, or 5 years without an applicable degree.
• We require experience working with logical data models, beyond physical database administration.
• We require either at least 1 year of UI/UX design experience and 1 year of hands-on experience modeling and supporting real-time critical data, or at least 1 year supporting an electric utility control center and 1 year working with industrial control systems such as SCADA.
• We require a valid U.S. drivers license.
• Preferred experience includes working with hierarchical databases in Client-Alstom products to model power-grid information for control-center use.
• Preferred experience includes conducting data-modeling sessions with business users and technical staff, and communicating complex ideas verbally and in writing.
• Preferred knowledge includes database management system administration related to performance, configuration, and denormalization.
• Preferred experience includes leading efforts to verify that system test data is loaded accurately and on time.
• Preferred knowledge includes Client-Alstom e-terraHabitat databases and displays, and NERC-CIP and FISMA requirements.
• Experience with Microsoft Visual Studio is preferred.

Responsibilities:

• We implement changes to Remote Terminal Unit (RTU) data models in the SCADAMOM database according to defined timelines.
• We implement changes to substation interconnection models in the NETMOM database according to defined timelines.
• We implement changes to Inter-Control Center Communications Protocol (ICCP) data models in the OAGMOM database according to defined timelines.
• We validate models and dependencies between SCADA and network models that are critical to power-grid safety and reliability.
• We develop and maintain user-interface displays to dispatcher specifications, including one-line diagrams, Intertie Protection Scheme (IPS) and Remedial Action Scheme (RAS) displays, and tabular displays.
• We support bi-weekly deployments of updated EMS databases and displays to operational systems, coordinating with dispatchers at Dittmer and Munro Control Centers and assisting with unscheduled or emergency deployments.
• We develop and maintain documentation for EMS database and display maintenance and troubleshooting.
• We collaborate with EMS teams, dispatchers, T&E, field personnel, and other stakeholders to develop modeling and display standards that promote reliability and consistency.
• We mark and maintain documents, files, emails, and records according to compliance requirements; share documents only with personnel who have a lawful government purpose to access them; and maintain official records under INFOSEC and IGLM standards and procedures for audit purposes.
• We ensure official drafts, documents, and recommendations are reviewed, finalized, and approved or accepted by an authorized BPA manager or other federal personnel.

Technologies:

• Support
• Network
• Visual Studio
• UX UI Design
• Matrix
• Security

More

This role supports EMS database and display modeling for power-grid control-center operations. The work involves coordination with dispatchers at the Dittmer and Munro Control Centers, EMS teams, field personnel, and other stakeholders. The position uses e-terraHabitat display-building tools; related experience with Client-Alstom products, utility control centers, and real-time critical data is relevant.

last updated 44 week of 2026