Skip to main content
Posted August 23, 2022

Enterprise GIS Data Engineer (Information Systems Analyst)

San Jose, CA, USA Full Time
Compensation: $123,133.92 to $150,018.96 Annually

About the Department The City of San José, the Capital of Silicon Valley, is one of the nation's best managed cities and one of the top ten cities in...

About the Department

The City of San José, the Capital of Silicon Valley, is one of the nation's best managed cities and one of the top ten cities in which to live, work, and do business. Moreover, San José is the center of cultural, government and economic activity for the region. The employees of the City of San José have embraced the following values: Integrity, Innovation, Excellence, Collaboration, Respect and Celebration. The City's Public Works Department is seeking an individual whose values align with the values of the City's employees.

The Department of Public Works is responsible for delivering capital improvement projects for a wide variety of City facilities and infrastructure, maintaining City facilities and fleet assets, facilitating and regulating development activities, and providing animal care and services. The Department is committed to high-quality service, partnering with the community, and providing an excellent environment in which to work.

Salary Information
The total salary range for Information Systems Analyst classification is $123,133.92 – $150,018.96. This amount includes an approximate five percent (5%) ongoing non-pensionable pay. The actual salary shall be determined by the final candidate’s qualifications and experience.

Positions & Duties

Per the City’s COVID19 Mandatory Vaccination Policy, the City requires all employees starting on or after February 11, 2022, to provide proof of vaccination as a condition of employment absent a documented medical and/or religious exemption. Proof of vaccination means that employees are required to be “up-to-date” with regards to the COVID-19 vaccine. Consistent with the Santa Clara County Public Health Order issued on December 28, 2021, "up-to-date" means that an employee is not only "fully vaccinated," but has also obtained any booster doses of a COVID-19 vaccination for which they are eligible, within 15 days of first becoming eligible.

Please note that applications are currently not accepted through CalOpps or any other third-party job board application system. To apply, applicants must complete an application via the City of San Jose’s website at www.sanjoseca.gov/citycareers.

The Public Works Department is recruiting to fill an Information Systems Analyst (ISA) position functioning as a Geographic Information Systems (GIS) Data Engineer within the Enterprise GIS team. The Enterprise GIS team operates out of the Department of Public Works but works across the City to coordinate GIS efforts, lead multi-departmental GIS projects, geospatially-enable City business systems, and administer Enterprise GIS infrastructure for citywide use. The City has standardized on a modern technology stack consisting of Windows Server, Esri ArcGIS platform, Safe Software Feature Manipulation Engine (FME), and SQL Server enterprise geodatabases. The City has an enterprise license agreement with Esri, and the Enterprise GIS team maintains a large Enterprise GIS server environment with public and internal-facing ArcGIS Server instances, complementary ArcGIS Portal and ArcGIS Online organizations, an SDE environment featuring a data catalog with over 900 feature classes, and integrations with dozens of business systems.

The GIS Data Engineer is a professional-level position in the IT professional management series and primarily responsible for GIS data modeling, extract-load-transform (ETL) development, and management of the City’s FME Server environment. The position requires in-depth technical experience with the ArcGIS platform and Safe Software FME as well as the ability to lead large enterprise projects. The ideal candidate must be a strong individual contributor that is able to take full ownership of projects, designing solutions in alignment with City Enterprise GIS standards and industry best practices and working at a hands-on level to build, deliver, and support such solutions. The position demands proven ability to troubleshoot and resolve complex technical issues with limited resources. Paired with a strong technical background, being a team leader, team player, and having a positive attitude are essential to this position.

The Enterprise GIS Data Engineer reports to the Enterprise GIS Manager. This position requires a strong technical background and proven experience with FME Desktop, FME Server, GIS data architecture, and the ArcGIS platform. This position will provide programming that supports the development and maintenance of major applications used citywide. Key responsibilities and duties may include but are not limited to the following:

  • Develop and maintain complex geoprocessing routines and ETL workbenches using FME and Python. Establish standards and best practices for development and tuning of such routines and provide guidance and support to departmental GIS staff and other team members in these areas.
  • Conduct design activities for new datasets by analyzing inputs and developing appropriate schemas in alignment with City standards.
  • Administer the City’s FME Server environment, including planning, scheduling, tuning, and monitoring jobs; troubleshooting and resolving failed jobs; coordinating and conducting system upgrades and other infrastructure maintenance; and maintaining system documentation.
  • Assist with administration of the City’s ArcGIS Enterprise (ArcGIS Server and Portal) environments, including planning for and conducting system upgrades; applying and confirming patches; capacity planning and load testing; publishing and tuning services; managing backups; troubleshooting and resolving system issues; managing security policies, user accounts, roles, and permissions; and maintaining system documentation.
  • Geospatially-enable City business systems by developing and supporting appropriate integrations. Assess business data and develop automated processes for cleansing and processing into the Enterprise GIS data repository, including designing destination schema.
  • Develop solutions for business users using Geocortex, ArcGIS Operations Dashboard, ArcGIS Experience Builder, ArcGIS Web Application Builder, Survey 123, Field Maps, FME or other tools. Work with stakeholders to define requirements and select appropriate tools/technologies considering City standards, licensing, and standard deployment patterns. Design and build solution components. Train and support end users.
  • Work collaboratively with departments to reduce program redundancies and support effective use of enterprise resources. Train end users on enterprise standards and best practices and provide development oversight and guidance.
  • Improve City service delivery by geospatially enabling business systems.

In addition, this position is part of a team responsible for providing GIS support in the Emergency Operations Center (EOC) when activated.

