AMS Data Analyst III thru AMS Data Analyst Sr. II

About Us 

Oncor Electric Delivery Company LLC, headquartered in Dallas, is a regulated electricity transmission and distribution business that uses superior asset management skills to provide reliable electricity delivery to consumers. Oncor (together with its subsidiaries) operates the largest transmission and distribution system in Texas, delivering power to nearly 4 million homes and businesses and operating more than 143,000 miles of transmission and distribution lines in Texas.

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.

Education, Experience, & Skills - AMS Data Analyst III

• 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.

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.

Benefits

At Oncor, we offer a comprehensive set of benefits, compensation and performance management programs designed specifically to attract, retain, motivate and reward our high-performing workforce. Our supportive and inclusive culture allows every team member the opportunity to thrive and make a difference. We invest in our employee’s success and well-being by offering such things as:

• Annual incentive program.
• Competitive health and welfare benefits (medical, dental, vision, life insurance).
• Ability to earn wellness incentives (up to $2,000 in 2025) and other wellbeing resources.
• 401k with dollar-for-dollar company match up to 6%.
• Cash balance pension plan.
• Adoption Assistance.
• Mental health resources.
• Employee resource groups.
• Tuition reimbursement.
• Competitive vacation, 10 company holidays and 2 personal holidays.
• Paid parental leave.
• Salary continuation for up to 6 months for approved employee illness or injury.
• Other perks such as commuter benefits, electric vehicle incentive program, appliance purchase plan.

Participation in benefit programs for employees in collective bargaining units is subject to the applicable collective bargaining agreement

Salary : $75,035 - $125,712