Xcel Energy
is hiring
Senior Data Analyst, Mass Market
About Our Company
As a leading electric and natural gas energy company, we offer a comprehensive portfolio of energy-related products and services to 3.4 million electricity customers and 1.9 million natural gas customers across our eight states: Colorado, Michigan, Minnesota, New Mexico, North Dakota, South Dakota, Texas and Wisconsin.
Our workforce of more than 12,000 is rising to the challenge of a dynamic, constantly-changing utility industry. One that requires us to be even more customer focused, forward thinking and productive while remaining committed to meeting our customers’ fundamental need for safe, reliable, affordable energy.
Do you have a passion for renewable energy, like wind or solar? Or care about giving back to the community? You’ll be in a position to directly impact our energy future.
Job Description & Responsibilities
Anticipated Last Date to Apply: 02/28/24
Multiple Locations:
Minneapolis, MN
Eau Claire, WI
Denver, CO
Be part of the clean-energy transformation. Grow your experience and potential as a senior data analyst supporting Xcel Energy’s renewable choice programs for our customers. Develop and deliver data solutions that support product performance, accuracy and regulatory reporting. Perform analytics to drive business decisions and product designs. Reporting to include tracking and analysis of key customers, vendor and market trends, product metrics, and key performance indicators. Recognize and deliver data and process improvements for the company. Create dashboards and explore automation/AI solutions to improve processes and drive efficiency. May include intern oversight.
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.
Requirements
Minimum Requirements
- 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
What we offer
The anticipated starting base pay for this position is: $81,000.00 to $115,866.66 per year
This position may also be eligible for the following benefits and/or pay components: Pay - 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, Personal holidays, Volunteer Paid Time Off (VPTO) (full-time employees only), Parental Leave
Pay and benefit packages may vary based on position. Some employees are under collective bargaining agreements, which determine the benefits they will receive. If the information conflicts with the terms of the written plan documents governing the plan, the plan document will control. 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.
