SQL Reporting and Data Analysis Intern - Tacoma, United States - Pierce County, WA

Pierce County, WA Tacoma, United States

1 month ago

Show more Collapse job

Description

Salary: $32.95 Hourly

Location : Tacoma, WA

Job Type: Extra Hire

Job Number:

Department: Planning and Public Works

Division: PPW River Roads Maintenance Operations (ROMO)

Opening Date: 04/23/2024

Closing Date: 4/30/2024 11:59 PM Pacific

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:
If you have a question about this opportunity, please email the Recruitment Team at 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 , 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?

Our benefits:

Sick Leave
Extra hires are eligible to receive sick leave in accordance with the WA State Minimum Wage Act. Extra hires are not eligible for other County benefits.

Social Security
All Pierce County employees are covered by the federal Social Security and Medicare systems. The county and the employee pay an equal amount into the system.

Retirement and Deferred Compensation
Pro-tem Judges in District Court, Pro-tem Superior Court Commissioners, Extra Hires with Retirement, and Work Study Students with Retirement are eligible for Retirement and Deferred Compensation and Social Security.

Pierce County employees are members of the State of Washington's Department of Retirement System (DRS) and depending on the position or previous DRS enrollment may be able to enroll in one of many programs DRS offers. For additional information, check out the web site.

We have other current jobs related to this field that you can find below

Senior Accountant

2 weeks ago

CommonSpirit Health Tacoma, United States Full time

Overview · CommonSpirit Health was formed by the alignment of Catholic Health Initiatives (CHI) and Dignity Health. With more than 700 care sites across the . from clinics and hospitals to home-based care and virtual care services CommonSpirit is accessible to nearly one out of ...
Senior Accountant

4 weeks ago

Addison Group Tacoma, United States

Job: · Senior Accountant · Location: · Tacoma, WA (Hybrid) · Pay Rate: · Up to $90K/Year · Job ID: · Our newly founded Tacoma-based privately held healthcare services client is growing and seeking a Senior Accountant to join their Accounting team. The ideal candidate is am ...
Senior Accountant

4 weeks ago

Continuant Tacoma, United States

Job Details · Job LocationFife Office Headquarters - Fife, WA · Position TypeFull Time · Education Level4 Year Degree · Salary Range$65, $85,000.00 Salary/year · Travel PercentageNegligible · Job ShiftDay · Job CategoryAccounting · Description · Senior Accountant · At C ...
Senior Maritime Engineer

1 week ago

WSP Tacoma, United States Regular, Full

This Opportunity · WSP is currently initiating a search for a Ports and Marine Senior Engineer for our Tacoma, WA and Anchorage, AK offices. This position may also sit out of anyone of our West coast Maritime Offices. For over 40-years WSP has been a leader in waterfront structur ...
Staff Accountant

1 week ago

TRA Medical Imaging - Downtown Tacoma Tacoma, United States

Job Summary: · Under the direction of the Accounting Manager, the Staff Accountant is responsible for ensuring the integrity and effective performance of the accounting function and providing accounting support to company management in order to help the organization achieve fisca ...
Associate Hydrogeologist

1 week ago

Terraphase Engineering Inc. Tacoma, United States

Terraphase is seeking candidates for a senior-level environmental Hydrogeologist, Geologist, or Groundwater Geologist. The desired individual can provide strategic and technical support on client projects and effectively support business development efforts within the firm's grow ...
RN Clinical Manager, Home Health

2 weeks ago

CenterWell Home Health Fife, United States

Become a part of our caring community and help us put health first · The Clinical Manager coordinates and oversees all direct care patient services provided by clinical personnel. · Develops, plans, implements, analyzes, and organizes clinical operations for a specific location m ...
Senior Financial Analyst

2 days ago

Stella-Jones Tacoma, United States

Company Overview · Stella-Jones is North America's leading producer of industrial pressure-treated wood products. Responding to the vital infrastructure needs of our economy, we manufacture and distribute railway ties, utility poles, residential lumber and industrial wood product ...
Child Military and Family Life Counselor

