GIS Analyst

Screening Questions

• Are you a GIS professional with an inclination to dive deep? Please explain.
• Are you an ArcGIS Expert capable of going beyond GIS?
• Are you able to code (in Python or any other language) to meet GIS/Data/ETL needs? Please explain.
• Are you able to work with GIS Databases (SQL Server/Oracle Spatial) and write code? Please explain.

Position Description:

The GIS Data Architect under the Enterprise Section reports to the Michigan Department of Technology, Management, and Budget (DTMB) Agency Services supporting the Michigan Department of Transportation (MDOT). This position will work with Enterprise Application Architect and Enterprise Data Architect. This position will be partnering with MDOT’s GIS Team, MDOT application Business leads and MDOT Information Stewards. This position will collaborate with GIS data authors and consumers, Center for Shared Solutions (CSS) GIS Administrators, Roads & Highways specialists, MDOT SDE (Spatial Data Engine) Geodatabase Administrators, information management staff, solution developers and business domain stakeholders, such as information managers, data stewards and business analysts.

Experience Required:

• A minimum of 5 years of experience in GIS-IT and enterprise data architecture.
• Minimum of 2 years integrating GIS systems built on relational databases with other applications (built in-house and vendor). Ability to quickly comprehend the GIS needs of applications and develop smart data solutions to deliver the data.

Skillsets Required:

• Expert level experience with ESRI ArcGIS products such as ArcCatalog, ArcMap or ArcPro.
• Experience building model data workflows to extract, transform and load GIS data using ArcGIS Model Builder is a must. (Experience on Spatial ETL tools such as Safe FME will be a plus.)
• Experience using the ESRI Roads and Highways Database and ESRI Versioned/non-Versioned Datasets.
• Knowledge in Python Programming using the ArcPy and ArcGIS Python API.
• Demonstratable experience in building GIS integration capabilities (feature or web service based) with applications.
• Knowledge and proven skills in MS SQL Server Spatial and Oracle Spatial.
• Excellent communication skills to collaborate at all levels of the organization.

Position Summary:

• The MDOT GIS Architect will be the key resource in integrating MDOT applications to the ESRI Roads and Highways for GIS data. The duty of this position involves understanding the data collected in Roads & Highways Database, MDOT’s SDE environment and data needs of MDOT’s applications. It also includes identifying the differences and driving towards accuracy, standardization, and synchronization. This position will assist the annual migration of MDOT applications while working towards the new and improvised migration process. This position will participate in key meetings involving GIS data as a DTMB Agency Service representative and speaks to the GIS needs of consumer applications.
• This position will also be responsible for managing the ArcGIS License manager which involves setup, update of the MDOT’s ESRI License manager, and adding of licenses periodically.