Back to jobs

Data Investigator #2793

Pay
Pay not listedSimilar roles state $95K–$145K
Work setting
Hybrid — work setting source
Contract Length: 12 months + potential extension Location: Dallas, Texas – Hybrid (3 days onsite, downtown Dallas) Our client is seeking a Data Investigator to support their Advanced Metering System (AMS) operations through advanced data analysis, troubleshooting, and insight generation. The ideal candidate will leverage Python, SQL, and Tableau to query, clean, and visualize complex datasets—identifying patterns, correlations, and root causes that drive operational improvements and business decisions.
Read the full posting
Employment
Not stated

What you’ll work on

Full posting
  • Write and optimize SQL queries across multiple databases to validate AMS data

  • Build and maintain Tableau dashboards that surface performance trends and anomalies

  • Use Python for data extraction, cleaning, troubleshooting and process automation

  • Analyze data quality and synchronization between CIS, AMS and mobile workforce systems

  • Identify patterns and root causes in large, complex datasets and recommend fixes

From the employer’s posting
Write and optimize SQL queries across multiple databases to retrieve, manipulate, and validate AMS-related data.
Develop and maintain Tableau dashboards and visualizations to surface key performance trends, correlations, and anomalies.
Use Python for data extraction, troubleshooting, cleaning, and process automation.
Analyze meter processes, system synchronization, and data quality between systems such as CIS, AMS, and mobile workforce platforms.
Identify and interpret patterns and relationships within large, complex datasets to support root-cause analysis and operational improvements.

What you’ll bring

All qualifications

Core experience

  • 7+ years of professional experience in data analysis, data investigation, or business analytics.
  • Strong proficiency in Python, including libraries such as pandas, NumPy, matplotlib, and seaborn for data analysis and visualization.
  • Proven experience building interactive dashboards and reports in Tableau
  • Demonstrated ability to identify trends, correlations, and root causes within large datasets.
  • Familiarity with statistical techniques and pattern recognition methods for anomaly detection or performance monitoring.
  • Experience in data troubleshooting, pipeline validation, and data quality improvement.

Preferred experience

  • Power BI experience is a plus
Qualification wording
7+ years of professional experience in data analysis, data investigation, or business analytics.
Strong proficiency in Python, including libraries such as pandas, NumPy, matplotlib, and seaborn for data analysis and visualization.
Proven experience building interactive dashboards and reports in Tableau (Power BI experience is a plus).
Demonstrated ability to identify trends, correlations, and root causes within large datasets.
Familiarity with statistical techniques and pattern recognition methods for anomaly detection or performance monitoring.
Experience in data troubleshooting, pipeline validation, and data quality improvement.
Apply at Oncor Electric Delivery

Posting record

Report an error

Actively hiringFirst seen by us 3 days ago, still listed, and not a repost of an earlier posting.

Status in our records
Live
First seen by us
Nov 18, 20263 days ago
Recorded sightings
5
Last seen by us
Nov 22, 2026
Employer says posted
Nov 3, 2025

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Pay

$95K–$145K is typical

The middle half of what similar US postings state. This one doesn’t list pay.

From 2,327 postings in the last year. Stated ranges, not salaries paid.

Time since we first saw it

Day 3

Early. Similar jobs usually come down between day 5 and day 43.

From 16,008 similar postings that came down. Coming down is not always a hire.

Oncor Electric Delivery is hiring

7 open jobs

Open jobs by the week we first saw them, last 12 weeks.

Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • Python
  • SQL
  • Power BI
  • Tableau
  • Matplotlib
  • NumPy
  • pandas
Where the posting names them
Data Investigator (Python, SQL, Tableau Focus) Contract Length: 12 months + potential extension
Location: Dallas, Texas – Hybrid (3 days onsite, downtown Dallas) Our client is seeking a Data Investigator to support their Advanced Metering System (AMS) operations through advanced data analysis, troubleshooting, and insight generation. The ideal candidate will leverage Python, SQL, and Tableau to query, clean, and visualize complex datasets—identifying patterns, correlations, and root causes that drive operational improvements and business decisions. This position involves working with meter asset, communication, energy, event, and customer service data to deliver data-driven insights and performance reporting. You’ll collaborate with cross-functional teams to troubleshoot data discrepancies, enhance data pipelines, and develop dashboards that bring clarity to large-scale operational systems.
- 7+ years of professional experience in data analysis, data investigation, or business analytics. - Strong proficiency in Python, including libraries such as pandas, NumPy, matplotlib, and seaborn for data analysis and visualization. - Advanced SQL skills for querying, joining, and troubleshooting data across multiple relational databases.
Key Responsibilities - Use Python for data extraction, troubleshooting, cleaning, and process automation. - Write and optimize SQL queries across multiple databases to retrieve, manipulate, and validate AMS-related data.
- Troubleshoot and validate data issues, recommending process improvements or corrective actions. - Document analytical methodologies, SQL logic, and Python workflows for knowledge sharing and reproducibility. - Contribute to continuous improvement initiatives through automation, data integration, and enhanced analytical capability.
- Strong proficiency in Python, including libraries such as pandas, NumPy, matplotlib, and seaborn for data analysis and visualization. - Advanced SQL skills for querying, joining, and troubleshooting data across multiple relational databases. - Proven experience building interactive dashboards and reports in Tableau (Power BI experience is a plus).
- Use Python for data extraction, troubleshooting, cleaning, and process automation. - Write and optimize SQL queries across multiple databases to retrieve, manipulate, and validate AMS-related data. - Develop and maintain Tableau dashboards and visualizations to surface key performance trends, correlations, and anomalies.
- Advanced SQL skills for querying, joining, and troubleshooting data across multiple relational databases. - Proven experience building interactive dashboards and reports in Tableau (Power BI experience is a plus). - Demonstrated ability to identify trends, correlations, and root causes within large datasets.
- Write and optimize SQL queries across multiple databases to retrieve, manipulate, and validate AMS-related data. - Develop and maintain Tableau dashboards and visualizations to surface key performance trends, correlations, and anomalies. - Identify and interpret patterns and relationships within large, complex datasets to support root-cause analysis and operational improvements.

