Job Description
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
...data integrity. The ideal candidate has a background in polysomnography with at least two years of experience, strong scoring skills, and good patient communication abilities. Night shifts are available with differential pay and a 40-hour work week. #J-18808-Ljbffr
...the opportunity to speak with you! As a certified Great Place to Work for 7 years in a row,... ...Plan. Essential Functions: Assists Residents with activities of daily living... ...Licensure/Certification: Current State Nurse's Aide registration. Experience and...
...Depot, you can be yourself and also be part of something bigger.Position Purpose:Corporate LP Managers must actively drive the Loss Prevention function and initiatives within a designated area(s) of responsibility. This role provides cross-functional Loss Prevention support...
...Job Description Job Description About This Role The Lead Educator plays a pivotal role in fostering the physical, mental, emotional, and social well-being of children in their care, providing a nurturing and supportive environment that promotes their development...
...Soil and Water Conservation Scientist $30-55/hr Remote Freelance STEM We're looking for soil and water conservation scientists to help evaluate and improve AI systems trained on sustainable land and water management practices. Your scientific expertise will directly...