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 reports 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.
- High School diploma, GED or equivalent is required.
- Associate 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.
Oncor Electric Delivery
1616 Woodall Rogers Freeway
Dallas
Texas United States
www.oncor.com
