Data Modeler 1

CorSource; Spokane (WA); On-site; USD 90,000 - 120,000; Full time

Job summary

CorSource Technology Group is seeking a Data Modeler to support EMS databases and displays in Spokane. The role involves modeling RTU data, substation interconnections, and ICCP data, plus maintaining EMS habitat displays and documentation.

Ideal candidates have 1–5 years of relevant data modeling and UI/UX experience, with exposure to SCADA and electric utility control centers, and the ability to collaborate across dispatch, IT, and field teams.

Qualifications

• Associate’s or Bachelor’s Degree in Computer/Information Technology or a closely-related technical discipline is preferred.
• 1 year of experience with an applicable Bachelor’s Degree.
• 3 years of experience with an applicable Associate’s Degree.
• 5 years of experience without a degree or applicable degree.
• Experience should include working with logical data models, not just physical/DBA experience.
• At least 1 year of UI/UX design experience and at least 1 year of hands-on experience modeling 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 (SCADA).

Responsibilities

• 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 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.
• Provide support for the bi-weekly deployment of updated EMS databases and displays to the operational systems.
• 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.

Skills

UI/UX design

Real-time data modeling

Electric utility experience

SCADA systems

Education

Associate’s or Bachelor’s Degree in Computer/Information Technology

Job description

We are CorSource Technology Group, a locally owned technical staffing and recruiting firm in Portland, Oregon.

19889
Data Modeler 1
12 months
Spokane

This position closes to submittals on October 7th. Position requires the ability to meet federal background and compliance requirements.

OVERVIEW

Assignment

This contract Data Modeler assignment will provide support to the Energy Management Systems (EMS) organization (JDE) at the Company. in maintaining accurate and up-to-date EMS databases and displays. Energy Management Systems (EMS) are used by Dispatchers to monitor, control, and optimize the power grid.

This position will support the operations and maintenance of EMS Habitat systems hosted on the core Control Center Network (CCN) and the CCN DMZ. This position will perform EMS Habitat system data modeling, display modeling, database updates, providing customer coordination, facilitating custom software scripts, and maintaining quality documentation.

Organization

Operational Technology Services (J-OT) provides technology management oversight and leadership to enable Transmission Services to carry out Company’s mission and achieve strategic business objectives. Application Services (JD) is responsible for the planning, analysis, design, engineering, delivery, and maintenance support of systems used to provide safe and reliable real- time control, dispatch, analysis, management, and protection of the management system. JDE Company’s life-cycle support for Energy Management Systems (EMS) used in support of Company’s control centers. Organizational responsibility also includes verification of applicable cyber security functions (per North American Electric Reliability Corporation (NERC), Federal Information Security Management Act (FISMA), National Institute of Standards and Technology (NIST), and company standards); and, supplemental project support

ASSIGNMENT RESPONSIBILITIES

Note: All official drafts, documents and recommendations, as listed below, must be reviewed, finalized and approved / accepted by appropriate 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 the 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)

All qualified applicants at CorSource Technology Group will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.