Posting Close Date

Mar 7, 2024

Location of Position

Administration - Ops Complex-BLDA

Pay Range

$20.00 - $25.00 /hr

Additional Locations

Salary/Hourly

Hourly

Position Requirements

Hiring Criteria:

The position may be a paid position and/or for school credit. However, the candidate must currently be a student attending college/university or must have graduated in the last six (6) months.

Education Requirements:

• Freshman, Sophomore, Junior, Senior, or Graduate level student majoring in computer science, math, or a related field.

Experience Requirements:

• Experience of writing basic and complex SQL statements (MySQL, Oracle, SQL Server).
• Experience working with Excel data functions such as Vlookup or Pivot Tables
• Course work related to databases (relational, NoSQL, or cloud-based)
• Course work in a programming language such as PowerShell, python, R, or DAX
• Course work in computer design or user interface design
• Power BI Desktop or Power BI Service preferred experience
• Power Query or ETL tool experience preferred
• BI (Tableau, Looker, Cognos, etc.) reporting tool or Excel experience preferred

License Requirements:

• None

Pre-Employment Requirements:

• A background check including education and criminal history.

Job Description

Please submit an unofficial transcript with your application.

Summer Position:

Full Time - 40 hours per week

Monday - Friday [8:00 am -- 5:00 pm] (Hybrid)

Denver Water proudly serves high-quality water and promotes its efficient use to 1.5 million people in the City of Denver and many surrounding suburbs. The organization is a responsible steward of the resources, assets, and natural environment entrusted to us in order to provide a high-quality water supply, a resilient and reliable system, and excellent customer service.

Internship Project Description:

IT Data Services Team is moving the on-premises data warehouse and enterprise reporting software to the Microsoft Azure platform and Power BI. The Intern will help users with Power BI report upgrading and training. Additionally, this position will be responsible for modelling and upgrading the application reports of the Real Estate information Management System (RIMS) application to Power BI reports.

Knowledge, Skills, and Abilities to perform this intern project:

• Must have experience writing basic and complex SQL statements (MySQL, Oracle, SQL Server).
• Must have experience working with Excel data functions such as Vlookup or Pivot Tables
• Course work related to databases (relational, NoSQL, or cloud-based)
• Course work in a programming language such as PowerShell, python, R, or DAX
• Course work in computer design or user interface design

About Denver Water

During the Summer Intern Program, there are THREE (3) REQUIRED ATTENDANCE EVENTS. All interns must participate.

Intern positions do not come with any benefits other than holiday pay (if the employee worked for more than 20 days before the holiday) and Accrued Paid Sick Leave. Interns and Denver Water Temps accrue one hour of Accrued Paid Sick Leave per 30 hours worked, up to 48 hours per year per the Colorado Healthy Families and Workplaces Act .

Denver Water is committed to creating a diverse work environment. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, disability, age, or veteran status.

A background check will be conducted to verify the information submitted on the application. Please be sure that all information on the application is correct and complete, do not say "see resume". If the application is not fully completed, we (Denver Water), will not accept your application.

We are committed to the health and well-being of our employees. Smoking, including e-cigarettes, is prohibited on all Denver Water property.

An offer of employment may be contingent upon satisfactory results of a post-offer drug test and alcohol. Denver Water tests for the following: amphetamines, cocaine, marijuana (THC), opiates, and phencyclidine (PCP). A strength test may also be conducted due to the physical requirements of the position. If the position is deemed safety-sensitive or requires a CDL you will be placed on the random drug and alcohol testing list which means you may be tested if your name is selected while employed at Denver Water.

Denver Water is an Equal Opportunity Employer. We are dedicated to building a culturally diverse workforce. We encourage applications from women, People of Color, veterans, and people with disabilities.

For questions please contact:

Ashley Kessens

1600 W. 12th Avenue

Denver, CO 80204-3412

Ashley.kessens@denverwater.org

EOE/MF