Data Analyst

AARATECH

Boston (MA)

Hybrid

USD 65,000 - 75,000

Full time

28 hours ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

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. Ideal candidates have 2–4 years of data analytics experience, strong SQL skills, and hands-on experience with Power BI or Tableau and Python.

Qualifications

  • Bachelor's degree in Data Science, Computer Science, Information Technology, Business Analytics, or a related field.
  • 2–4 years of experience as a Data Analyst, preferably in utilities, energy, or another asset-intensive industry.
  • Strong, hands‑on SQL skills — complex joins, window functions, CTEs, and query optimization.
  • Proficiency with Power BI or Tableau, plus advanced Microsoft Excel (Power Query, pivot tables, advanced formulas).
  • 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.
  • Ensure data accuracy, consistency, and reporting quality across platforms.
  • Present analytical findings and recommendations to operations, planning, and regulatory stakeholders.

Skills

Analytical thinking
Data storytelling
Stakeholder communication

Education

Bachelor's degree in data-related field

Tools

SQL
Power BI
Tableau
Excel
Python

Job description

Employment Type

Full-Time, W2 (deployed to client projects)

Experience

2–4 years

Compensation

$65,000 – $75,000 per year

Work Mode

On-Site / Hybrid

Work Authorization

At this time, we are only able to consider candidates who are authorized to work in the United States without sponsorship.

Why This Role?

The grid is going digital — smart meters, renewables, and AMI data have made utilities one of the most data-hungry industries in America. Get in early on an analytics niche with huge demand and surprisingly little competition.

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.

Key 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.
  • Ensure data accuracy, consistency, and reporting quality across platforms.
  • Present analytical findings and recommendations to operations, planning, and regulatory stakeholders.
Qualifications
  • Bachelor's degree in Data Science, Computer Science, Information Technology, Business Analytics, or a related field.
  • 2–4 years of experience as a Data Analyst, preferably in utilities, energy, or another asset-intensive industry.
  • Strong, hands‑on SQL skills — complex joins, window functions, CTEs, and query optimization.
  • Proficiency with Power BI or Tableau, plus advanced Microsoft Excel (Power Query, pivot tables, advanced formulas).
  • Hands‑on experience with operational, sensor/meter, time‑series, or customer data at scale.
  • Strong analytical, data‑storytelling, and stakeholder‑communication skills.
Tools & Technologies You Will Use
  • Analytics & querying: SQL (Oracle, SQL Server, PostgreSQL), Python (pandas, NumPy) including time‑series analysis.
  • Utility data & systems: AMI/MDM platforms, SCADA/OT historians (OSIsoft PI exposure a plus), CIS/billing data.
Preferred Skills
  • Knowledge of energy markets, demand response, load forecasting, or renewable‑integration concepts.
  • Familiarity with reliability metrics (SAIDI, SAIFI, CAIDI) and regulatory reporting.
  • Exposure to predictive maintenance or asset‑analytics use cases.
  • Certifications such as Microsoft PL-300, Tableau Desktop Specialist, or Google Data Analytics Professional Certificate are a plus.
About Aaratech Inc.

Aaratech Inc. is a technology-driven organization delivering innovative solutions across cybersecurity, data & analytics, healthcare, and enterprise domains. We are committed to helping organizations transform data into actionable insights through advanced analytics, modern technologies, and data-driven innovation.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Analyst
Data Analyst

AARATECH • United States

Hybrid
USD 65,000 - 75,000
Data Analyst, Utilities & Energy Analytics
Data Analyst, Utilities & Energy Analytics

AARATECH • United States

Hybrid
USD 65,000 - 75,000
Utilities Data Analyst – Grid Analytics & Forecasting
Utilities Data Analyst – Grid Analytics & Forecasting

AARATECH • Boston (MA)

Hybrid
USD 65,000 - 75,000
Data Scientist
Data Scientist

Brooksource • Philadelphia

Hybrid
USD 100,000 - 130,000
Staff Data Engineer
Staff Data Engineer

Electric Power Engineers • Austin (TX)

Hybrid
USD 140,000 - 190,000
100% premium coverage for you
Generous PTO and paid holidays
MyShare Employee Ownership Program
+1
Data Analyst
Data Analyst

The Ash Group • Minneapolis (MN)

Hybrid
USD 39,778 - 56,653
Medical benefits
Dental benefits
Vision benefits
+1
Data Analyst
Data Analyst

AARATECH • Houston (TX)

Hybrid
USD 65,000 - 75,000
Data Analyst
Data Analyst

AARATECH • Austin (TX)

Hybrid
USD 70,000 - 80,000
Data Analyst
Data Analyst

AARATECH • Texas

Hybrid
USD 65,000 - 75,000
Data Investigator #2793
Data Investigator #2793

Genius Road, LLC • Dallas (TX)

Hybrid
USD 80,000 - 120,000