Job Title: Lead Smart Metering Analyst
Reports to: Manager - Smart Metering
Office Location: NY - Rochester - 3 City Ctr or Kirkwood or Binghamton, NY
Salary: The base salary range for this position is dependent upon experience and location, ranging from $85,600-$107,375
NY Advanced Metering Infrastructure (AMI) is a five-year initiative with a budget of ~$500M and is essential for Avangrid grid modernization. The AMI initiative includes the replacement of the existing electric meters and upgrading gas meters with smart devices, which includes the implementation of systems and processes to provide two-way communication. AMI will provide real-time information to improve Avangrid customer service, support power restoration efforts, improve power quality, and enable conservation efforts.
This position will initially report directly to the Program Director within Operational Smart Grids (OSG) and will function as a member of the NY AMI project team to perform daily operations, process and analyze meter data for customer service, web portals, Head-End System (HES) to MDMS integration, and support the initiation of other applications in support of business requirements. The selected person will join a team of technical systems and metering experts and will collaborate with metering peers in Maine and Connecticut, and aid subject matter experts from Avangrid IT, Telecommunications, Distribution Automation, Customer Service, Electric Operations, Gas Operations, and Innovation to assure high data quality. The selected person will support the development of reports using data contained within the HES to guarantee accurate records are maintained for internal / external auditors and be required to troubleshoot meter data and/or infrastructure problems.
Avangrid has multiple offices in New York, Connecticut, and Maine. The person in this position could be based at any regional office in those states including some locations not listed above.
This position will eventually transition to the OSG Smart Metering department which is responsible for strategy, enterprise planning, operation, and compliance of metering systems in Maine, Connecticut, and NY, and will continue to support the on-going operation of the NY AMI MDMS.

Major Roles and Responsibilities:

• Support the overall state of meter data collection within the MDMS.
• Support the data extraction, cleansing, validation, and analysis of massive volumes of data with high accuracy and attention to detail leveraging XML, MS Access, Excel, SQL / Oracle queries, or other similar programs.
• Perform daily data operations in SAP, the MDMS, handheld meter reading devices, and assigned systems.
• Provide expedient and detailed support to the MDMS data users, and function as a Smart Metering liaison to produce specific requests or ad-hoc system operation reports.
• Proactively support the identification of a range of moderate to complex problems including data anomalies, evidence of network risks, issues, meter failures, meter tampering, energy diversion, failed / warned tasks, translation timeouts, interval and register data drops, and failed or rejected validations / edits.
• Analyze possible solutions according to standard practices and procedures.
• Initiate trouble orders with the Meter Engineering and AMI Network Operations areas for field investigation of problematic meter locations, and to troubleshoot metering and infrastructure problems.
• Support Smart Metering for all MDMS installations, meter program software, and security upgrades. Support testing and debugging of upgrades.
• Support the development of MDMS business process documentation, protocols, Standard Operating Procedures.
• Support maintenance activity of MDMS computer files and data as required.
• Provide technical assistance to field personnel.
• Maintain confidentiality of all customer and company data.

JOB REQUIREMENTS:

Preferred Education & Experience:

• Bachelor of Science in Computer Engineering / Computer Science, Mathematics, Economics, Finance, or Statistics, or a minimum of 5 years’ experience working with computer related systems (Associate Degrees and undergraduate course work will be considered).
• Technical background with experience in one or more of the following:
• Technical Hardware Architecture.
• Linux/Unix Operating System.
• Networking and Topology / understanding of high-level network and security concepts, radio networks, firmware updates, wireless protocols, FCC regulations.
• Network functionality and tools including SSH, traceroute, ping, understanding of DHCO, VPN technologies, and firewall concepts.
• Relational DMBS (Oracle/SQL Server/MySQL).
• Windows Server OS and Creating .NET web services.
• Bash/Perl/Python scripting or JAVA on Linux.
• ESRI and JavaScript.
• Experience working with IT.
• Working knowledge of several utility business areas (For example - Electric Operations, Gas Operations, Customer Service, Asset Management & Planning, or IT).
• Knowledge of Meter Data / Electric Operations / Distribution Planning data is a plus.

Required:

• Proficiency in Microsoft Office tools (Word, Excel, Project, SharePoint, Teams).
• Knowledge of Information Technology design and architecture.
• Knowledge of SAP, customer billing, or metering systems.

Skills/Abilities:

• Ability to operate in a fast-paced dynamic environment, multi-task, organize, and manage multiple tasks with minimal supervision.
• Ability to interact with end users and provide expedient and detailed support to data user community.
• Ability to provide technical support to field personnel.
• Ability to communicate and work effectively with others and have strong team skills.
• Strong PC operation and networking skills.
• Interpersonal Skills.
• Analytical Capabilities.
• Agility, versatility, and flexibility; productive in a multi-tasking and rapidly changing environment.
• Metrics design and development.

AVANGRID employees may be assigned a system emergency role and in the event of a system emergency,
may be required to work outside of their regular schedule/job duties.

LI-AM1

Company:

• Support the overall state of meter data collection within the MDMS.
• Support the data extraction, cleansing, validation, and analysis of massive volumes of data with high accuracy and attention to detail leveraging XML, MS Access, Excel, SQL / Oracle queries, or other similar programs.
• Perform daily data operations in SAP, the MDMS, handheld meter reading devices, and assigned systems.
• Provide expedient and detailed support to the MDMS data users, and function as a Smart Metering liaison to produce specific requests or ad-hoc system operation reports.
• Proactively support the identification of a range of moderate to complex problems including data anomalies, evidence of network risks, issues, meter failures, meter tampering, energy diversion, failed / warned tasks, translation timeouts, interval and register data drops, and failed or rejected validations / edits.
• Analyze possible solutions according to standard practices and procedures.
• Initiate trouble orders with the Meter Engineering and AMI Network Operations areas for field investigation of problematic meter locations, and to troubleshoot metering and infrastructure problems.
• Support Smart Metering for all MDMS installations, meter program software, and security upgrades. Support testing and debugging of upgrades.
• Support the development of MDMS business process documentation, protocols, Standard Operating Procedures.
• Support maintenance activity of MDMS computer files and data as required.
• Provide technical assistance to field personnel.
• Maintain confidentiality of all customer and company data