7176 - GIS (ESRI) Systems & Integration Technical Analyst (Must CURRENTLY reside in Sacramento to be considered)

The selected GIS (ESRI) Technical Analyst shall provide specialized technical services to support RES geospatial data integration, management, and application development. Key responsibilities and deliverables include:

1. Development and Document ESRI Schema and Integration Requirements

• Analyze business and data integration needs to document ESRI database/schema requirements for RES geospatial data and integration scenarios.
• Collaborate with stakeholders and technical teams to define schema structures and integration touchpoints.

2. Create ESRI Enterprise Geodatabase to Store RES Geospatial Data

• Design and implement an ESRI Enterprise Geodatabase for centralized storage and management of RES geospatial datasets.
• Configure data models, spatial references, and security settings according to documented requirements.

3. Support Virtual Server Deployment

• Ensure virtual server deployments comply with ESRI system requirements, including installation of SQL Server and ESRI ArcGIS Enterprise Geodatabase.
• Work with SMUD IT resources from the Application Administration team to provision required servers and deploy database components.

4. Build ESRI Feature Classes for Data Integration

• Develop and configure ESRI Enterprise Geodatabase feature classes to support integration and storage of data from multiple applications and platforms.
• Define the feature class schema complexity based on requirements from step 1.

5. Develop and Support Integration of Other Applications with ESRI

• Develop and support integration between ESRI and other applications, utilizing API, REST, and database integration capabilities.
• Coordinate with business and IT teams to enable seamless data exchange between ESRI, ESB, and other platforms as needed.

6. Develop and Deploy ESRI Web Map Services

• Create and configure ESRI maps and feature service projects, including all required projects and schema integrations.
• Publish data services to ESRI REST endpoints for use in ESRI mapping
  applications and integration with ESB or other external applications.

7. Develop and Update ESRI Mapping Applications

• Design, update, and deploy ESRI mapping applications for RES, leveraging newly integrated and managed datasets.
• Ensure developed applications meet usability, performance, and security best practices, and support improved business processes.

Mandatory Requirements

The proposed GIS (ESRI) Technical Analyst(s) must meet the following minimum qualifications/mandatory requirements:

1. Demonstrated Professional Skills in GIS:

• Proven technical expertise in GIS concepts, analysis, and tools.

2. ESRI ArcGIS Enterprise Experience:

• Hands-on experience with ESRI ArcGIS Enterprise, including Server, Portal, and Datastore components.

3. ESRI Mobile Solutions Experience:

• Experience configuring and using ESRI mobile applications, such as Survey123, Collector, and Runtime.

4. ESRI ArcGIS SDE Experience:

• Experience working with ESRI ArcGIS Spatial Database Engine (SDE).

5. GIS Server Technologies Development:

• Proven capability in developing and deploying GIS server technologies.

6. Database Experience (Oracle, SQL, etc.):

• Experience working with databases, particularly Oracle and/or SQL Server, including triggers, procedures, and database operations.

7. Programming Skills:

• Proficiency in programming languages relevant to GIS such as Python, .NET, and JavaScript.

8. ESRI Enterprise Geodatabase Design and Deployment:

• Demonstrated experience developing and documenting ESRI geospatial database schemas, designing and implementing ESRI Enterprise Geodatabases, building feature classes, and publishing web map/feature services.

9. Map Layer Update and Deployment:

• Experience deploying updated map layers in ESRI platforms, including configuration and maintenance of map pop-up attributes, symbology, map scale, and defining query or filtering configurations

Desirable Qualifications

1. Experience with Utility Data:

• Prior experience managing, analyzing, or integrating utility-related spatial data.

2. Recent Experience

• ESRI training, certifications, and/or recent hands-on experience/ project engagement.