Grid & Utilities Data Analyst

AARATECH; San Francisco (CA); Hybrid; USD 65,000 - 75,000; Full time

Job summary

Aaratech Inc. is seeking a Data Analyst – Utilities & Energy to turn smart-meter, outage, asset, and customer data into insight.

You will build reliability and load reporting, support demand forecasting and grid-modernization analytics, and deliver findings that improve operations and customer programs. The role requires 2–4 years of data analysis experience in utilities or asset-intensive sectors, strong SQL, and solid BI tooling skills.

Qualifications

• Bachelor's degree in Data Science, Computer Science, Information Technology, Business Analytics, or related field.
• 2–4 years of experience as a Data Analyst in utilities, energy, or asset-intensive industries.
• Strong SQL skills — joins, window functions, CTEs, and query optimization.
• Proficiency with Power BI or Tableau, plus advanced Excel (Power Query, pivot tables).
• Hands‑on experience with operational, sensor/meter, time‑series, or customer data at scale.
• Strong analytical, data‑storytelling, and stakeholder‑communication skills.

Responsibilities

• Collect, clean, and analyze AMI/smart-meter, SCADA, outage, asset, and customer datasets using SQL and Python.
• Design and maintain dashboards in Power BI or Tableau for load, reliability metrics (SAIDI/SAIFI/CAIDI), and asset performance.
• Support demand forecasting, load research, and energy-efficiency/demand-response program analytics.
• Analyze outage and asset-health data to support predictive maintenance and grid-modernization initiatives.
• Prepare data for regulatory reporting and rate-case filings to public utility commissions.
• Present analytical findings and recommendations to operations, planning, and regulatory stakeholders.

Skills

SQL

Power BI

Tableau

Excel

Data analysis

Stakeholder communication

Education

Bachelor's degree in Data Science/CS/IT/Analytics

Tools

Python

Pandas

NumPy

SQL Server

Job description

Aaratech Inc. is seeking a Data Analyst – Utilities & Energy to turn smart-meter, outage, asset, and customer data into insight.

You will build reliability and load reporting, support demand forecasting and grid-modernization analytics, and deliver findings that improve operations and customer programs. The role requires 2–4 years of data analysis experience in utilities or asset-intensive sectors, strong SQL, and solid BI tooling skills.