Senior Data Analyst

Xcel Energy Inc; Denver, Northern (CO, KY); Hybrid; USD 85,000 - 121,000; Full time

Benefits offered by this job

Annual Incentive

Medical Plan

Dental Plan

Vision Plan

Life Insurance

401(k) Plan

PTO

Job summary

Xcel Energy in Denver, CO is seeking an advanced analytics professional to define and support analytics solutions across our operations. You will wrangle and analyze large datasets, build visualizations, and present insights to senior leaders.

The role emphasizes cross-functional collaboration, strong SQL skills, and the ability to turn data into actionable recommendations. Hybrid work model with on-site presence required several days weekly.

Qualifications

• Bachelor's degree in MIS, CIS, Statistics, Analytics or related IT degree or equivalent experience.
• Minimum 5 years experience in analytics environment; Expertise in SQL.
• Comfortable working with large, complex data sets and drawing conclusions.
• Proven ability to collaborate and communicate with colleagues at all levels.
• Hands-on experience constructing visual analytics.
• Working knowledge of an analytics data warehouse and big data platform.
• Familiarity with fundamentals of statistics, probability and data pipelines.
• Strong attention to detail.
• Demonstrated ability to wrangle data.
• Comfortable with structured and unstructured data.

Responsibilities

• Data Wrangling/Exploration: ensure data integrity and transform datasets; collaborate with stakeholders.
• Programming: develop efficient code and validate changes; maintain skills across languages.
• Work Management: handle multiple tasks, communicate status and estimates clearly.
• Data Visualization: create meaningful visualizations to convey business impact.
• Communication: translate technical info for senior management and cross-functional teams.
• Continuing Education: pursue training and learn new data sources.

Skills

SQL

Data wrangling

Data visualization

Communication

Cross-functional collab

Education

Bachelor's degree or equivalent experience

Tools

SQL

Python

Tableau

Big data platform

Job description

Xcel Energy(NASDAQ:XEL)is a leading energy provider and Fortune 500company, dedicated to serving millions of electricity and natural gas customers across eight states: Minnesota, Colorado, Wisconsin, Michigan, North Dakota, South Dakota, New Mexico and Texas. We make energy work better for our customers, helping them thrive every day. That means always raising the bar-delivering better service and providing more reliable, resilient, and sustainable energy.

Xcel Energy is a place where you’ll have opportunities to grow, expand your skills, and help lead the clean energy transition. We offer meaningful rewards, recognition, and support to help you build your career and make an impact - both on the job and beyond. Most importantly, it means you’ll be joining a company that knows employees are the driving force behind its success and is committed to helping you be your best.

Xcel Energy supports a hybrid work model to enable collaboration and flexibility. Many roles are expected to work onsite three days per week (Tuesday–Thursday); however, work location expectations vary based on role, team, and business needs.

Position Summary

Responsible for defining, implementing and supporting advanced analytics solutions and capabilities. Provides expertise in the integration, analysis and wrangling of data in support of solving business problems. Manipulates and analyzes complex datasets with a variety of tools; communicates results clearly and concisely to provide insight to multiple audiences.

Essential Responsibilities

• Data Wrangling/Exploration: Follow consistent practices to ensure data integrity and deal with imperfections in data. Effectively process structured data; proficiently integrate data sets from various sources; confidently draw conclusions from data. Collaborate with business stakeholders as needed to ensure solid data understanding and proper data transformation; work cross-functionally with development and engineering teams. Analyze large amounts of information to discover trends and patterns; draw conclusions and gain actionable insights from data.
• Programming: Develop efficient and high quality code; follow solid validation process to ensure consistency and minimize errors; adhere to version control standards. Maintain skills through continuing education; seamlessly transition between languages to apply the right approach to the right problem.
• Work Management - Manages multiple tasks, with the ability to deal with ambiguity and shifting priorities. Communicates status and estimates clearly and timely to management and team members.
• Data Visualization: Create meaningful data visualizations to communicate results and highlight business impact. Utilize various visualization techniques and delivery methods of visualization that are audience appropriate (e.g. interactive, statistical, and exploratory).
• Communication: Effectively communicate technical information to numerous audiences (e.g. senior management, client community, peers and junior associates); effectively develop relationships with individuals inside and outside of IT. Address challenges to analytic processes and influence others to change their approach and work collectively to implement new tools/techniques. Gain support from related stakeholders for analytic solutions.
• Continuing Education - takes a proactive approach to understanding industry and organization-specific business issues. Participates in structured and self-study training courses. Continually improves technical skills and learns new data sources.

Minimum Qualifications

• Bachelor's degree in MIS, CIS, Statistics, Analytics or related IT degree or sufficient experience
• Minimum of 5 years of experience in an analytics environment Expertise in SQL
• Comfortable working with large, complex data sets - drawing conclusions and proposing recommendations
• Proven ability to effectively partner, collaborate, and communicate with technical and non-technical colleagues in various business functions at all levels
• Hands-on experience constructing visual analytics
• Working knowledge of an analytics data warehouse and big data platform
• Familiarity with fundamentals of statistics, probability and data pipelines
• Strong attention to detail
• Demonstrated ability to wrangle data
• Comfortable working with structured and unstructured data

Preferred Qualifications

• Experience developing or applying mathematical, statistical, and AI/ML methods for dead fuel moisture modeling and fire spread simulation.
• Experience developing statistical analyses and quantitative models in support of litigation.

Our culture is grounded in shared values and employee commitments that guide how we work, support one another, and grow together.

Our Values

Connected, Committed, Trustworthy, Safe

Our Employee Commitments

• Work that makes a difference
• A team you can count of
• Opportunities to grow
• Rewards that help you thrive

Non-Bargaining

The anticipated starting base pay for this position is: $84,900.00 to $120,567.00 per year

This position is eligible for the following benefits: Annual Incentive Program, Medical/Pharmacy Plan, Dental, Vision, Life Insurance, Dependent Care Reimbursement Account, Health Care Reimbursement Account, Health Savings Account (HSA) (if enrolled in eligible health plan), Limited-Purpose FSA (if enrolled in eligible health plan and HSA), Transportation Reimbursement Account, Short-term disability (STD), Long-term disability (LTD), Employee Assistance Program (EAP), Fitness Center Reimbursement (if enrolled in eligible health plan), Tuition reimbursement, Transit programs, Employee recognition program, Pension, 401(k) plan, Paid time off (PTO), Holidays, Volunteer Paid Time Off (VPTO), Parental Leave

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.

EEO is the Law (PDF) | Equal Opportunity Statement (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 and https://jobs.xcelenergy.com accessible to any and all users. If you are in need of an accommodation to complete the application process, now or at any time in the future, please complete the Applicant Accommodation Request Form. For any other application related questions, including application follow-ups or technical issues, please use our Recruiting Assistance, Electra, for assistance. Electra can be found in the lower right-hand corner of our Xcel Energy Careers site.