Data Analyst Intern- TX

Xcel Energy is an energy company providing electricity and natural gas services. The Data Analyst Intern will support the data analytics team by transforming utility data into actionable insights, developing dashboards and reports, performing analysis, and collaborating with cross-functional teams on operational and customer-focused initiatives.

What you'll do:

• Develop and maintain interactive Power BI dashboards and reports to visualize energy consumption trends, outage metrics, and key performance indicators for internal stakeholders and leadership
• Perform exploratory data analysis and statistical modeling to identify patterns in customer usage, predict peak demand, or support asset management and predictive maintenance initiatives
• Collaborate with cross-functional teams (operations, customer service, engineering) to gather requirements, clean data, and deliver analytical solutions that address business questions
• Assist in ad-hoc reporting, data quality validation, and automation of routine analytics processes using tools like Excel
• Document analytical findings, create presentations, and participate in team meetings to communicate insights effectively

What they're looking for:

• Current student, Junior or higher (as of Fall 2027)
• Enrolled in an ABET accredited college or university and pursuing a degree in Science, Business Analytics, Computer Science, Statistics, Applied Mathematics, Electrical/Industrial Engineering (with strong analytics focus), Information Systems, or Management Information Systems
• Able to work full-time during the summer (up to 40 hours a week) and commuting to the designated work location in-person, per our hybrid work policy
• Strong proficiency in Power BI
• Experience or coursework involving Databricks
• Excellent problem-solving skills and attention to detail with the ability to handle large, messy datasets
• Strong communication skills – able to translate technical findings into clear business recommendations
• Familiarity with the energy/utility industry, statistics, machine learning basics, or GIS tools is a strong advantage
• Ability to work independently and as part of a team in a fast-paced, regulated environment

Benefits:

• Pension
• 401(k) plan
• Paid time off (PTO)
• Holidays