EIM Load & Reconciliation Analyst I,II

POSTING DEADLINE

This position is posted until filled.

DEPARTMENT

Department:  Power Operations
 

JOB DESCRIPTION

EIM Load & Reconciliation Analyst

Salary Grade: G09
Minimum  Midpoint  Maximum
$50,991 - $67,562 - $84,134

This position is covered by NERC CIP cyber security standards.  Prior to being hired, promoted, or transferred into the position, the candidate must successfully pass a Personnel Risk Assessment, which includes identity verification and a criminal background check.  Prior to being granted unescorted access to cyber secure areas, the candidate must attend cyber security training. Annual cyber security training is also required.

SUMMARY:

Under general supervision, creates and maintains extensive databases of EIM related load, generation, and wholesale MW Interchange data using Wholesale MV90 Megawatt hourly database.  Also supports Balancing Authority Area Day After and Month End Interchange checkout activities.

ESSENTIAL DUTIES AND RESPONSIBILITIES:

Reviews raw data from MV90 Wholesale Meter Data System in accordance with CAISO data standards

Monitors, tests, troubleshoots, and coordinates the repair of faulty data transmission to the MV90 Wholesale Data System prior to submission

Reconciles data from MV90 system and ensures accurate data is transferred into additional EIM related analysis systems

Performs verification, editing, and data estimating (VEE) of meter data

Provides CAISO related Energy Transfer System Resource and EIM related Interchange support to PNM Balancing Authority (BA), Energy Analysis, CAISO Settlements and External Transmission Network Customers

Troubleshoots and ensures proper conformance of revenue quality meter data (RQMD) to other systems

Maintains the integrity of MW energy data by performing checkout balancing and enforcing routine control procedures for PNM BA Area Day After, Weekly, Bi-weekly, and Month End Interchange checkout activities

Researches issues and inquiries received from Reliability Operations and processes required corrections

Submits PNM annual Mwh reporting and settlements

Provides load and economic analyses for various departments throughout the Company

Participates in dispute resolution of 5-minute, 15-minute, and hourly data discrepancies


COMPETENCIES:                  

Strong analytical skills and knowledge of standard and generally accepted practices in western utilities and CAISO systems and load research techniques.

Ability to recognize business-planning activities directly or indirectly concerned with load forecasting, load research or program evaluation issues and to participate in those activities where appropriate

Requires strong interpersonal skills in high-pressure situations and strong organizational skills.

Ability to employ creative problem solving techniques covering a wide variety of topics both in and out of the immediate areas of responsibility

Thorough knowledge of the databases, NERC Balancing Authority balancing requirements, and Open Access Transmission Tariff (OATT) responsibilities.

QUALIFICATIONS                   

MINIMUM EDUCATION AND/OR EXPERIENCE: 

Bachelor's degree from four-year college or university in Economics, Statistics, Mathematics or related field with one to three years related experience, or equivalent combination of education and/or experience related to the discipline. 

COMMUNICATION SKILLS:                  
Ability to read and interpret documents such as safety rules, operating and maintenance instructions, and procedure manuals

Ability to write routine reports and correspondence

Ability to speak effectively before groups of customers or employees of organization

MATHEMATICAL SKILLS:                  
Ability to calculate figures and amounts such as discounts, interest, commissions, proportions, percentages, area, circumference, and volume

Ability to apply concepts of basic algebra and geometry

COMPUTER SKILLS:                  

Working knowledge of personal computer hardware, operating systems and software, and of mainframe computer systems

Specialized training is required in PCI DBase logic programming and EA operating systems; and PC hardware, operating systems, spreadsheets, and word processors

Basic knowledge of SAS-language programming skills in MV90 Wholesale operating system

Knowledge of the operational capabilities of the translation computers software and hardware

¿
ANALYSIS AND PROBLEM-SOLVING ABILITY: 

Ability to apply common sense understanding to carry out instructions furnished in written, oral, or diagram form.  Ability to deal with problems involving several concrete variables in standardized situations.  Ability to complete processes in support of key business activities and goals.  Ability to resolve data integrity issues and deal with a variety of variables in situations where only limited standardization exists.

PHYSICAL DEMANDS:                  

While performing the duties of this job, the employee is regularly required to sit up to 2/3 of the time. The employee must occasionally lift and/or move up to 10 pounds.

WORK ENVIRONMENT:                  

Office environment.

JOB DESCRIPTION

EIM Load & Reconciliation Analyst II

Salary Grade: G07
Minimum  Midpoint  Maximum
$66,267 - $87,804 - $109,340

This position is covered by NERC CIP cyber security standards.  Prior to being hired, promoted, or transferred into the position, the candidate must successfully pass a Personnel Risk Assessment, which includes identity verification and a criminal background check.  Prior to being granted unescorted access to cyber secure areas, the candidate must attend cyber security training. Annual cyber security training is also required.

SUMMARY:

Under general supervision, conducts research to aid in interpretation of economic relationships and aid in the solution of problems specific to load research and data analysis associated with the PNM MV90 Wholesale database. This position will also use EIM Energy Accounting Systems to verify data quality of Mv90 meter data and ensure proper conformance of data for transmission to CAISO/PNM Settlement systems. Position will also support Balancing Authority Area Day After and Month End Interchange checkout activities.

