MDM Data Analyst

Title: MDM Data Analyst 
Company: Tampa Electric Company 
State and City: Florida - Tampa
Shift: 8 Hr. X 5 Days

 

 

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. Develops requirements for, configures and tests MDM reports. 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%) 

 

SUPERVISION   N/A

 

RELATIONSHIPS

Internal: Billing, Energy Accounting, Forecasting, Meter Reading, Meter Operations, Regulatory

External: Occasional work with vendors and customers

 

QUALIFICATIONS

 

Education

Required: High School diploma or equivalency certificate

Preferred: Bachelor’s degree in business or other relevant field from an accredited institution in accordance with TECO Energy’s education policy

 

Related Experience

 

Required: Minimum two years of relevant experience with metering and billing functions and a strong understanding of utility billing practices.

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

 

Competencies

 

Builds Strong, Collaborative Relationships

Cultivates Innovation and Embraces Change

Speaks Up on Safety, Health, and the Environment

Thinks Strategically & Exercises Sound Judgement

 

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!

 

STORM DUTY REQUIREMENTS....Please make sure to read below!!!  Responding to storms will be considered a condition of employment.

TECO Energy and its companies serve a role in providing critical services to our community during an emergency. Team members are required to participate in the response/recovery activities related to emergencies/disasters to maintain service to our TECO Energy customers. Team members are required to work in their normal job duties or other assigned activities. Proper compensation will be made in accordance with the company's rules and procedures.

 

TECO Energy is proud to be an Equal Opportunity Employer.

TECO Energy is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, age, disability status, veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by law, except where physical or mental abilities are a bona fide occupational requirement and the individual is unable to perform the essential functions of the position with reasonable accommodations.

In order to provide equal employment and advancement opportunities for all individuals, employment decisions at TECO Energy will be based on skills, knowledge, qualifications and abilities.

Pay Transparency Non-Discrimination Statement
The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information. 41 CFR 60-1.35(c)

ADA policy
It is the policy of TECO Energy to provide reasonable accommodation for all qualified disabled individuals who are employees and applicants for employment, unless it would cause undue hardship. The corporation will adhere to applicable federal and state laws, regulations and guidelines, including, but not limited to the Americans with Disabilities Act (ADA) of 1990 and section 503 and 504 of the Rehabilitation Act of 1970s.

 

Application accommodations
Applicants may request reasonable accommodation in the application process five business days prior to the time accommodation is needed.

 

Pre-employment physical exams may be required for positions with bona fide job-related physical requirements regardless of disability.