Sql programmer Jobs in Gilbert, AZ

Overview

As one of the nation's leading electric transmission line construction companies, MasTec Power Delivery companies engineer and construct efficient and reliable electrical transmission, distribution, and substation & switchyard systems. Our extensive workforce includes both union and nonunion teams, which, combined with our specialized equipment fleet, allows us to effectively meet our clients' needs for power delivery, emergency restoration, and ongoing maintenance. We've been involved in some of the most challenging and recognizable electric projects across the . From the electric plant to the end users, MasTec's experienced managers and crews consistently deliver transmission, distribution, and substation & switchyard services with an unfailing commitment to safety, integrity, and sustainable practices.

The GIS Integrator Analyst bridges the gap between micro-level building architecture and macro-level spatial geography. This role focuses on integrating Building Information Modeling (BIM) data with Geographic Information Systems (GIS) to create unified spatial databases, digital twins, and asset management pipelines. The Analyst ensures data interoperability, resolves coordinate system discrepancies, and builds workflows that connect design files directly to active field operations and long-term facility maintenance frameworks.

Responsibilities

Core Responsibilities1. Data Integration & Interoperability (40%)

• Develop, implement, and maintain automated ETL (Extract, Transform, Load) pipelines to migrate 3D BIM data seamlessly into GIS databases.
• Resolve cross-platform coordinate system conflicts by georeferencing local architectural files into global coordinate reference systems (CRS).
• Standardize attribute mapping between BIM data schemas and GIS spatial data models.
• Configure and maintain cloud-based integration environments.
• Spatial Analysis & Digital Twins (30%)
• Perform advanced spatial analyses combining regional topographic maps, utility lines, and building interior layouts.
• Build, update, and manage interactive smart dashboards and 3D digital twins for active jobsites and completed facilities.
• Process reality capture data, including drone photogrammetry, LiDAR point clouds, and GPS surveys, to validate as-built conditions against digital design models.
• Stakeholder Collaboration & Quality Assurance (20%)
• Collaborate with design engineers, survey teams, project managers, and clients to eliminate data silos.
• Conduct QA/QC audits on engineering submittals to ensure compliance with company geospatial and asset tracking standards.
• Train field personnel and project teams on deploying mobile GIS viewing tools and georeferenced design apps.
• Innovation & Process Automation (10%)
• Write custom Python scripts, SQL queries, or FME workflows to automate repetitive data translation tasks.
• Evaluate emerging ConTech (Construction Technology) tools to improve cross-platform data flows continuously.

Qualifications

Required QualificationsEducation & Experience

• Education: Bachelor’s degree in GIS, Geomatics, Civil Engineering, Construction Management, or a related technical field.
• Experience: 2–5 years of professional experience working directly with both BIM workflows and GIS analysis, preferably within the AEC (Architecture, Engineering, Construction) industry.

Technical Tech Stack Requirements

• GIS Software: High proficiency in Esri ArcGIS Pro, ArcGIS Online/Enterprise, and ArcGIS Field Maps.
• Data Integration Tools: Experience with FME (Feature Manipulation Engine) or similar spatial data conversion tools.
• Programming/Databases: Working knowledge of Python (ArcPy, ArcGIS API) and relational databases (SQL Server, PostgreSQL/PostGIS).

Core Competencies

• Deep understanding of georeferencing, projection systems, and spatial data accuracy standards.
• Strong critical thinking and data troubleshooting capabilities.
• Excellent verbal and written communication skills to explain technical processes to non-geospatial teams.

Preferred Qualifications

• BIM Software: Proficient with Autodesk Revit, Civil 3D, and Navisworks.
• Esri Technical Certifications or Autodesk Certified Professional credentials.
• FAA Part 107 Commercial Drone Pilot License.
• Experience setting up asset handovers for Facility Management (FM) systems.