Fairfax County Government
Geographic Information Spatial Analyst III
Fairfax County Government, Fairfax, Virginia, United States, 22032
Job AnnouncementJoin the team at Fairfax County to deliver cutting edge geospatial solutions to the county government and public at large. As a GIS Database Administrator, this senior-level position is responsible for working with the county to manage the county GIS enterprise database and the data stored within it. This position oversees the day-to-day operation of the county GIS enterprise database ensuring the geodatabase is maintained and performing optimally. The ideal candidate will have strong technical skills in geodatabase administration, in-depth knowledge of GIS technology to conduct advanced technical tasks in SQL Server, excellent analytical and problem-solving abilities, troubleshooting skills and excellent communication skills. Key duties for this position include the following.
Responsible for regular database maintenance tasks and administration of GIS enterprise SQL Server geodatabases.Recommend standards for GIS data development and implementation.Proactively monitors the GIS database for proper performance, troubleshoot issues, and collaborates with county IT to ensure the overall health of the GIS database system.Contacts/consults with new and experienced county users in data development efforts including design, implementation, and maintenance of county inter-agency data flow and database synchronization efforts as well as developing and maintaining the GIS database schema and associated documentation.Prepares data for use by county personnel. Management of versioned data and data QA\QC.Designs, develops, documents, data dictionaries, and implements procedures for the maintenance of spatial data within the county's GIS database.Develops automated processes using Python, SQL scripting and modeling techniques for data processing and maintenance.Troubleshoot database issues, including debugging scripts and resolving performance issues.Collaborate with county GIS developers, data stewards, analysts, and other stakeholders to ensure that databases meet business requirements and are integrated with other systems.Ensures the overall quality of the data within the GIS database using tools and/or scripts and making recommendations for improvements and implementing those recommendations.Manages and/or participates in complex projects to develop spatially based solutions for complex business problems in response to agency requests or needs.Publishes data services for internal and external use and maintains the GIS Open Data repository.Acts as project technical lead for data conversion projects, QA\QC and develop and maintain technical documentation.Creates or recommends policies and procedures for managing GIS data and enforces those policies.Participates on governance committees for implementing standards for enterprise GIS data, web, and mobility.Liaises with vendors and regional partners on data modelling and GIS data related procedures.Develops and maintains applications, maps, and dashboards using GIS software such as ArcGIS Online and ArcGIS Enterprise.Stay up-to-date with the latest developments in GIS technology, SQL Server, and related tools.Performs other duties as assigned.
Employment StandardsMINIMUM QUALIFICATIONS:Any combination of education, experience, and training equivalent to the following:(Click on the aforementioned link to learn how Fairfax County interprets equivalencies for "Any combination, experience, and training equivalent to")Bachelor's degree in computer science, geography or related field which included coursework in Oracle and/or another complex database platform; plus two years of experience in working with and developing systems utilizing GIS platforms such as ESRI's ArcGIS Desktop or Server software suites; or performing GIS modeling (e.g., relationship classes, topologies, 3-D, object, data) and spatial analysis (e.g., proximity analysis, image analysis, routing analysis).
NECESSARY SPECIAL REQUIREMENTS:The appointee to this position will be required to complete a criminal background check to the satisfaction of the employer.
PREFERRED QUALIFICATIONS:Seven years of GIS project experience, including three years with a large multi-user geographic information system and using advanced level spatial analysis. Experience with ArcGIS Enterprise, ArcGIS Online, and ArcGIS Pro and extensions including Data Reviwer, Data Interoperability, and Spatial Analyst. SQL Database management competency and experience (e.g., SQL advanced queries, Entity Relationship diagram creation) including Esri Spatial Databases, MS SQL Server, and SQL Server Management Studio and developing scripts in SQL and Python. Skilled in designing and implementing large enterprise geospatial systems, working with enterprise architectures/solutions using ESRI products. Experience with database management systems, including creation of databases, tables, indexes, views, and stored procedures. Experience with SQL Server features such as spatial databases, spatial indexes, and spatial functions. Knowledge of relational database systems and existing programs used for GIS and geodatabase processing. Project management experience. Excellent organizational skills. Excellent verbal and written communication and collaboration skills. Strong understanding of GIS technology, including spatial analysis, and geospatial data processing and data modeling techniques. Strong attention to detail and ability to manage multiple tasks simultaneously. Strong analytical problem-solving skills with the ability to think critically and creatively. Ability to work well with others in a team environment and to work independently with minimal supervision, as required. Ability to be dynamic and proactive, take initiatives to propose and implement innovative solutions to improve processes and outcomes.
PHYSICAL REQUIREMENTS:Work is generally sedentary, performed in a normal office environment. All duties performed with or without reasonable accommodations.
SELECTION PROCEDURE:Panel interview and may include exercise.
The population of Fairfax County is very diverse where 38.7% of residents speak a language other than English at home (Spanish, Asian/Pacific Islander, Indo-European, and others) and we encourage candidates bilingual in English and a foreign language to apply to this opportunity.
Fairfax County Government prohibits discrimination on the basis of race, color, religion, national origin, sex, pregnancy, childbirth or related medical conditions, age, marital status, disability, sexual orientation, gender identity, genetics, political affiliation, or military status in the recruitment, selection, and hiring of its workforce.
Reasonable accommodations are available to persons with disabilities during application and/or interview processes per the Americans with Disabilities Act. Contact 703-324-4900 for assistance. TTY 703-222-7314. DHREmployment@fairfaxcounty.gov EEO/AA/TTY.
#LI-JT1
Responsible for regular database maintenance tasks and administration of GIS enterprise SQL Server geodatabases.Recommend standards for GIS data development and implementation.Proactively monitors the GIS database for proper performance, troubleshoot issues, and collaborates with county IT to ensure the overall health of the GIS database system.Contacts/consults with new and experienced county users in data development efforts including design, implementation, and maintenance of county inter-agency data flow and database synchronization efforts as well as developing and maintaining the GIS database schema and associated documentation.Prepares data for use by county personnel. Management of versioned data and data QA\QC.Designs, develops, documents, data dictionaries, and implements procedures for the maintenance of spatial data within the county's GIS database.Develops automated processes using Python, SQL scripting and modeling techniques for data processing and maintenance.Troubleshoot database issues, including debugging scripts and resolving performance issues.Collaborate with county GIS developers, data stewards, analysts, and other stakeholders to ensure that databases meet business requirements and are integrated with other systems.Ensures the overall quality of the data within the GIS database using tools and/or scripts and making recommendations for improvements and implementing those recommendations.Manages and/or participates in complex projects to develop spatially based solutions for complex business problems in response to agency requests or needs.Publishes data services for internal and external use and maintains the GIS Open Data repository.Acts as project technical lead for data conversion projects, QA\QC and develop and maintain technical documentation.Creates or recommends policies and procedures for managing GIS data and enforces those policies.Participates on governance committees for implementing standards for enterprise GIS data, web, and mobility.Liaises with vendors and regional partners on data modelling and GIS data related procedures.Develops and maintains applications, maps, and dashboards using GIS software such as ArcGIS Online and ArcGIS Enterprise.Stay up-to-date with the latest developments in GIS technology, SQL Server, and related tools.Performs other duties as assigned.
Employment StandardsMINIMUM QUALIFICATIONS:Any combination of education, experience, and training equivalent to the following:(Click on the aforementioned link to learn how Fairfax County interprets equivalencies for "Any combination, experience, and training equivalent to")Bachelor's degree in computer science, geography or related field which included coursework in Oracle and/or another complex database platform; plus two years of experience in working with and developing systems utilizing GIS platforms such as ESRI's ArcGIS Desktop or Server software suites; or performing GIS modeling (e.g., relationship classes, topologies, 3-D, object, data) and spatial analysis (e.g., proximity analysis, image analysis, routing analysis).
NECESSARY SPECIAL REQUIREMENTS:The appointee to this position will be required to complete a criminal background check to the satisfaction of the employer.
PREFERRED QUALIFICATIONS:Seven years of GIS project experience, including three years with a large multi-user geographic information system and using advanced level spatial analysis. Experience with ArcGIS Enterprise, ArcGIS Online, and ArcGIS Pro and extensions including Data Reviwer, Data Interoperability, and Spatial Analyst. SQL Database management competency and experience (e.g., SQL advanced queries, Entity Relationship diagram creation) including Esri Spatial Databases, MS SQL Server, and SQL Server Management Studio and developing scripts in SQL and Python. Skilled in designing and implementing large enterprise geospatial systems, working with enterprise architectures/solutions using ESRI products. Experience with database management systems, including creation of databases, tables, indexes, views, and stored procedures. Experience with SQL Server features such as spatial databases, spatial indexes, and spatial functions. Knowledge of relational database systems and existing programs used for GIS and geodatabase processing. Project management experience. Excellent organizational skills. Excellent verbal and written communication and collaboration skills. Strong understanding of GIS technology, including spatial analysis, and geospatial data processing and data modeling techniques. Strong attention to detail and ability to manage multiple tasks simultaneously. Strong analytical problem-solving skills with the ability to think critically and creatively. Ability to work well with others in a team environment and to work independently with minimal supervision, as required. Ability to be dynamic and proactive, take initiatives to propose and implement innovative solutions to improve processes and outcomes.
PHYSICAL REQUIREMENTS:Work is generally sedentary, performed in a normal office environment. All duties performed with or without reasonable accommodations.
SELECTION PROCEDURE:Panel interview and may include exercise.
The population of Fairfax County is very diverse where 38.7% of residents speak a language other than English at home (Spanish, Asian/Pacific Islander, Indo-European, and others) and we encourage candidates bilingual in English and a foreign language to apply to this opportunity.
Fairfax County Government prohibits discrimination on the basis of race, color, religion, national origin, sex, pregnancy, childbirth or related medical conditions, age, marital status, disability, sexual orientation, gender identity, genetics, political affiliation, or military status in the recruitment, selection, and hiring of its workforce.
Reasonable accommodations are available to persons with disabilities during application and/or interview processes per the Americans with Disabilities Act. Contact 703-324-4900 for assistance. TTY 703-222-7314. DHREmployment@fairfaxcounty.gov EEO/AA/TTY.
#LI-JT1