ESSENTIAL DUTIES AND RESPONSIBILITIES:

Creates and maintains extensive data-sets of EIM related load, generation, and Wholesale MW Interchange data using Wholesale MV90 Megawatt hourly database

Inputs and runs reports within database to analyze data and create reports for internal and external parties

Maintains the integrity of MW energy data by performing checkout balancing and enforcing routine control procedures for Day After, Weekly, Bi-weekly and Month End Interchange transactions

Monitors, tests, troubleshoots and coordinates the repair of faulty data transmission into the MV90 Wholesale Meter Data System

Will conduct analytical review of raw data from the MV90 Wholesale Meter Data System in accordance with CAISO data standards

Reconciles the data from the MV90 System to ensure accurate data is transferred into EIM hierarchal systems

Utilizie the EIM hierarchal systems to verify, properly format, and evaluate any substitution of data for the 5-minute, 15-minute, and hourly data from over 100 Intertie and generation meters

Reviews and validates 5-minute, 15-minute, and hourly data and troubleshoot discrepancies as part of the initial settlement reconciliation process with CAISO invoices

Coordinates with adjacent Intertie Entities and Transmission Network customer services for daily balancing transactional functions to meet NERC compliance requirements

Provides CAISO related Energy Transfer System Resource and EIM related Interchange support to PNM Balancing Authority, Energy Analysis, CAISO Settlements and External Transmission Network Customers

Dispute resolution of 5-minute, 15-minute, hourly data discrepancies. Review from over 100 intertie and generation meters in coordination with CAISO settlement business practices and business timelines for dispute resolution

Submits to WECC and RC West PNM's annual MWh reporting and settlements and PNM's annual settlement with SPP for Unscheduled Flow Mitigation MWh¿s. Provides load and economic analyses for various departments in the Company, as needed.

Performs ad hoc SAS-language programming; loads and maintains new Wholesale MV90 system software releases and tracking on meter communication issues to be completed by communications technicians


COMPETENCIES:                  

Strong analytical skills and in-depth knowledge of standard and generally accepted practices in western utilities and CAISO systems and load research techniques.

Ability to recognize business-planning activities directly or indirectly concerned with load forecasting, load research or program evaluation issues and to participate in those activities where appropriate

Requires strong interpersonal skills in high-pressure situations and strong organizational skills.

Ability to employ creative problem solving techniques covering a wide variety of topics both in and out of the immediate areas of responsibility

Thorough knowledge of the databases, NERC Balancing Authority balancing requirements, and Open Access Transmission Tariff (OATT) responsibilities.

Strongly versed in continuous process improvement, root cause analysis, and change management.

QUALIFICATIONS                   

MINIMUM EDUCATION AND/OR EXPERIENCE: 

Bachelor's degree from four-year college or university in Economics, Statistics, Mathematics or related field with three to five years related experience, or equivalent combination of education and/or experience related to the discipline. 

COMMUNICATION SKILLS:                  
Ability to read and interpret documents such as safety rules, operating and maintenance instructions, and procedure manuals

Ability to write routine reports and correspondence

Ability to speak effectively before groups of customers or employees of organization

MATHEMATICAL SKILLS:                  
Ability to calculate figures and amounts such as discounts, interest, commissions, proportions, percentages, area, circumference, and volume

Ability to apply concepts of basic algebra and geometry

COMPUTER SKILLS:                  

Working knowledge of personal computer hardware, operating systems and software, and of mainframe computer systems

Specialized training is required in PCI DBase logic programming and EA operating systems; and PC hardware, operating systems, spreadsheets, and word processors

Basic knowledge of SAS-language programming skills in MV90 Wholesale operating system

Knowledge of the operational capabilities of the translation computers software and hardware

¿
ANALYSIS AND PROBLEM-SOLVING ABILITY: 

Ability to apply common sense understanding to carry out instructions furnished in written, oral, or diagram form.  Ability to deal with problems involving several concrete variables in standardized situations.

PHYSICAL DEMANDS:                  

While performing the duties of this job, the employee is regularly required to sit up to 2/3 of the time. The employee must occasionally lift and/or move up to 10 pounds.

WORK ENVIRONMENT:                  

Office environment.

EQUAL OPPORTUNITY STATEMENT

Safety Statement:
Safety is a core value at (TXNM Energy/PNM/TNMP) and our vision, “everyone goes home safe”, reflects our commitment to promoting an environment conducive to learning, improving and building safety practices. Our safety value is built upon the belief that every employee deserves to work in an environment free from harm.

Americans with Disabilities Act (ADA) Statement: 
TXNM Energy is committed to providing reasonable accommodations for qualified individuals with disabilities in compliance with the ADA. If you require assistance with the job application process due to a disability, please contact HR ADA Analyst, at 505-241-4627.

DEI Statement:
At TXNM Energy, we value the diversity of our workforce and actively seek opportunities for incorporating Diversity, Equity, and Inclusion (DEI) within our family of companies. We believe a diverse workforce enriches our environment and helps us better meet the needs of our employees, customers, and shareholders.  We remain committed to attracting and sustaining a diverse workforce and retaining high-performing employees who work collaboratively to carry out the Company's purpose.

TXNM Energy and affiliates are Equal Opportunity/Affirmative Action employers.  Women, minorities, disabled individuals and veterans are encouraged to apply.