Senior GIS & Database Engineer - CIMS

Department: Construction Management

Employment Type: Full Time

Location: Phoenix, AZ

Description

The CIMS (Construction Information Management System) team is seeking a Senior GIS & Database Engineer to support a GIS-based construction data platform used for inspection, testing, and project management workflows. This role combines enterprise GIS administration with professional database management. The position supports a production system built on spatial and non-spatial relational data, web services, and mobile workflows. The successful candidate will demonstrate strong technical capability, sound database practices, and effective collaboration within a highly technical team. 

What are the core responsibilities for the role?

• Administer and maintain enterprise GIS environments 
• Manage spatial and non-spatial relational databases (PostgreSQL-based) 
• Design and maintain ETL workflows for spatial and tabular data 
• Develop database schemas, relationships, and constraints 
• Monitor and optimize database performance (queries, indexing) 
• Implement backup, recovery, and data integrity procedures 
• Publish and maintain GIS services for web and mobile use 
• Support offline data collection and synchronization workflows 
• Troubleshoot system performance and data reliability issues 
• Develop automation scripts and custom tools to support operations 
• Collaborate with software developers and technical staff on system improvements 

Position Characteristics
This is an enterprise systems role rather than a traditional GIS analyst position. The role requires ownership of GIS infrastructure, relational database health, ETL processes, and automation within a production environment. 

Qualifications, Skills, and Competencies:

• Bachelor’s degree in GIS, Computer Science, Engineering, Information Systems, or related field 
• 5+ years of experience in enterprise GIS, database administration, or geospatial systems support 
• Experience managing relational databases (PostgreSQL preferred) 
• Experience with designing and maintaining ETL processes 
• Experience administering ArcGIS Enterprise or ArcGIS Server 
• Strong SQL skills, including query optimization 
• Experience with Python scripting for automation 
• Experience supporting multi-user production environments 
• Understanding of data security and database role management 

Technical Skills – Required 

• Enterprise geodatabase management 
• Relational database administration (schema design, normalization, documentation, indexing, constraints, roles) 
• SQL performance tuning 
• ETL design and data transformation workflows 
• ArcGIS Server administration 
• Backup and recovery procedures 
• Sync-enabled/mobile GIS workflows 
• Cloud-hosted systems (AWS or similar) 

Technical Skills – Preferred 

• Experience performing core DBA functions (performance monitoring, storage planning) 
• Experience developing custom automation tools or database scripts 
• Familiarity with Linux environments 
• Experience supporting production systems with uptime expectations 
• Basic understanding of civil design concepts and terminology. 

Interpersonal Requirements 

• Ability to work effectively within a highly technical team 
• Clear communication with developers and technical stakeholders 
• Strong troubleshooting and analytical mindset 
• Professional judgment in balancing technical standards with operational needs 
• Ability to work independently while contributing to a collaborative environment

Why would a candidate want this job?

At Horrocks, you can expect a competitive base salary and award-winning benefits. Including, but not limited to:

• Medical, dental, vision, life, and disability insurance
• Generous paid time off
• 401(k): 50% match of contribution up to 6%
• Professional development opportunities including in-house training
• Paid professional organization membership and professional licensure

For more information, visit our website at www.horrocks.com

Equal Opportunity Employer including disability and protected veteran status

#LI-KG1