Education
Benefits
Qualifications
Skills

Description

Position Summary

Why It's a Great Opportunity: This is an exciting professional-level data engineer and ETL developer opportunity that focuses on providing insights to County leadership through building and optimizing the infrastructure required for data capture, cleansing, and storing. You will work independently, and as part of a collaborative team, to help transform the County’s ETL infrastructure and overall data governance architecture

Why It's a Great Department: The IT Division has an excellent reputation as an employer committed to providing outstanding service. We are a national leader in delivering public services through innovation. Our diverse technology solutions are all supported by a robust and secure hybrid infrastructure of on-premises and cloud-based solutions. We are a team that fully embraces an inclusive and diverse environment and believes in a positive, collaborative team-focused approach where we support one another and the work we do. The work you do in this division matters. 

Our team of 130 staff directly supports Pierce County's 3,000 employees with their daily IT needs and provides solutions that benefit County constituents. You will collaborate with skilled professionals and teams over 20 business units to enhance the impact of our support services and uphold the highest standards of public service.

Learn more about Information Technology here.

How to be Successful in the Role: This highly complex and evolving area of IT requires a commitment to continuous learning to stay updated with the latest trends and technologies in ETL development and data management. Interested candidates should be committed to, and find professional satisfaction in, exploring and understanding source data as well as troubleshooting data pipelines to ensure data quality and integrity.

A successful employee will be collaborative, client focused, and have a strong background in ETL development and experience within a modern cloud architecture environment leveraging infrastructure as code, containerization, and code standardization. A successful employee will also be experienced with data-oriented programming languages and data visualization tools (Pentaho, SQL, Python, R, PowerBI/Tableau, etc.). 

Throughout your employment you will receive direct, constructive feedback from peers and your supervisor to facilitate your success and allow you to meet your professional goals. 

Your Future in this Role: The IT Division has access to numerous training opportunities, which include peer, industry, vendor, and official Pierce County training as well as access to established procedures, standards, practices, and system documentation. Our training program is designed to help you develop as both a professional in your role and as a Pierce County employee. Your work will directly impact your community, and it offers a great foundation for future positions within the IT Division and Pierce County. 

Core Daily Responsibilities:

  • Design, build, support, and optimize the infrastructure required for reporting services and data extraction, transformation and loading processes.
  • Recommend and implement process to improve data quality, data reliability, and database performance.
  • Establish relationships with business partners and suppliers to provide technical solutions through the analysis of business workflows and an understanding of business needs.
  • Work with the team to establish and reinforce disciplined software development processes and standards, ensuring error recovery procedures are deployed.
  • Expanding and optimizing our data and data pipeline architecture, as well as optimizing data flow and collection. The ideal candidate is an experienced data pipeline builder and data engineer who enjoys optimizing existing data systems and building them from the ground up.
  • Expertise in data-oriented programming languages and data visualization tools such as Pentaho, SQL, Python, R, and PowerBI/Tableau is highly desired as is a working knowledge of Docker and Kubernetes.

A classification description with a more detailed list of essential functions can be found here.

Qualifications

Minimum Qualifications:

  • A resume and cover letter are required for consideration.
  • A Bachelor’s degree in information technology, computer sciences, business/public administration or related field, AND
  • Four years of information technology or business analysis experience.
  • Additional education or experience which clearly indicates the ability to perform the essential functions of the position may substitute equally on a year of year basis for the recruiting requirements.
  • 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.

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 PCHRRecruit@piercecountywa.gov 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 place people are proud to call home?

We are unable to sponsor or take over sponsorship of an employment visa at this time.

Employee benefits are not just about the kind of services you get, they are also about how much you may have to pay out of pocket. Pierce County offers a competitive benefits package that offers flexibility and peace of mind. We are proud to offer Employee Resource Groups, a focus on professional development in our Leadership Training Program, and a County Book Club. 

We understand that your life revolves around more than just your career and that your priority is making sure that you and your family maintain health and financial security. That's why choice is a key component of our benefits package. We have a selection of health and retirement plans, paid leave, staff training and other compensation benefits that you can mix and match to meet your current and future needs.

Our benefits:

Vacation (Annual Leave)

After approximately six months, employees receive six days of vacation leave. 

Since we value your experience, the amount of vacation you can accrue increases the longer you work with us. Vacation accrues on a bi-weekly basis for full-time employees as follows:

Vacation Accruals:

During years 1-3, 12 Days

During years 4-7, 16 Days

During years 8-13, 20 Days

During years 14-18, 23 Days

During years 19, 24 Days

During years 20, 25 Days

During years 21, 26 Days

During years 22, 27 Days

During years 23, 28 Days

During years 24, 29 Days

During years 25 & thereafter, 30 Days

A maximum of 45 days may be carried from one year into the next.

Pro-Rated for Part-Time based on % of 1.0 FTE.

Military Leave:

Pierce County has a proud history of supporting the armed forces and provides members of the armed forces with up to 21 days paid military leave per state fiscal year.

Holidays:

Some full-time employees are entitled to eleven paid holidays as follows: 

New Year's Day - January 1

Martin Luther King, Jr's birthday - Third Monday in January

President's Day - Third Monday in February

Memorial Day - Last Monday in May

Juneteenth - June 19

Independence Day - July 4

Labor Day - First Monday in September

Veteran's Day - November 11

Thanksgiving Day - Fourth Thursday in November & Friday after

Christmas Day - December 25

Personal Holidays:

Regular full-time and regular part-time employees, and employees occupying limited duration positions, shall also receive two additional paid personal holidays. Paid personal holidays shall only accrue for those employees on County payroll as of January 1 of each year or the first work day following January 1 and must be taken during the calendar year in which it was accrued.

Furlough:

Some Pierce County employees may be designated to receive 10 "furlough" days per year in lieu of holidays. Furlough days are available for use on January 1 and must be scheduled and taken within the calendar year. Employees who leave employment with Pierce County must reimburse the employer for used furlough days based upon the number of remaining holidays.

Sick Leave:

Sick leave accrues on a bi-weekly basis, at the rate of one day per month.

Insurance Benefits:

Employees and families are covered by medical (including vision), dental and basic life insurance. There are multiple medical plans with very affordable monthly premiums that offer coverage throughout Pierce County. Employees are eligible to enroll each year in a flexible spending plan, which enables them to use tax-deferred dollars toward their health care and dependent care expenses. Employees also have the opportunity to participate in supplemental life and long term disability insurance plans. To view premium rates, summary of benefit coverage, and other information, please visit the Pierce County Health Benefits website.

Retirement and Deferred Compensation:

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 will be able to enroll in one of many programs DRS offers. For additional information, check out the Department of Retirement Systems' web site.

Employees also have the ability to participate in the Nationwide Deferred Compensation Plan. This is a supplemental retirement savings program that allows you control over the amount of pre-tax salary dollars you defer as well as the flexibility to choose between multiple investment options.

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.

Miscellaneous Benefits:

Please visit Pierce County's Benefits website for more information.

Telework/Remote Options:

Some departments allow for telework or work-from-home options dependent on the body of work. Learn more about our telework policy here. 

  • All employees are required to be WA State residents after 30 days of employment.
Read Full Description
Confirmed 8 hours ago. Posted a day ago.

Discover Similar Jobs

Suggested Articles