What are the responsibilities and job description for the Senior Data Engineer position at King County Sheriff's Office?
Salary
$119,454.40 - $151,424.00 Annually
Location
Seattle, WA
Job Type
Career Service, Full Time, 40 hrs/week
Job Number
2025-23950
Department
KCIT - Information Technology
Division
Engineering Division
Opening Date
02/11/2025
Closing Date
3/2/2025 11:59 PM Pacific
FLSA
Exempt
Bargaining Unit
C19 : PROTEC17-Information Tech
Full- or Part-Time
Full Time
King County Department of Information Technology (KCIT) is seeking a Senior Data Engineer to join our team! The Senior Data Engineer role requires knowledge and experience developing and supporting ETL and system integration processes using industry best practices. The person hired into this position will support a wide range of system integration/ETL processes that use various technologies including: Informatica, Web Services, PowerShell, Python, T-SQL and PL/SQL to transform and transmit data between systems. This position may also be required to provide support for custom-built applications that utilize PL/SQL and/or T-SQL procedures.
King County Department of Information Technology (KCIT) KCIT uses the power of technology to digitally transform King County. Building vibrant communities through digital equity and social justice, KCIT offers innovative solutions that engage, empower, and serve our residents, businesses, communities and interested stakeholders. As the first-place recipient of the 15th annual National Association of Counties (NACo) Digital Counties Survey, KCIT is recognized for its vision, strategy, innovation, and collaboration. KCIT has a focus of delivering smart technology solutions that support customers, building stronger communities through innovation. KCIT is providing the building blocks for many of the region's most critical services. As the business solutions partner, we collaborate with the 18 County departments to develop products and services that better serve the needs of our customers and our community. To learn more about KCIT, please visit:http://kingcounty.gov/depts/it.aspx
Job Duties
Hybrid Work
The work associated with this position will be performed through a combination of onsite work and telecommuting. Employees will have access to shared workspaces at various King County facilities. Employees must reside in Washington state and within a reasonable distance to their King County worksite to respond to workplace reporting requirements. King County has a robust collection of tools and resources to support when working remotely.
Classification
IT Engineer-Senior - 7120700
Union
This position is represented by Protec17: Information Technology
Work Schedule
The normal workweek for this position is Monday through Friday, 8:00 a.m. to 5:00 p.m. Alternative work schedules may be considered. This position is FLSA Exempt and is not eligible for overtime pay.
Forbes named King County as one of Washington State's best employers.
Together, with leadership and our employees, we're changing the way government delivers service and winning national recognition as a model of excellence. Are you ready to make a difference? Come join the team dedicated to serving one of the nation's best places to live, work and play.
Guided by our "True North", we are making King County a welcoming community where every person can thrive. We value diversity, inclusion and belonging in our workplace and workforce. To reach this goal we are committed to workforce equity. Equitable recruiting, support, and retention is how we will obtain the highest quality workforce in our region; a workforce that shares and will help advance our guiding principles - we are one team; we solve problems; we focus on the customer; we drive for results; we are racially just; we respect all people; we lead the way; and we are responsible stewards. We encourage people of all backgrounds and identities to apply, including Native American and people of color, immigrants, refugees, women, LGBTQ , people living with disabilities, and veterans.
King County is an Equal Employment Opportunity (EEO) Employer
No person is unlawfully excluded from employment opportunities based on race, color, religion, national origin, sex (including gender identity, sexual orientation and pregnancy), age, genetic information, disability, veteran status, or other protected class. Our EEO policy applies to all employment actions, including but not limited to recruitment, hiring, selection for training, promotion, transfer, demotion, layoff, termination, rates of pay or other forms of compensation.
Are you ready to APPLY!?
The recruitment for this position is open to all qualified candidates. This recruitment may be used to fill future vacancies. A completed King County Application, Resume and Cover Letter are required for consideration. Applications submitted without all material will not be considered.
Questions
If you have questions regarding this recruitment, please contact Shannon Hoeper, shoeper@kingcounty.gov or 206-263-6957.
Benefits
King County offers a highly-competitive compensation and benefits package designed to meet the diverse needs of our employees and support our employees' health and well-being. Eligible positions receive the following benefits and have access to the following programs:
This is a general description of the benefits offered to eligible King County employees, and every effort has been made to ensure its accuracy. If any information on this document conflicts with the provisions of a collective bargaining agreement (CBA), the CBA prevails.
NOTE: Benefits for Term Limited Temporary (TLT) or Short Term Temporary (STT) positions, including leave eligibility and/or participation in the pension plan through the Washington State Department of Retirement Systems, will vary based upon the terms and details of the position. Short Term Temporary positions are not eligible for an ORCA transit pass.
For inquiries about the specifics of this position, please contact the recruiter identified on this job posting.
01
Are you authorized to work in the United States?
Does your authorization require sponsorship now or in the future from an employer or other source? (This does not preclude you from being considered for this position.)
The person hired for this position must successfully pass a background investigation. Are you willing to undergo a background investigation prior to an offer of employment? This will include reference checks with previous employers, and a Criminal Justice Information System (CJIS) background check including fingerprinting.
Are you applying to this position as an eligible current or previous King County Employee Priority Placement Program Participant? AND Is this position the same or lower percentage of full-time when compared to the position held at the point of the notification of layoff? AND Do you possess the skills and abilities to qualify for this position?
If you answered yes to the question above and you are applying for this position as a Priority Placement Participant, to be considered, you must provide the following three pieces of information in the space provided: 1. The title you held when you received your layoff notice 2. The department you worked in 3. The effective date of your layoff
Required Question
Employer King County
Address King Street Center
201 South Jackson Street
Seattle, Washington, 98104
Phone 206-477-3404
Website http://www.kingcounty.gov/
$119,454.40 - $151,424.00 Annually
Location
Seattle, WA
Job Type
Career Service, Full Time, 40 hrs/week
Job Number
2025-23950
Department
KCIT - Information Technology
Division
Engineering Division
Opening Date
02/11/2025
Closing Date
3/2/2025 11:59 PM Pacific
FLSA
Exempt
Bargaining Unit
C19 : PROTEC17-Information Tech
Full- or Part-Time
Full Time
- Description
- Benefits
- Questions
King County Department of Information Technology (KCIT) is seeking a Senior Data Engineer to join our team! The Senior Data Engineer role requires knowledge and experience developing and supporting ETL and system integration processes using industry best practices. The person hired into this position will support a wide range of system integration/ETL processes that use various technologies including: Informatica, Web Services, PowerShell, Python, T-SQL and PL/SQL to transform and transmit data between systems. This position may also be required to provide support for custom-built applications that utilize PL/SQL and/or T-SQL procedures.
King County Department of Information Technology (KCIT) KCIT uses the power of technology to digitally transform King County. Building vibrant communities through digital equity and social justice, KCIT offers innovative solutions that engage, empower, and serve our residents, businesses, communities and interested stakeholders. As the first-place recipient of the 15th annual National Association of Counties (NACo) Digital Counties Survey, KCIT is recognized for its vision, strategy, innovation, and collaboration. KCIT has a focus of delivering smart technology solutions that support customers, building stronger communities through innovation. KCIT is providing the building blocks for many of the region's most critical services. As the business solutions partner, we collaborate with the 18 County departments to develop products and services that better serve the needs of our customers and our community. To learn more about KCIT, please visit:http://kingcounty.gov/depts/it.aspx
Job Duties
- Develop, maintain, and support data integration/ETL Processes to export, transform, and process data between departmental systems (on premise and SAAS) and to populate KCIT’s data warehouses
- Develop, maintain, and support PowerShell utility scripts
- Maintain and support application and reporting database middle tier SQL
- Monitor, Administer, and Support Informatica Products and Custom-built integration jobs
- Maintain and update system documentation
- Occasionally provide off-hour support for critical systems and associated integrations
- 4 years of experience as a data engineer
- Advanced skills using SQL Server and/or Oracle databases including development of T-SQL and/or PL/SQL procedures
- Proven experience developing and maintaining PowerShell scripts
- Experience supporting and working with cross-functional teams in a dynamic environment
- Clear understanding of SDLC and software development best practices
- Experience with agile and scrum methodologies
- Advanced troubleshooting, analytical and problem solving skills required
- Ability to adhere to established change management processes
- Experience documenting results of analysis appropriately; including experience with data flow diagrams, gap analysis, and writing functional specifications
- Experience overseeing small system enhancement upgrades
- Experience in system support: ability to troubleshoot issues, track, resolve, and document significant system problems and issues requiring a broad understanding of the entire complex system
- Demonstrated competence with MS Windows operating systems and MS Office products required
- An understanding of best practices for keeping PII, PCI, HIPAA, and CJIS data secure
- Excellent organizational skills and attention to detail
- Excellent verbal and written communication skills
- Ability to work effectively in teams or alone with minor supervision
- Must be able to work in a fast-paced environment with daily work processing deadlines
- Demonstrated customer service orientation and skills
- Experience using Informatica Cloud or PowerCenter products and with developing, scheduling, maintaining, and supporting resulting processes
- Experience with Cloud computing (AWS or Azure)
Hybrid Work
The work associated with this position will be performed through a combination of onsite work and telecommuting. Employees will have access to shared workspaces at various King County facilities. Employees must reside in Washington state and within a reasonable distance to their King County worksite to respond to workplace reporting requirements. King County has a robust collection of tools and resources to support when working remotely.
Classification
IT Engineer-Senior - 7120700
Union
This position is represented by Protec17: Information Technology
Work Schedule
The normal workweek for this position is Monday through Friday, 8:00 a.m. to 5:00 p.m. Alternative work schedules may be considered. This position is FLSA Exempt and is not eligible for overtime pay.
Forbes named King County as one of Washington State's best employers.
Together, with leadership and our employees, we're changing the way government delivers service and winning national recognition as a model of excellence. Are you ready to make a difference? Come join the team dedicated to serving one of the nation's best places to live, work and play.
Guided by our "True North", we are making King County a welcoming community where every person can thrive. We value diversity, inclusion and belonging in our workplace and workforce. To reach this goal we are committed to workforce equity. Equitable recruiting, support, and retention is how we will obtain the highest quality workforce in our region; a workforce that shares and will help advance our guiding principles - we are one team; we solve problems; we focus on the customer; we drive for results; we are racially just; we respect all people; we lead the way; and we are responsible stewards. We encourage people of all backgrounds and identities to apply, including Native American and people of color, immigrants, refugees, women, LGBTQ , people living with disabilities, and veterans.
King County is an Equal Employment Opportunity (EEO) Employer
No person is unlawfully excluded from employment opportunities based on race, color, religion, national origin, sex (including gender identity, sexual orientation and pregnancy), age, genetic information, disability, veteran status, or other protected class. Our EEO policy applies to all employment actions, including but not limited to recruitment, hiring, selection for training, promotion, transfer, demotion, layoff, termination, rates of pay or other forms of compensation.
Are you ready to APPLY!?
The recruitment for this position is open to all qualified candidates. This recruitment may be used to fill future vacancies. A completed King County Application, Resume and Cover Letter are required for consideration. Applications submitted without all material will not be considered.
Questions
If you have questions regarding this recruitment, please contact Shannon Hoeper, shoeper@kingcounty.gov or 206-263-6957.
Benefits
King County offers a highly-competitive compensation and benefits package designed to meet the diverse needs of our employees and support our employees' health and well-being. Eligible positions receive the following benefits and have access to the following programs:
- Excellent medical, dental, and vision coverage options: King County provides eligible employees with options, so they can decide what’s best for themselves and their eligible dependents
- Life and disability insurance: employees are provided basic coverage and given the opportunity to purchase additional insurance for both the employee and eligible dependents
- Retirement: eligible King County employees may participate in a pension plan through the Washington State Department of Retirement Systems and a 457(b) deferred-compensation plan
- Transportation program and ORCA transit pass
- 12 paid holidays each year plus two personal holidays
- Generous vacation and paid sick leave
- Paid parental, family and medical, and volunteer leaves
- Flexible Spending Account
- Wellness programs
- Onsite activity centers
- Employee Giving Program
- Employee assistance programs
- Flexible schedules and telecommuting options, depending on position
- Training and career development programs
This is a general description of the benefits offered to eligible King County employees, and every effort has been made to ensure its accuracy. If any information on this document conflicts with the provisions of a collective bargaining agreement (CBA), the CBA prevails.
NOTE: Benefits for Term Limited Temporary (TLT) or Short Term Temporary (STT) positions, including leave eligibility and/or participation in the pension plan through the Washington State Department of Retirement Systems, will vary based upon the terms and details of the position. Short Term Temporary positions are not eligible for an ORCA transit pass.
For inquiries about the specifics of this position, please contact the recruiter identified on this job posting.
01
Are you authorized to work in the United States?
- Yes
- No
Does your authorization require sponsorship now or in the future from an employer or other source? (This does not preclude you from being considered for this position.)
- Yes
- No
The person hired for this position must successfully pass a background investigation. Are you willing to undergo a background investigation prior to an offer of employment? This will include reference checks with previous employers, and a Criminal Justice Information System (CJIS) background check including fingerprinting.
- Yes
- No
Are you applying to this position as an eligible current or previous King County Employee Priority Placement Program Participant? AND Is this position the same or lower percentage of full-time when compared to the position held at the point of the notification of layoff? AND Do you possess the skills and abilities to qualify for this position?
- Yes, I was given a layoff notice from my Career Service role at King County and I am within two years of the effective date of my layoff. Additionally, the position I was laid off from was the same or a higher percentage of FT status when compared to this one.
- No.
If you answered yes to the question above and you are applying for this position as a Priority Placement Participant, to be considered, you must provide the following three pieces of information in the space provided: 1. The title you held when you received your layoff notice 2. The department you worked in 3. The effective date of your layoff
Required Question
Employer King County
Address King Street Center
201 South Jackson Street
Seattle, Washington, 98104
Phone 206-477-3404
Website http://www.kingcounty.gov/
Salary : $119,454 - $151,424
