Senior GIS Database Engineer
Senior GIS Database Engineer
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Summary
The King County Department of Information Technology (KCIT) GIS Center is seeking a senior team member to manage and enhance our Geographic Information System (GIS) data platforms. This position will involve designing developing and managing robust spatial enterprise data warehouses ensuring database integrity performance and security. You will manage ETL processes to integrate geospatial data from diverse sources. A key focus will be on geodatabase modernization including migrating solutions to the cloud developing and deploying software and proactively troubleshooting data platform issues.
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 firstplace 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 regions 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/depts/it.aspxJob Duties
- Design implement and maintain onpremises and cloud enterprise spatial databases
- Develop and manage ETL processes for spatial data integration
- Automate spatial data processing and workflows using SQL Python and other scripting languages
- Support GIS application development and integration
- Collaborate with King County professionals to coordinate enterprise GIS services policies standards and procedures
- Ensure compliance with industry and organizational standards and best practices for enterpriselevel spatial databases and configurations
- Optimize database performance ensure data integrity and implement security measures
- Provide expert troubleshooting and technical support for geodatabase systems both onpremises and cloudbased
- Conduct quality assurance quality control and user acceptance testing for GIS data and applications
Experience Qualifications Knowledge Skills
- Bachelors degree in Geography/GIS Applied Science or a related field OR any combination of relevant education training and experience
- Expertlevel proficiency in SQL and spatial databases (PostgreSQL/PostGIS SQL Server Spatial Oracle Spatial)
- Proven expertise in database design development administration and optimization techniques
- Strong Python development skills including data analysis and automation
- Proficiency with Esri ArcGIS Pro ArcGIS Online and ArcGIS Enterprise
- Experience with cloud platforms (AWS Azure) for database deployment and management
- Proficiency in developing and consuming APIs and web services (REST SOAP) for data integration
- Experience with Visual Studio Code Jupyter Notebook and Git for source control and code management
- Experience implementing and administering system monitoring solutions
- Strong analytical and problemsolving skills
- Experience with project management and working in Agile/Scrum environments
- Excellent communication skills for effective crossfunctional collaboration
- Ability to document and diagram database architecture and workflows
- Masters or Advanced degree in Geography/GIS Applied Science or a related field
- Esri Technical Certifications (e.g. ArcGIS Enterprise Administration ArcGIS Developer)
- Cloud (AWS or Azure) development or architecture certification
- GISP (Certified GIS Professional)
Supplemental Information
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 worksiteto respond to workplace reporting requirements. King County has a robust collection of toolsandresources to support when working remotely.
Classification
IT EngineerSenior
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. This position will participate in After Hours Support (AHS) Rotation.
Forbes named King County as one of Washington States best employers.
Together with leadership and our employees were changing the way government delivers service and winning national recognition as a model of excellence. Are you ready to make a differenceCome join the team dedicated to serving one of the nations best places to live work and play.
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 and Resumeare required for consideration (Please note that Cover letters are encouraged but not required).Applications submitted without all material will not be considered.
Questions
If you have questions regarding this recruitment please contact Shannon Hoeper or.
Required Experience:
Senior IC
Employment Type
Full-Time
