• Data Analyst - AMI

    Job Locations US-KS-Lenexa
    Posted Date 3 weeks ago(10/26/2018 2:08 PM)
    # of Openings
    Customer Service/Support
  • Overview

    WaterOne is an independent public water utility. We’ve been proudly serving the Johnson County, Kansas area since 1957. Every day, nearly 425,000 customers rely on WaterOne to provide fresh, clean water on demand. It’s a responsibility we deliver on. 


    Our passion is water because water touches everything we care about: family, health, safety, and community. We serve our community by bringing award-winning water to their homes, businesses, and public places.




    The purpose of this position is to assimilate, review, analyze, and present data and recommend solutions using the Advanced Metering Infrastructure (AMI) system along with big data and advanced analytics.   Areas of responsibility include management of the Meter Data Management (MDM) system, meter data analytics, and coordination with other Divisions for use of the network utilizing knowledge of customer service practices, meter operations, rules, regulations, utility operations, and integrated utility applications.


    Customer Service Commitment


    WaterOne employees shall continuously strive to meet or exceed the expectations of both their internal and external customers.  Questions and concerns shall be acknowledged on the same day whenever possible, but no later than the next business day.  Issues shall be resolved as promptly as possible, with the goal of maximizing customer satisfaction.


    Essential Functions


    Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.


    • Provide daily operations of the Network-as-a-Service (NaaS) and the Software as a Services (SaaS) for the AMI Headend, MDM, and Customer Portal.
    • Prepare reports and analyze the data to monitor meter health, alarms, and events.
    • Check the percentage of billing reads and interval reads received every day and determine if the Service Level Agreement (SLA) has been achieved and act, if required.
    • Develop and update processes to create virtual meters and support for District Metered Areas (DMAs).
    • Develop systems training materials and provide ongoing training to division end users for the MDM and Customer Portal.
    • Analyze operational data, report on findings, and offer recommendations for improvement, as assigned.
    • Develop and refine the MDM system to automate the creation of notifications. Ensure data is correctly transferring from the MDM to the CIS system.
    • Study reports to identify potential customer water leaks and utilize IVR message system.
    • Develop and monitor program to detect and report backflow and contamination of the distribution system.
    • Uses MDM data to calculate Key Performance Indicators (KPIs) for water loss programs.
    • Advise on design and maintains customer portal.
    • Partner with meter-related vendors to enhance services and products provided to WaterOne.
    • Evaluate meter performance and customer usage to right-size meters.
    • Assist other Divisions with use of the AMI network and sensors.
    • Document, create, and maintain SOPs for position.


    Other Duties


    • Assist with planning water loss calculations, strategies, and initiatives.
    • Assist field personnel with information that supports their duties as assigned.
    • Performs other job duties as assigned.


    Position Competencies


    In addition to organizational competencies, these key competencies are expected to be demonstrated by each employee in this position:


    • Analysis/Reasoning – Examines data to grasp issues, draw conclusions, and solve problems.
    • Problem Solving – Resolves difficult or complication challenges.
    • Creative and Innovative Thinking – Develops fresh ideas that provide solutions to all types of workplace challenges.
    • Flexibility – Ability to adapt to changes while keeping focus on goals and apply knowledge to new circumstances.
    • Collaboration – working with other divisions to deliver data and shared goals.


    Required Education, Skills & Experience


    • Bachelor's degree in Business, Information Technology, Finance, Engineering or related field.
    • Three years of experience in a customer accounting or customer billing work environment.
    • Three years of experience with a water utility.
    • Two years of experience working with Enterprise Resource Planning application systems.
    • Experience with or the ability to learn AMI Headend and MDM systems.
    • Knowledge of and competency with MS Office software, including advanced skills with Excel, Word and PowerPoint.
    • Demonstrate superior analytical and problem-solving skills.
    • Excellent communication, organizational, interpersonal, and presentation skills used effectively with all levels of WaterOne personnel and vendor partners.
    • Ability to work effectively with all levels of WaterOne personnel and cross-functionally across Divisions.
    • Excellent decision-making skills and demonstrated use of good judgment.
    • Demonstrated high degree of initiative, self-motivation and accountability.
    • Capability to work well under pressure.
    • Ability to maintain confidentiality of data and user material.
    • Strong time management skills and the ability to prioritize workload and meet deadlines with minimal direct supervision.


    Preferred Education, Skills & Experience


    • Experience with Supervisory Control and Data Acquisition (SCADA) systems, Geographical Information Systems (GIS).
    • Familiarity with data governance concepts.
    • Prior experience with SAP.


    Physical Requirements

    The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job.  Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.


    The employee may occasionally lift and/or move up to 50 pounds and frequently lift and/or move up to 10 pounds. The employee must be able to use a computer for several hours a day.  The employee must be able to occasionally move from one location to another or be able to remain in a stationary position for up to several hours a day.  The employee must be able to use office productivity equipment such as a personal computer, calculator, printer, and copy machine.


    Work Environment


    The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.


    While performing the duties of this job, the employee could be exposed to outdoor weather conditions occasionally.  This job operates in a professional office environment. This role routinely uses standard office equipment such as computers, phones, photocopiers, filing cabinets and fax machines. The noise level in the work environment is usually



    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed