Company: Aaratech Inc.
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.
BI & visualization: Power BI (DAX, Power Query), Tableau, Excel.
Utility data & systems: AMI/MDM platforms, SCADA/OT historians (OSIsoft PI exposure a plus), CIS/billing data.
Geospatial & cloud: Esri ArcGIS, Snowflake, Databricks, Azure or AWS data services.
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.

Data Analyst

Similar Analytics Jobs

Analyst, Investments

Billing Analyst

Business Analyst

Revenue Management Analyst

Senior Data Analyst

Management and Program Analyst - Top Secret Clearance Required