This recruitment may be used to fill multiple positions in this, or other divisions or departments. If you are interested in employment in this classification, you should apply to ensure you are considered for additional opportunities that may utilize the applicants from this recruitment.

Qualifications

Minimum Qualifications:

  • Education: Bachelor's Degree from an accredited college or university in a relevant field.
  • Experience: Four (4) years of progressively responsible professional/journey level experience, of which at least two (2) years of experience include lead technical work in development, implementation, and maintenance of computer systems or application development, specifically Enterprise GIS systems or GIS application development.
  • Acceptable Substitutions:
    • Additional years of increasingly responsible directly related work experience may be substituted for education on a year-for-year basis.
    • Completion of a master’s degree in a relevant field from an accredited college or university may be substituted for one (1) year of the required two (2) years of experience, which include lead technical work in development, implementation, and maintenance of computer systems or application development, specifically Enterprise GIS systems or GIS application development.

Employment Eligibility: Federal law requires all employees to provide verification of their eligibility to work in this country. Please be informed that the City of San Jose will NOT sponsor, represent, or sign any documents related to visa applications/transfers for H1-B or any other type of visa which requires an employer application.

Competencies
The ideal candidate will possess the following competencies, as demonstrated in past and current employment history. Desirable competencies for this position include:

Job Expertise: Demonstrates in-depth, hands-on experience with the following technologies:

  • Development of complex ETL workbenches using FME Desktop
  • Administration of FME Server
  • Relational databases, including geodatabase design and administration on SQL Server
  • T-SQL and Python scripting
  • ArcGIS platform administration (ArcGIS Enterprise/ArcGIS Online)

Demonstrates the following related knowledge, skills, and experience:

  • Experience leading large-scale, complex enterprise technical projects
  • Hands-on experience troubleshooting GIS desktop and server configuration and performance issues
  • Experience gathering user requirements, designing, and building GIS-business system integrations, GIS web applications and field tools
  • Knowledge and experience with applicable professional/technical principles and practices of application management, Citywide and departmental procedures/policies and federal and state rules and regulations
  • Experience establishing policies and procedures for management and use of GIS technologies and providing guidance and direction to enterprise user community

Problem Solving: Approaches a situation or problem by defining the problem or issue; determines the significance of problem; collects information; uses logic and intuition to arrive at decisions or solutions to problems that achieve the desired outcome.

Applies sound problem-solving to the design and buildout of geospatial solutions by gathering requirements and selecting appropriate tools and methods to deliver an efficient and cost-effective solution. Demonstrates ability to isolate and resolve performance and other technical issues within a complex enterprise server environment.

Project Management: Ensures support for projects and implements agency goals and strategic objectives.

Teamwork & Interpersonal Skills: Demonstrates a positive attitude and flexibility along with the ability to develop effective relationships with coworkers and supervisors by helping others accomplish tasks and using collaboration and conflict resolution skills.

Analytical Thinking: Approaching a problem or situation by using a logical, systematic, sequential approach.

Planning: Acts to align own unit's goals with the strategic direction of the organization; Defines tasks and milestones to achieve objectives, while ensuring the optimal use of resources to meet those objectives.

Decision Making: Identifies and understands issues, problems, and opportunities; uses effective approaches for choosing a course of action or developing appropriate solutions.

Technology Use/Management: Uses efficient and cost-effective approaches to integrate technology into the workplace and improve program effectiveness.

Stays current on product roadmaps, technology evolution, and industry trends and effectively plans for and implements relevant changes within the City’s environment to maintain current, performant, secure, and supported systems and applications. Adheres to change control procedures and properly communicates, coordinates, tests, and validates changes.

Communication Skills: Effectively conveys information and expresses thoughts and facts clearly both orally and in writing; demonstrates effective use of listening skills; displays openness to other people’s ideas and thoughts. Demonstrates excellent written and verbal communication skills, including presentation skills.

Demonstrates ability to provide effective training to technical and non-technical users in small and large group settings. Demonstrates experience with technical writing, including system and application design documentation, migration plans, standard operating procedures, and other technical policies and procedures.

Selection Process

The selection process will consist of an evaluation of the applicant's training and experience based on the application and responses to the Job Specific Questions. Only the candidates whose backgrounds best match the position will be invited to proceed in the selection process. Additional phases of the selection process will consist of one or more interviews.

You will be prompted to answer the following job-specific questions during the online application process. Please note that there is a 4,000-character limit, including spaces, for each text response.

  1. Describe a complex FME workbench you have developed to integrate data from disparate systems or sources.
  2. Describe your experience managing FME Server and tuning ETL routines to run on recurring interval in a busy enterprise environment.
  3. Describe your experience administering and supporting Esri’s ArcGIS platform in an enterprise environment. Indicate the general size/architecture and components of the environment(s) you supported.

You must answer all job-specific questions in order to be considered for this vacancy or your application will be deemed incomplete and withheld from further consideration.

If you have questions about the duties of these positions, the selection or hiring processes, please contact Diana Gonzalez via email at [email protected].

Additional Information

Benefits page
Department website

The application deadline is 11:59 PM on August 30, 2022. Please allow adequate time to complete the application and submit before the deadline or the system may not save your application. If your online application was successfully submitted, you will receive an automatic confirmation email to the email address you provided. IF YOU DO NOT RECEIVE THE CONFIRMATION, please email [email protected] and we will research the status of your application. Please contact Human Resources at (408) 535-1285, or [email protected] if you have any questions.

This listing expired on Oct 07. Applications are no longer accepted.