Summary

The AMS Data Analyst position uses data to acquire information about specific topics related to Oncor’s Advanced Metering System (AMS). The AMS Data Analyst must obtain the related data, interpret the data to acquire the requested information about the specific topic, and present the results in forms such as charts or reports. The data used to support the day-to-day analysis is comprised of meter asset data, meter event data, meter communication data, meter energy data, customer information data, customer service order data, and other related data maintained in various documents, relational databases, and time-series databases. The acquired information from the AMS data will be used to support system performance metrics, root-cause analysis of meter equipment failures, maintenance activities, and other similar activities.

The AMS Data Analyst will perform most of their work on a computer, either at a desk in an office or onsite, and will need to be able to sit for extended periods of time. The AMS Data Analyst may work more than 40 hours a week, meeting deadlines, especially during critical phases of projects.

Key Roles & Responsibilities

Directly or through others, the incumbent:

• Assists in the collection of Oncor’s AMS requirements, determination of technical issues, and design reports to meet data analysis needs.
• Provides feedback and ideas regarding new sources of data and methods to improve data collection, analysis, and reporting.
• Collects, analyzes, and reports data to meet Oncor’s AMS needs.
• Designs basic reports to monitor and analyze AMS system processes associated with daily and fifteen-minute interval energy data.
• Designs basic reports to validate the synchronization of the AMS application with other applications, including the customer information system, asset management system, and mobile workforce management system.
• Designs basic reports to monitor and analyze meter assets, events, communications, energy, service orders, customer information, and other related data.
• Designs basic report to validate Market exceptions related to daily metering processes.
• Receives instruction, guidance, and direction from others.
• Deliver data visualizations in the form of dashboards, reports, or embedded visualization in applications.
• Develop analytical models to help management make decisions
• Performs all essential aspects and functions of the job as well as any other specific job requirements, maintenance activities, and other similar activities.

Education, Experience, & Skills - AMS Data Analyst III

• High School diploma, GED or equivalent is required.
• Associate’s degree preferred with two years business analytics experience, OR five years business analytics experience.
• Proficient with Microsoft Word, Microsoft Excel, Microsoft Access, Microsoft SharePoint, Structured Query Languages (SQL), Data Analysis, Data Entry, Statistical Analysis using SAS or SPSS equivalent technologies, Data Modeling, and Database Management & Reporting.
• Good communication skills.
• Experience with reporting and visualization tools.
• Analytical problem-solving skills.
• Basic understanding of Data Science and Advanced Analytic development technologies. (Python, Hadoop).

Education, Experience, & Skills - AMS Data Analyst Sr. I

• High School diploma, GED or equivalent is required.
• Bachelor’s degree preferred in statistics, mathematics, engineering, computer science, or business administration with five years business analytics experience, OR Master’s degree in statistics, mathematics, engineering, computer science, or business administration with two years business analytics experience, OR nineteen years business analytics experience.
• Proficient with Microsoft Word, Microsoft Excel, Microsoft Access, Microsoft SharePoint, Structured Query Languages (SQL), Data Analysis, Data Entry, Statistical Analysis and Databases.
• Strong communication skills.
• Strong leadership skills.
• Experience with reporting and visualization tools.
• Analytical problem-solving skills.
• Basic understanding of Data Science and Advanced Analytic development technologies (Python, Hadoop, R). Use of Selenium is a plus.
• Experience automating tasks using Python is a plus.

Education, Experience, & Skills - AMS Data Analyst Sr. II

• High School diploma, GED or equivalent is required.
• Master’s degree preferred in statistics, mathematics, engineering, computer science, or business administration with five years business analytics experience, OR Bachelor’s degree in statistics, mathematics, engineering, computer science, or business administration with ten years business analytics experience, OR twenty four years business analytics experience.
• Proficient with Microsoft Word, Microsoft Excel, Microsoft Access, Microsoft SharePoint, Structured Query Languages (SQL), Data Analysis, Data Entry, Statistical Analysis and Databases.
• Proficient with Python, especially any libraries used for Data Science
• Strong communication skills.
• Strong leadership skills.
• Experience with reporting and visualization tools.
• Analytical problem-solving skills.
• Proficient with Data Science and Advanced Analytic development technologies (Python, Hadoop, R). Use of Selenium is a plus.
• Experience automating tasks using Python is a plus.
• Experience testing software or managing projects is a plus.

Measures of Success

• Proficiency in skills, technologies, practices for continuous iterative exploration and investigation of past business performance to gain insight and drive business planning.
• Achievement of quantitative, qualitative and cost metrics.
• Demonstrates effective communication with co-workers, supervisors, managers, Oncor departments, and external Oncor customers.
• Demonstrates contribution to the workgroup and Company goals.
• Achievement of defined Customer Satisfaction goals.
• Adheres to Company policies and procedures.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

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)