First Tek, Inc. · 1 month ago
Data Modeler 1
Spokane, WA
Full-time
Hybrid
Entry Level
1+ years expFirst Tek, Inc. is a company providing support to the Energy Management Systems (EMS) organization at BPA. The Data Modeler position involves maintaining accurate EMS databases and displays, performing data modeling, and collaborating with various teams to ensure the reliability and consistency of the power grid operations.
Human ResourcesInformation TechnologyStaffing Agency
No H1B
Security Clearance RequiredU.S. Citizen Only
Responsibilities
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
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
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, 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
Qualification
Required
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
1 year of experience directly supporting the development and maintenance of Client-Alstom e-terraHabitat hierarchical databases and displays, OR
2 years of experience directly supporting database modeling in a science/engineering organization
Preferred
1 year of hands-on experience working with hierarchical databases in Client-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
Experience using JIRA for work tracking
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 Client-Alstom e-terraHabitat databases and displays
Knowledge of NERC-CIP and FISMA requirements
Experience with Microsoft Visual Studio
Company
First Tek, Inc.
To succeed in the complex world of technology, you need exceptional connections – to the right experts, the right opportunities and the right answers.
1001-5000 employees
Funding
Current Stage
Late StageLeadership Team
Kumar Bhavanasi
Founder, President and CEO
Recent News
Company data provided by crunchbase