Exception Specialist Data Analyst

Salary Range: $80,379 - $107,173
Relocation: No

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 144,000 miles of transmission and distribution lines in Texas.

Summary

The Data Analyst position provides both broad and detailed operational analysis to multiple departments within the Oncor organization. This position assists with monitoring team performance and the development of change requests and defects related to various Oncor system platforms. The Data Analyst position provides analysis of issues to identify impacts to customers, market participants, and revenue. In addition, this position identifies operational opportunities for improvement across various departments within Oncor. This position uses knowledge and experience to provide analytic support to Measurement Services, Distribution Operations, and Rates and Regulatory teams.

Key Roles & Responsibilities

• Perform all essential functions and aspects of the job, including any other specific job requirements.
• Assist in generating high quality reports and analyze output to support operational activities in Measurement, Field Activities, Electronic Data Interchange (EDI) processing, Billing, and Issues Resolution.
• Design, build, and maintain small applications that report on operational and revenue performance.
• Work indirectly through senior team members with business partners to improve processes and resolve operational challenges.
• Perform frequent ad hoc data mining, reporting, and generation of decision support data and presentations.
• Perform other duties as assigned.

Skills

• Ability to write new and understand existing Structured Query Language (SQL) queries utilizing various Database Management Systems (DBMS), including Operational Outage Data System (OODS), Oracle, Microsoft Access, and Microsoft SQL Server.
• Working knowledge of Microsoft Excel, Microsoft Access, Microsoft PowerPoint, and Microsoft Outlook.
• Basic understanding of revenue accounting, Electronic Data Interchange (EDI) transaction processing, and Field Activities.
• Working knowledge of (International Business Machines) IBM Cognos Analytics.
• Basic understanding of database design ranging from desktop to mainframe environments and data warehousing concepts.

Education & Experience

• High school diploma, GED, or equivalent is required.
• 2 or more years of professional experience in analytical roles is required.
• A Bachelor’s degree in Business Administration, Management, or Computer Science is encouraged to apply.
• Data mining experience in a heterogeneous database environment is encouraged to apply.

Measures of Success

• Accurate and timely periodic reporting.
• Ability to handle multiple concurrent projects.
• Resolution of operational opportunities in a timely manner.

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,300 in 2026 as an Employee only) and other wellbeing resources.
• 401k with dollar-for-dollar company match up to 6%.
• 401k match with student debt program.
• 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.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.