Title: Meter Data Management (MDM), Billing Data Analyst
Company: Tampa Electric Company
Location: Midtown East Tower
State and City: Florida - Tampa
Shift: 8 Hr. X 5 Days
Hiring Manager: Dennis Trevino
Recruiter: Mark Koener
TITLE: MDM Data Analyst
PERFORMANCE COACH: Manager AMI CRB Integration or Supervisor AMI Operations
COMPANY: Tampa Electric Company or Peoples Gas System
DEPARTMENT: Enterprise Operations or AMI Strategic Solutions
POSITION CONCEPT
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.
PRIMARY DUTIES AND RESPONSIBILITIES
1. 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). (20%)
2. 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). (20%)
3. 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. (15%)
4. 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. (15%)
5. 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. (10%)
6. 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. (10%)
7. 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. (10%)
OR
8. 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. (10%)
SUPERVISION
RELATIONSHIPS
Internal: Billing, Energy Accounting, Forecasting, Meter Reading, Gas and/or Meter Operations, Regulatory.
External: Vendors and customers.
QUALIFICATIONS
Education
Required: High School diploma or equivalent.
Preferred: Bachelor’s degree in business related field.
Related Experience
Required: 4 years of relevant experience with metering and billing functions.
Preferred: Experience working with Advanced Meter Infrastructure (AMI) and Meter Data Management (MDM) System and Customer Information System.
Knowledge/Skills/Abilities
Required:
• 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
OUR COMPETENCIES
• Puts Safety First – Protect people and the environment every day
• Be Curious & Adapt – Welcome change and keep learning
• Create Value for Customers – Build relationships and deliver quality work
• Be Accountable & Respectful – Do what’s right and follow through
• Foster Strong Teams – Build trust through teamwork and help people grow
WORK CONDITIONS
Must be able to work occasional additional hours as needed.
TECO offers a competitive Benefits package!!
Competitive Salary *401k Savings plan w/ company matching * Pension plan * Paid time off* Paid Holiday time * Medical, Prescription Drug, & Dental Coverage *Tuition Assistance Program * Employee Assistance Program * Wellness Programs * On-site Fitness Centers * Bonus Plan and more!
#LI-SAC
Nearest Major Market: Tampa
Job Segment:
Testing, CRM, Database, Technology