Senior Data Engineer

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

• 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.