Advanced Metering System Data Analyst (Level III - Sr. II)

Salary Range: $75,035 -$125,712

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.

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.

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

Skills

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

- Experience automating tasks using Python is a plus.

- Proficient with Data Science and Advanced Analytic development technologies (Python, Hadoop, R). Use of Selenium is a plus.

- Experience testing software or managing projects is a plus.

Education And Experience

AMS Data Analyst III

- High School diploma, GED or equivalent is required. - Associate degree is encouraged to apply with 2 + years of business analytics experience. - In lieu of a degree, 5 + years of business analytics experience.

AMS Data Analyst Sr. I

- High School diploma, GED or equivalent is required. - Bachelor’s degree in statistics, mathematics, engineering, computer science, or business administration with 5 + years of business analytics experience or a Master’s degree in statistics, mathematics, engineering, computer science, or business administration with 2 + years of business analytics experience is encouraged to apply. - In lieu of either degree, 10 + years of business analytics experience is encouraged to apply.

AMS Data Analyst Sr. II

- High School diploma, GED or equivalent is required. - Master’s degree in statistics, mathematics, engineering, computer science, or business administration with 5 + plus years of business analytics experience, or a Bachelor’s degree in statistics, mathematics, engineering, computer science, or business administration with 10 + plus years of business analytics experience is encouraged to apply. - In lieu of either degree,15+ plus years of business analytics experience is encouraged to apply.

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