Intern III - Electric Utility Data Analysis Invitation Only

Summary: City of Loveland is seeking an Electric Utility Data Analysis Intern to support the discovery, aggregation, and analysis of data related to the electrical distribution system. The intern will develop dashboards and coordinate with staff to improve data analysis tools and support operational decisions. Responsibilities: - Work as an entry level data analyst reviewing data attached to project workflows for ongoing and planned construction projects - Develop dashboarding tools to help support individual and bulk project management - Gathers, correlates, and analyzes specific data related to net metered customers to support future operations and programs - Performs a variety of tasks that will improve the individual's familiarization with the data, analysis methods, practices, and programs of a municipal utility - Supports operating and maintenance functions, such as troubleshooting, problem identification, and other problem resolution activities that require complex data analysis - Support and coordinate the development tracking tools for serialized electrical equipment in stock and in the field - Reviews assignments to assure efficiency and cost effectiveness - Support tools and methods to query and analyze data from Advanced Metering Infrastructure for the electric distribution system - Support the development of intuitive displays of energy flow to support operational decisions for electric customers - Performs other duties as assigned Required Qualifications: - Must be enrolled in an accredited engineering, computer science, or data science program - Junior standing or higher working towards a Bachelor's degree in engineering or related field - Must be proficient in Microsoft Office Suite including Word, Excel (including PowerQuery), Access, PowerBI and PowerPoint - Familiarity with query languages needed for information and data retrieval - Ability to communicate effectively; both written and verbally - Must be self-motivated and possess the ability to work well with others - Data Analysis experience Preferred Qualifications: - Master's degree in engineering, data science, or other related area of study - Course work in data analysis or data science and an interest in the utility industry is desirable Required Skills: Microsoft Word, Microsoft Excel, PowerQuery, Microsoft Access, Power BI, Microsoft PowerPoint, Query languages, Data Analysis Benefits: Retirement – 457 Plan (employee funded plan), Medical Leave – Accrue 1 hour of leave per 30 hours worked (up to 48 hours), Employees working more than 30 hours per week are eligible to enroll in one of our 2 Medical plan options (per the ACA)