Reliability Data Analyst Intern- CO

Socket.dev; Colorado; Hybrid; USD 26,000 - 29,000; Full time

Benefits offered by this job

Pension

401(k) plan

Paid time off

Holidays

Job summary

Xcel Energy is seeking a Data Analyst Intern to support the Electric Distribution System Performance (EDSP) team in Colorado. This paid internship applies data analytics to distribution system performance, outage data, reliability metrics, and reporting, working with engineers and analysts to transform large datasets into actionable insights.

The internship offers hands-on experience, mentorship, and opportunities to present results to internal stakeholders, with a May 31, 2027 start date and

Qualifications

• Current student, Sophomore or higher (as of Fall 2026)
• Enrolled in an accredited college/university pursuing a degree in Data Science, Computer Science, Statistics, Engineering, or related field
• Able to work full-time during summer (up to 40 hours) or part-time during school year (up to 20 hours) and commute in-person per hybrid policy
• Able to commute to Lipan Distribution Center (LDC) in Denver

Responsibilities

• Analyze distribution system performance data (outages, reliability metrics, asset performance) to identify trends and insights
• Develop and maintain dashboards and reports using Excel, Power BI and Databricks
• Support data validation, cleansing, and preparation across multiple data sources
• Collaborate with engineering and operations teams to support data-driven decision-making
• Perform ad-hoc analysis and reporting to support EDSP initiatives
• Document analytical methods and present findings to team members

Skills

Excel

Power BI

SQL

Python

Analytical

Communication

Education

Pursuing degree in Data Science, CS, Statistics, Engineering

Tools

Databricks

Job description

Are you looking for an exciting job where you can put your skills and talents to work at a company you can feel proud to be a part of? Do you want a workplace that will challenge you and offer you opportunities to learn and grow? A position at Xcel Energy could be just what you’re looking for.

At Xcel Energy, our employees are the driving force behind our success. So we make sure that, here, you can be your best. Doing work that makes a difference for neighbors and communities. Working with a team you can count on to push you. Expanding skills, staying ready for change, and capturing opportunities to grow. All with the support, rewards and recognition you need to thrive – during your internship and beyond.

Xcel Energy is seeking a Data Analyst Intern to support the Electric Distribution System Performance (EDSP) team, located in Colorado. This paid internship provides an opportunity to apply data analytics skills to real‑world utility operations, specifically focused on distribution system performance, reliability, and reporting. The intern will work alongside engineers and analysts supporting EDSP initiatives, including analysis of outage data, reliability metrics, and asset/system performance. The role offers hands‑on experience transforming large datasets into actionable insights that support operational decision‑making and continuous improvement efforts. Through collaboration with cross‑functional partners (engineering, operations, and data teams), the intern will gain exposure to how analytics supports safe, reliable, and efficient electric distribution service. This position will also provide opportunities for professional development, mentorship, and presentation of results to internal stakeholders.

Typical intern responsibilities may include but are not limited to:

• Analyze distribution system performance data (e.g., outages, reliability metrics, asset performance) to identify trends and insights
• Develop and maintain dashboards and reports using Excel, Power BI and Databricks
• Support data validation, cleansing, and preparation across multiple data sources
• Collaborate with engineering and operations teams to support data‑driven decision‑making
• Perform ad‑hoc analysis and reporting to support EDSP initiatives
• Document analytical methods and present findings to team members

This position is for a May 31, 2027 start date. This position may have the possibility to extend beyond the internship’s initial term based on the candidate’s successful performance and Xcel Energy’s business needs.

Minimum Requirements:

• Current student, Sophomore or higher (as of Fall 20270
• Enrolled in an accredited college or university and pursuing a degree in Data Science, Computer Science, Statistics, Engineering, or a related field.
• Able to work full‑time during the summer (up to 40 hours a week)/ part time during the school year (up to 20 hours a week) and commuting to the designated work location in‑person, per our hybrid work policy.
• Able to commute to the Lipan Distribution Center (LDC) at 1123 W 3rd Ave in Denver.

Preferred Qualifications:

• Experience with Microsoft Excel (pivot tables, data analysis, visualization)
• Familiarity with Power BI or similar data visualization tools
• Basic knowledge of SQL, Python, or other data analytics tools
• Strong analytical, problem‑solving, and communication skills
• Interest in electric utility operations, infrastructure, or energy industry
• Enrolled in an accredited college or university OR a community college with plans to transfer to a four‑year university, pursuing a degree in Data Science, Computer Science, Statistics, Engineering, or a related field.

As a leading combination electricity and natural gas energy company, Xcel Energy offers a comprehensive portfolio of energy‑related products and services to 3.4 million electricity and 1.9 million natural gas customers across eight Western and Midwestern states. At Xcel Energy, we strive to be the preferred and trusted provider of the energy our customers need. If you’re ready to be a part of something big, we invite you to join our team.

All qualified applicants will receive consideration for employment without regard to age, race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

Individuals with a disability who need an accommodation to apply please contact us at [e-mail].

Non-BargainingThe anticipated starting base pay for this position is: $19.00 to $20.90 per hourThis position is eligible for the following benefits: Pension, 401(k) plan, Paid time off (PTO), Holidays

Benefit plans are subject to change and Xcel Energy has the right to end, suspend, or amend any of its plans, at any time, in whole or in part.

In any materials you submit, you may redact or remove age-identifying information including but not limited to dates of school attendance and graduation. You will not be penalized for redacting or removing this information.

Deadline to Apply: 10/16/26

EEO is the Law | EEO is the Law Supplement | Pay Transparency Nondiscrimination | Equal Opportunity Policy (PDF) | Employee Rights (PDF)

All Xcel Energy employees and contractors share responsibility for protecting the company's information and systems by adhering to cybersecurity policies, standards, and best practices, recognizing that cybersecurity is everyone's responsibility.

ACCESSIBILITY STATEMENT

Xcel Energy endeavors to make https://www.xcelenergy.com/ accessible to any and all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact Xcel Energy Talent Acquisition at [e-mail]. This contact information is for accommodation requests only and cannot be used to inquire about the status of applications.