Information and Analytics Intern

Serves as a beginner data analyst supporting Prince William Water's Information and Business Analytics initiatives. Under direct supervision, the intern will document procedures, develop dashboards, design data flows, and monitor data quality. They will also participate in stakeholder requirements-gathering meetings, understand customer needs, and produce reports accordingly. Demonstrates a commitment and supports a culture of diversity, equity, and inclusion.

• Assist in the development of dashboards and reports within the Power BI environment.
• Support the monitoring and enhancement of data quality.
• Participate in stakeholder requirement-gathering meetings to support dashboard development.
• Assist with the updating and maintenance of SQL database queries.
• Prepare ad-hoc queries using standard reporting tools and other available resources.
• Demonstrate familiarity with machine learning (ML) and artificial intelligence (AI) models and tools, including the ability to create and maintain such models.
• Perform other duties as assigned or required.

Essential Competencies:

• Excellent professional demeanor with a willingness to work outside of comfort zones in a fast-paced, evolving technology environment.
• Ability to manage multiple work streams and learn quickly.
• Proficiency with Python and SQL.
• Ability to develop dashboards using Power BI or equivalent tools.
• Experience working with SQL or other database management systems.
• Knowledge of data warehouses, data marts, and data lakes.
• Understanding of AI solutions, SaaS, and cloud concepts.
• Familiarity with machine learning, AI, and business intelligence tools, in addition to coding experience, specifically with Python.

• Current enrollment in an undergraduate or graduate degree program at an accredited college or university with a major in Computer Science, Data Science, Math, or related field. If enrolled in an undergraduate program, must be a junior or senior upon employment.

• Students must have and maintain a minimum cumulative grade point average (GPA) of 3.0 on a 4.0 scale.

• None

The physical demands and work environment characteristics described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions.

• Physical demands: The work is mostly sedentary with periods of light physical activity. Typical positions require workers to lift and carry up to 20pounds; climb stairs, bend, reach, hold, grasp, and turn objects; and operate computer or typewriter keyboards. The work requires the ability to speak clearly and to see and hear clearly, with or without correction. May be required to work beyond the normal scheduled hours of work; and attend evening meetings and work sessions.
• Work environment: Primary work is performed indoors in a standard office environment. The noise level in the work environment is usually moderate.