Exception Specialist Data Analyst

Oncor; Dallas (TX); On-site; USD 80,000 - 107,000; Full time

Benefits offered by this job

Annual incentive program

Competitive health benefits

401k with company match

Paid vacation

Job summary

Oncor Electric Delivery Company LLC, headquartered in Dallas, seeks a Data Analyst to provide broad and detailed operational analysis across Measurement, Distribution Operations, and Rates teams. You will develop change requests, analyze impacts on customers and revenue, and identify opportunities for process improvements.

You will generate high-quality reports, build small reporting apps, and support ad hoc data mining to enable informed decisions across departments.

Qualifications

• High school diploma, GED, or equivalent is required.
• 2 or more years of professional experience in analytical roles is required.

Responsibilities

• Generate high quality reports and analyze output to support operational activities in Measurement, Field Activities, EDI processing, Billing, and Issues Resolution.
• Design, build, and maintain small applications that report on operational and revenue performance.
• Perform frequent ad hoc data mining, reporting, and generation of decision support data and presentations.

Skills

SQL queries

Excel

EDI processing

IBM Cognos Analytics

Database design

PowerPoint

Outlook

Education

High school diploma or GED

2+ years analytical experience

Tools

OODS

Oracle

Microsoft Access

Microsoft SQL Server

Job description

Salary Range: $80,379 - $107,173Relocation: 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 145,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.

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.

Travel Required

Yes . Up to 25% (Mainly within DFW).

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.