Senior Data Analyst at Xcel Energy in Denver, CO, 80205

Job description

• 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.

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

• 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
• 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.

Skills

Required

• Expertise in SQL
• Strong attention to detail
• Demonstrated ability to wrangle data

Benefits

• 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.
• The anticipated starting base pay for this position is: $84,900.00 to $120,567.00 per year