SQL Reporting and Data Analysis Intern - #1337829

Description

Position Summary

Why It's a Great Opportunity

The Maintenance and Operations (M&O) team with Planning and Public Works (PPW) has large amounts of information waiting to be mined. You will provide reports and data analysis using MS SQL, Transact SQL, MS SQL Server Management Studio, MS Visual Studio and MS SSRS Reporting Services. Your reports will allow managers to better optimize decisions that will shape future improvements and projects that have a positive impact on the Pierce County communities.

Why It's a Great Department

PPW is a diverse and fast-moving department filled with motivated professionals working to ensure Pierce County is positioned to handle growth while building, operating, and maintaining reliable infrastructure to support livable communities. PPW is responsible for a broad and complex portfolio of services that provides unique opportunities to collaborate, innovate, and inspire. We are responsible for the County road and levee systems, sewer systems, airports, ferries, building permits, environmental review, sustainability, community planning, and code enforcement - just to name a few!

Learn More About Planning And Public Works Here.

How to be Successful in the Role:

Your positive customer service and attitude will be utilized as you communicate within the division and across other divisions in PPW. Many will be making important decisions based on the data provided, so accuracy is vital.

Core Daily Responsibilities

• Duties will include eliciting and documenting report requirements, developing SQL queries, designing reports, and facilitating testing and troubleshooting with report end users.
  
  

Qualifications

Minimum Qualifications:

• Experience in MS SQL databases, SQL Reporting Services, and query writing is required.
• Experience with data visualization tools such as Microsoft Power BI.
• Knowledge of GIS spatial systems and data formats.
• An associate degree in data systems management, data analytics, business analysis, or related field is preferred.
• Experience in Extract, Transform, and Load (E.T.L.) processes and tools.
• As a condition of employment, the applicant will need to authorize and complete a background check. Information received from the background check is reviewed case-by-case and will not necessarily remove an applicant from consideration.
  
  

Compensation is $32.95 per hour.

Supplemental Information

To Be Considered For This Opportunity Please

• Complete and submit a detailed online Pierce County Employment Application by selecting "APPLY" above or go to: www.piercecountywa.org/jobs .
• If you have a question about this opportunity, please email the Recruitment Team at [email protected] and specify the Job Number and Title.
• If you do not have internet access, you may visit your local public library or any WorkSource location and use their computers.
• Individuals needing accommodation in the application, testing process or need this job announcement in an alternative format may call Human Resources at (253) 798-7480, at least two days prior to the need.
  
  

This is a competitive selection process. Your application will be reviewed and evaluated for the quality and quantity of education/experience in the areas listed. Applicants whose qualifications most closely correspond to the County's needs will be eligible for further consideration. Notification of application status normally occurs 2 to 3 weeks after the closing date. Short notice may be given to applicants to participate in further selection processes which may include assessments, phone screen, and interviews.

At Pierce County, diversity, equity, and inclusion means commitment, not a single step. We strive to foster an inclusive environment that supports equitable access to opportunities throughout your career. We want to recruit, develop, and maintain a talented workforce from various backgrounds, cultures, lifestyles, and perspectives, committed to our vision. Employees of the County have local, direct, and visible impact in our diverse community. Will you join us in keeping Pierce County a great place to live, work, and raise a family?