Your next step

Complete your application on geniusroad.catsone.com. The employer’s form will show what is required.

Already applied? Track this application

Job description

View original posting ↗

Data Investigator (Python, SQL, Tableau Focus)
Contract Length: 12 months + potential extension
Location: Dallas, Texas – Hybrid (3 days onsite, downtown Dallas)


Our client is seeking a Data Investigator to support their Advanced Metering System (AMS) operations through advanced data analysis, troubleshooting, and insight generation. The ideal candidate will leverage Python, SQL, and Tableau to query, clean, and visualize complex datasets—identifying patterns, correlations, and root causes that drive operational improvements and business decisions.

This position involves working with meter asset, communication, energy, event, and customer service data to deliver data-driven insights and performance reporting. You’ll collaborate with cross-functional teams to troubleshoot data discrepancies, enhance data pipelines, and develop dashboards that bring clarity to large-scale operational systems.
 

Qualifications

  • Associate’s, Bachelor’s, or Master’s degree in Computer Science, Data Science, Engineering, Statistics, or related field.
  • 7+ years of professional experience in data analysis, data investigation, or business analytics.
  • Strong proficiency in Python, including libraries such as pandas, NumPy, matplotlib, and seaborn for data analysis and visualization.
  • Advanced SQL skills for querying, joining, and troubleshooting data across multiple relational databases.
  • Proven experience building interactive dashboards and reports in Tableau (Power BI experience is a plus).
  • Demonstrated ability to identify trends, correlations, and root causes within large datasets.
  • Familiarity with statistical techniques and pattern recognition methods for anomaly detection or performance monitoring.
  • Experience in data troubleshooting, pipeline validation, and data quality improvement.
  • Excellent problem-solving skills and the ability to communicate complex analytical findings to non-technical audiences.
  • Experience with Agile methodologies, collaborative tools, and process documentation.
 

Key Responsibilities

  • Use Python for data extraction, troubleshooting, cleaning, and process automation.
  • Write and optimize SQL queries across multiple databases to retrieve, manipulate, and validate AMS-related data.
  • Develop and maintain Tableau dashboards and visualizations to surface key performance trends, correlations, and anomalies.
  • Identify and interpret patterns and relationships within large, complex datasets to support root-cause analysis and operational improvements.
  • Analyze meter processes, system synchronization, and data quality between systems such as CIS, AMS, and mobile workforce platforms.
  • Collaborate with stakeholders to refine data collection and improve the accuracy and reliability of reporting.
  • Troubleshoot and validate data issues, recommending process improvements or corrective actions.
  • Document analytical methodologies, SQL logic, and Python workflows for knowledge sharing and reproducibility.
  • Contribute to continuous improvement initiatives through automation, data integration, and enhanced analytical capability.


Genius Road, LLC is proud to be a Certified Women’s Business Enterprise, an Equal Opportunity Employer and values diversity. All employment is decided on the basis of qualifications, merit and business need.         

 

Demand for Analyst roles

New Analyst postings at the employers we follow are up 26% over the last 6 weeks compared with the 6 before.

Weekly new Analyst postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 993, the most 1,510, and the latest week had 1,367.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Analyst, by the work the posting describes.

Analysts answer business questions with data. They pull numbers with SQL, build reports and dashboards, and explain what changed and why to the people making decisions.

Most postings ask for SQL, spreadsheets, a dashboard tool such as Tableau or Power BI, and clear writing.

Unlike a data scientist, an analyst mostly explains what happened rather than building models that predict what will.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

Dallas, Texas

Contract Length: 12 months + potential extension Location: Dallas, Texas – Hybrid (3 days onsite, downtown Dallas) Our client is seeking a Data Investigator to support their Advanced Metering System (AMS) operations through advanced data analysis, troubleshooting, and insight generation. The ideal candidate will leverage Python, SQL, and Tableau to query, clean, and visualize complex datasets—identifying patterns, correlations, and root causes that drive operational improvements and business decisions.
Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.