Meter Data Management (MDM), Billing Data Analyst

TECO Energy•Tampa, FL

6d•Onsite

About The Position

The MDM Data Analyst is responsible for the daily monitoring, management and analysis of Meter Data Management (MDM) system data to ensure optimal network health, prompt resolution of exceptions, and accurate synchronization of data across the MDM, CRM and the Advanced Metering Infrastructure (AMI) head-end. Analysis, troubleshooting and exception handling for the end-to-end meter to cash process are the primary responsibilities of the MDM Data Analyst.

Requirements

High School diploma or equivalent.
4 years of relevant experience with metering and billing functions.
Ability to interpret data and analyze results
Critical thinking skills with the ability to uncover and synthesize connections
Inquisitive and persistent in finding resolutions to problems, including the ability to follow the data flows through the various integrations
Ability to take initiative to create new methods and solutions to achieve end results
Ability to interact and coordinate with other departments resulting in positive outcomes and actions ensuring timely transfer and receipt of meter data
Excellent interpersonal, administrative, organizational, communication, analytical and time management skills
Excellent working knowledge of customer service and billing functions acquired through utility billing and customer service experience
Exceptional troubleshooting and problem-solving skills

Nice To Haves

Bachelor’s degree in business related field.
Experience working with Advanced Meter Infrastructure (AMI) and Meter Data Management (MDM) System and Customer Information System.

Responsibilities

Monitors daily synchronization between CRM, AMI head-end and MDM, ensuring accurate synchronization of data across all systems. Troubleshoots data anomalies and identifies and tracks trends to uncover potential data issues and log defects. Analyzes data imported into the MDM from other business units (e.g. Smart Street Lights).
Analyzes and addresses exceptions related to validation and estimation within the network by interpreting reports and identifying and resolving errors. Coordinates with internal departments and third-party vendors to analyze, troubleshoot and address exceptions. Proactively-resolves billing exceptions where possible. Acts as the point of escalation to support other business units (e.g., analyze data to troubleshoot high bill complaints).
Reviews key network performance metrics daily (including percentage of register and interval readings), identifies and tracks trends and addresses issues to ensure optimal network health and performance. Provides status reporting on network performance, data collection issues, synchronization and exception handling. Analyzes network performance to determine if infrastructure issues should be communicated to the AMI vendor.
Monitors and investigates data collection issues, such as stale meters. Troubleshoots to identify the root cause of a data collection issue (e.g., conducts mapping to determine if a stale meter problem is related to the AMI network or if the location was previously stale). Identifies and tracks trends. Monitors for “soft failures” (e.g., spikes, maximum demand) to check for abnormal consumption patterns or to locate problematic meters. Generates service orders for work to be performed in support of customer billing, such as re-reads, reading correction, field investigation of stale meters and data gaps.
Works with other departments to support implementation and testing of required CRM software/process changes for Billing, Metering, and Customer Service that may impact the MDM system. Reviews vendor test notes to identify the changes and anticipated impacts. Develops test cases and scripts for new patches and versions of MDM software, ensuring existing functionality is not negatively affected. Executes the tests and analyzes results to ensure changes do not adversely impact billing functions.
Develops and maintains processes and procedure documentation. Identifies and recommends strategies and procedures to eliminate avoidable problems through preventative measures. Coordinates processes such as meter changes and new services, ensuring that all meter data has been properly managed so that billing process impacts are minimized.
For TEC - Develops requirements for, configures and tests MDM reports and applicable rules engine. Identifies and analyzes methods to increase productivity through rules configuration and automation. Recommends new processes to optimize operational business functions enabled by AMI and MDM data (e.g., transformer loading). Supports other business units with custom report development by providing a thorough understanding of the data fields.
For PGS – Provides day-to-day support tasks completing manual corrections related to Gas Meter and Gas ERT installations, removals, and reversals, Gas Device grouping and ungrouping, manual meter disconnects and reconnections, gas rate updates, service notification corrections, re-processing and reporting, and meter reading & routing, and CRB MRU changes.