Energy Data Analytics Intern: Power BI & Databricks

Southwestern Public Service Co; Town of Buchanan (WI); Hybrid; USD 29,000 - 34,000; Full time

Benefits offered by this job

Pension

401(k) plan

Paid time off (PTO)

Holidays

Job summary

Xcel Energy is seeking a Data Analytics Intern to transform complex utility data into actionable insights. You will work with Power BI, Databricks, and large datasets related to energy usage, outages, and customer behavior, supporting operational efficiency and grid reliability.

The role offers hands-on experience, collaboration across teams, and exposure to predictive analytics and reporting in a regulated energy environment. May 31, 2027 start date with potential extension.

Qualifications

• Current student, Junior or higher (as of Fall2027).
• Enrolled in an ABET-accredited college or university pursuing a degree in Science, Business Analytics, CS, Statistics, Applied Mathematics, Electrical/Industrial Engineering (analytics focus), Information Systems, or MIS.
• Able to work full-time during the summer (up to 40 hours a week) and commute to the designated work location in-person per hybrid policy.

Responsibilities

• Develop and maintain interactive Power BI dashboards and reports to visualize energy consumption trends, outage metrics, and KPIs.
• Perform Exploratory Data Analysis and statistical modeling to identify patterns in customer usage and forecast demand.
• Collaborate with cross-functional teams (operations, customer service, engineering) to gather requirements and deliver analytical solutions.
• Assist in ad-hoc reporting, data quality validation, and automation of routine analytics using Excel.
• Document analytical findings and present insights to stakeholders.

Skills

Power BI

Databricks

Problem solving

Communication skills

GIS familiarity

Education

ABET-accredited program in relevant field

Tools

Power BI

Databricks

Excel

Job description

Xcel Energy is seeking a Data Analytics Intern to transform complex utility data into actionable insights. You will work with Power BI, Databricks, and large datasets related to energy usage, outages, and customer behavior, supporting operational efficiency and grid reliability.

The role offers hands-on experience, collaboration across teams, and exposure to predictive analytics and reporting in a regulated energy environment. May 31, 2027 start date with potential extension.