Data Analyst

JOB DESCRIPTION

Performs data collection, analysis, validation, cleansing, and reporting. Designs, codes, tests, debugs, and documents ETL processes, SQL queries, and stored procedures. Extracts and analyzes data from various sources, including databases, manual files, and external websites. Responds to data inquiries from various groups within an organization. Creates and publishes regularly scheduled and ad hoc reports. Documents reporting requirements and processes and validates data components as required. Requires experience with relational databases and knowledge of query tools and/or statistical software. Strong analytical and organizational skills also essential. Must possess expert level knowledge of MS Excel.

1. Explain what the scope of the work/project is? Project Overview, deliverables (what is this person responsible for).

a. Assist with pulling data from various sources to update scorecards, graphs, and trend reporting for leadership. Develop and enhance Power BI dashboards and help automate reporting processes. Support Databricks and Lakehouse initiatives by identifying creative ways to access, refine, validate, and update data. Build new visualizations, interactive scorecards, and automated reporting tools to support leadership decision-making. Work on multiple scorecards and visual projects across the organization.

2. What does a typical day look like?

a. Building and updating scorecards, graphs, and Power BI dashboards. Responding to leadership data requests and KPI-related questions by analyzing contributing factors and providing insights. Consolidating information for weekly and quarterly performance rollups and reporting.

3. Describe work environment / team culture (supportive/collaborative, teamwork or individual contributor)?

a. Positive and collaborative environment with weekly scorecard review meetings and bi-weekly leadership action plan meetings. Resource will work closely with the Continuous Improvement Leader while supporting broader leadership initiatives.

4. Can you elaborate on any potential risks or safety considerations associated with this role, particularly if the responsibilities extend beyond a standard desk or office environment?*

a. In-office position. No field work identified.

5. What are the work hours/shift (standard, evening, full time/part time, OT required, on call for 24/7 operation)? *

a. Monday through Friday, standard business hours. No overtime or on-call requirements.

1. What are the top 3-5 skills and qualifications (technology/application/software, etc.) required?

a. Microsoft Excel

b. Microsoft Office Suite

c. Data analytics and reporting experience

d. Power BI (preferred)

e. Databricks (preferred)

2. What non-technical skills are necessary (i.e., such as communication, problem solving, team player)?

a. Problem-solving skills

b. Strong communication skills

3. Ideal candidate background and how many years required?

a. Data analytics background with 5-10 years of experience. Utility industry experience is a nice-to-have but not required.

4. Are there any specific companies you like to see on a candidate's resume?

a. N/A

5. Are there any certifications/education that the candidate must possess?

a. No specific certifications or education requirements.

6. Are there any preferred or "nice to have" skills?

a. Power BI

b. Databricks

c. Utility industry experience

d. Experience with Eco Online, Arcos, Utilimarc, or similar systems

1. What is the location of the contract assignment (Full time onsite, hybrid – percent of time on site/home or, are you open to fully remote)? If the resource is expected to be onsite, can you confirm if the resource can park on Xcel property/in the ramp?

a. Hybrid schedule. Tuesday through Thursday onsite, Monday and Friday remote. Location is the Electric Distribution Center in Denver, Colorado. Parking information not discussed