Data Scientist Staff (Transmission Engineering)

Salary Range: $91,096 - $121,461

Close Date: 01/26/2024, 3pm CST

Relocation: No

Job Summary

The Data Scientist position will leverage large data sets to support Oncor Transmission Engineering in their continuous effort to improve on-time material delivery, project financial data, and forecasting. To accomplish the desired results, the incumbent will utilize data sets such as project and purchase order data from PETE, Maximo, and other internal Oncor systems. The position may also use data external to Oncor such as vendor delivery information.

Emphasis will be placed on the incumbent’s ability to utilize advanced tools designed for large data sets and visualizations such as Alteryx, Tableau, and Smartsheet or similar tools. The incumbent will also utilize their skills to evaluate various advanced modeling techniques, build/maintain appropriate queries, develop necessary algorithms, and create both ad-hoc and published reports. This will include analyzing, troubleshooting, and enhancing poor performing queries, algorithms, and reports.

This position may be required to attend and present at internal meetings and events as well as presenting at various analytics conferences each year. This could include visiting with other utilities and vendors at their facility or one of Oncor’s Texas locations.

Key Roles & Responsibilities

1. Consistently research new methods of capturing data.
2. Develop infrastructure to clean data and implement data scrubbing automation protocols.
3. Gather, extract, manipulate, analyze, curate, and model data using analytical and statistical tools.
4. Identify new sources of data and new methods to improve data collection, analysis, and reporting.
5. Maintain a database ‘sandbox’ or ‘workbench’ environment to achieve the required reports.
6. Ensure the efficient performance of queries, algorithms, and analytical functions to generate reports.
7. Design complex reports or presentations to monitor and analyze assets, material, construction schedules, and project cost data.
8. Act as a resource for colleagues with less experience.

Education, Experience, & Skills

1. Master’s degree preferred in Engineering, Mathematics, Statistics, Computer Science, or Business Administration and two years data analytics experience, OR Bachelor’s degree in Engineering, Mathematics, Statistics, Computer Science or Business Administration with four years data analytics experience, OR eight years data analytics experience.
2. Certifications in Data Science preferred such as DASCA, Data Science Council of America, or similar.
3. Proficient with Structured Query Languages (SQL), Python, .Net and has exposure to advanced tools such as Alteryx, Tableau, Smart Sheet or similar tools.
4. Proficient with Microsoft Excel.
5. Strong communication skills.

Measure of Success

1. Demonstrates technical aptitude and willingness to learn.
2. Demonstrates effective communication with internal and external work groups.
3. Demonstrates skills in prioritization, multi-tasking and success in adapting to change.
4. Demonstrates commitment to safety and promotes safety awareness.
5. Demonstrates ability to effectively manage projects from conception to completion.
6. Demonstrates the ability to train and teach peers.