Data Modeler

Actalent; United States; Hybrid; USD 66,000 - 72,000; Full time

Benefits offered by this job

Medical, dental & vision

401(k) Retirement Plan

Life Insurance

Short/long-term disability

Health Savings Account

Time Off

Job summary

Actalent is seeking a Data Modeler to support BPA's Energy Management Systems, focusing on EMS habitat data modeling, display development, and database maintenance. You will work with SCADA/NETMOM/OAGMOM databases and coordinate deployments with dispatch centers in a hybrid Spokane setting.

Qualifications include IT degree relevance, 1–5 years depending on degree, and hands-on UI/UX and real-time data modeling experience. Experience with GE-Alstom e-terraHabitat and Visual Studio is a plus.

Qualifications

• Associates or Bachelors Degree in Computer/Information Technology or a closely-related technical discipline is preferred
• 1 year of experience is required with an applicable Bachelors Degree
• 3 years of experience is required with an applicable Associates 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
• At least 1 year of UI/UX design experience and at least 1 year of hands-on experience modeling real-time data
• 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)

Responsibilities

• Implement changes according to defined timelines in the modeling of 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 ICCP data in the OAGMOM database
• Validate models, including interdependencies between SCADA and Network models
• Develop and maintain user-interface displays per dispatcher specifications using e-terraHabitat display builders
• Coordinate bi-weekly deployment of updated EMS databases and displays with BPA Dispatchers at DCC and MCC
• Develop and maintain documentation for EMS databases and displays
• Collaborate with EMS teams and stakeholders to develop modeling/display standards
• Mark and file documents compliant with INFOSEC/IGLM standards and auditing requirements

Skills

Data modeling

UI/UX design

Realtime data modeling

Electric utility experience

SCADA

Education

Associate or Bachelor's degree in IT

Tools

GE-Alstom e-terraHabitat

Microsoft Visual Studio

Job description

This Data Modeler assignment will provide support to the Energy Management Systems (EMS) organization (JDE) at Bonneville Power Administration (BPA) 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.

Responsibilities Include:

• 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.

Qualifications

• Associates or Bachelors Degree in Computer/Information Technology or a closely-related technical discipline is preferred:
• 1 year of experience is required with an applicable Bachelors Degree.
• 3 years of experience is required with an applicable Associates 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
• 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 and 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.
• 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 GE-Alstom e-terraHabitat databases and displays.
• Knowledge of NERC-CIP and FISMA requirements.
• Experience with Microsoft Visual Studio.

Job Type & Location

This is a Contract position based out of Spokane, WA.

Pay and Benefits

The pay range for this position is $48.00 - $52.00/hr.

Individual compensation offered for this position within this range will depend on many factors, including qualifications, skills, relevant experience, job knowledge, geographic location, internal equity, and other pertinent job‑related factors.

Eligibility requirements apply to some benefits and may depend on your jobclassification and length of employment. Benefits are subject to change and may besubject to specific elections, plan, or program terms. If eligible, the benefitsavailable for this temporary role may include the following:

• Medical, dental & visionCritical Illness, Accident, and Hospital401(k) Retirement Plan Pre-tax and Roth post‑tax contributions availableLife Insurance (Voluntary Life & AD&D for the employee and dependents)Short and long‑term disabilityHealth Spending Account (HSA)Transportation benefitsEmployee Assistance ProgramTime Off/Leave (PTO, Vacation or Sick Leave)

Workplace Type

This is a hybrid position in Spokane,WA.

Application Deadline

This position is anticipated to close on Oct 7, 2026.

About Actalent

Actalent is a global leader in engineering and sciences services and talent solutions. We help visionary companies advance their engineering and science initiatives through access to specialized experts who drive scale, innovation and speed to market. With a network of almost 20,000 consultants and 5,000 clients across the U.S., Canada, Asia and Europe, Actalent serves many of the Fortune 500. We are proud to be an Engineering News-Record (ENR) Top 500 Design Firm for our engineering design services and a ClearlyRated Best of Staffing® winner for both client and talent service.

The company is an equal opportunity employer and will consider all applications withoutregard to race, sex, age, color, religion, national origin, veteran status, disability,sexual orientation, gender identity, genetic information or any characteristic protectedby law.

If you would like to request a reasonable accommodation, such as the modification oradjustment of the job application process or interviewing process due to a disability,please email [e-mail] for other accommodation options.

San Francisco Fair Chance Ordinance:

Pursuant to the San Francisco Fair Chance Ordinance, for all positions located in thecity and county of San Francisco, we will consider for employment qualified applicantswith arrest and conviction records.

Massachusetts Lie Detector:

It is unlawful in Massachusetts to require or administer a lie detector test as acondition of employment or continued employment. An employer who violates this lawshall be subject to criminal penalties and civil liability.

Use of Artificial Intelligence (AI):

We may use Artificial Intelligence (AI) to support parts of our hiring process,including sourcing, screening, and evaluating candidates. AI helps assess applicationsand qualifications, but final decisions are made by our hiring team. By applying, youacknowledge and agree that your application may be reviewed using AI tools.