Data Modeler

Actalent; Spokane (WA); Hybrid; USD 66,000 - 72,000; Full time

Job summary

Actalent seeks a Data Modeler to support BPA's Energy Management Systems (EMS) by modeling RTU data, substation interconnections, and ICCP data across multiple EMS habitats. You will develop UI displays per dispatcher specs, such as one-line diagrams, IPS, and RAS, leveraging e-terraHabitat display builders.

The role requires experience in real-time data modeling, collaboration with BPA dispatch centers, and maintaining documentation to ensure reliability and governance.

Qualifications

• Associates or Bachelor's Degree in Computer/Information Technology or closely-related technical discipline is preferred.

Responsibilities

• Model RTU data in the SCADAMOM database per defined timelines.

Skills

Data modeling

UI/UX design

SCADA

Documentation

Habitat displays

Education

Associates or Bachelor’s Degree in Computer/Information Technology or closely-related technical discipline

1 year experience with Bachelor's Degree

3 years experience with Associates Degree

5 years experience without a degree

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 job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include the following: Medical, dental & vision Critical Illness, Accident, and Hospital 401(k) Retirement Plan Pre-tax and Roth post-tax contributions available Life Insurance (Voluntary Life & AD&D for the employee and dependents) Short and long-term disability Health Spending Account (HSA) Transportation benefits Employee Assistance Program Time 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 without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

If you would like to request a reasonable accommodation, such as the modification or adjustment 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 the city and county of San Francisco, we will consider for employment qualified applicants with arrest and conviction records.

Massachusetts Lie Detector: It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall 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 applications and qualifications, but final decisions are made by our hiring team. By applying, you acknowledge and agree that your application may be reviewed using AI tools.