2 weeks ago

Leidos Tacoma, United States Full time

Description · Leidos is hiring licensed behavioral health professionals to join our Military and Family Life Counseling (MFLC) HealthySteps initiative to support Joint Base Lewis McChord near Tacoma, WA. · Join the mission to support U.S. military service members and their famil ...
Vascular Ultrasound Tech

6 days ago

MultiCare Tacoma, United States Full time

You Belong Here. · At MultiCare, we strive to offer a true sense of belonging for all our employees. Across our health care network, you will find a dynamic range of meaningful careers, opportunities for growth, safe workplaces, and flexible schedules. We are connected by our mi ...
Regional Accounting Manager

4 weeks ago

Penn Foster Inc Tacoma, United States

This is a remote job opportunity. · About Sound Physicians:Headquartered in Tacoma, WA, Sound Physicians is a physician-founded and led, national, multi-specialty medical group made up of more than 1,000 business colleagues and 4,000 physicians, APPs, CRNAs, and nurses practicin ...
Med Technologist

1 week ago

St Joseph Medical Center Tacoma, United States PRN

Overview · In 2020, united in a fierce commitment to deliver the highest quality care and exceptional patient experience, Virginia Mason and CHI Franciscan Health came together as natural partners to build a new health system centered around the patient: Virginia Mason Francisca ...
Recycling Operations FE Supervisor

1 week ago

Schnitzer Steel Industries Inc Tacoma, United States Full time

The Recycling Operations FE Supervisor (ROFS) reports to the Recycling Operations FE Manager or Recycling Operations Facility Manager I or II. The ROFS assists in the monitoring, coordination, and execution of activities pertinent to the optimum efficiency, and economy of process ...
Sr. IT Systems Analyst

2 weeks ago

Port of Tacoma Tacoma, United States Regular/Full time -

Job Summary · Anticipated starting salary is between $110,364 - $129,840 depending on qualifications. · The Senior IT Systems Analyst leads the continued stewardship, enhancement, optimization, and support of the Port's ERP Platform, Microsoft Dynamics 365 Finance and Operation ...
Supv-Specimen Processing/Phleb

2 weeks ago

MultiCare Tacoma, United States Full time

You Belong Here. · At MultiCare, we strive to offer a true sense of belonging for all our employees. Across our health care network, you will find a dynamic range of meaningful careers, opportunities for growth, safe workplaces, and flexible schedules. We are connected by our mi ...
Physician, Non-Invasive Cardiologist

2 weeks ago

MultiCare Tacoma, United States Full time

About Pulse Heart Institute · MultiCare's Pulse Heart Institute is a partnership between Cardiac Study Center, MultiCare Regional Heart & Vascular Centers, and MultiCare Medical Associates. Sharing a long history of delivering clinically innovative firsts to the region, Pulse He ...
Logistics Warehouse Manager

1 week ago

Samsung SDS America Tacoma, United States

Position Summary: · Samsung SDS plays a leading role in the global logistics market with unique logistics services. With its innovative IT technology, SDS developed the integrated logistics solution called "Cello" in 2010, started its logistics business in 2012 and expanded its ...
Senior Accountant

4 weeks ago

Careers In Government, Inc. Tacoma, United States

Position Description · Senior Accountants perform a variety of advanced professional accounting duties within City government or Public Utilities including monthly closing, reconciliations financial statement preparation and interpretation, and financial analysis. This position ...
Transportation Manager

3 weeks ago

Animal Supply Company Tacoma, United States

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. · Planning and Coordination: Develop and implement transportation strategies and plans to meet the organization's objectives. This includes determining the most effective ...
Medical Director Cancer Institute Hematology Oncology

1 week ago

MultiCare Tacoma, United States Full time

You Belong Here. · At MultiCare, we strive to offer a true sense of belonging for all our employees. Across our health care network, you will find a dynamic range of meaningful careers, opportunities for growth, safe workplaces, and flexible schedules. We are connected by our mi ...