Spatial Data Engineer I

NextGenEnergyJobs; Canada; On-site; CAD 70,000 - 100,000; Full time

Job summary

Esri is seeking a data/ GIS software engineer to analyze, enhance and load spatial data into normalized databases. You will write Python and SQL scripts for data processing, evaluate new data sources for quality, and adjust scripts as data specifications change.

The role requires familiarity with ArcMap, ArcGIS Pro, and geoprocessing, plus experience with ETL workflows and Agile development using Scrum. Strong attention to detail is essential for handling geocoding data.

Qualifications

• 1+ years developing Python scripts or tools.
• Familiarity with spatial operations, advanced SQL queries and joins.
• Experience with large, normalized databases and ETL workflows.
• Bachelor's degree in computer science, information systems, GIS, or related field.

Responsibilities

• Analyze, enhance, prepare and load spatial data into normalized databases.
• Write and maintain Python and SQL scripts for data processing and loading.
• Evaluate new data sources for quality and attribution to support product requirements.
• Review data specifications and changes, adjust scripts and processes as necessary.

Skills

Python scripting

SQL

ETL workflows

Agile/Scrum

Geocoding

Education

Bachelor's degree in CS/IS/GIS

Tools

ArcMap

ArcGIS Pro

ArcGIS geoprocessing

Job description

Esri’s ArcGIS World Geocoding solutions deliver global search and geocoding capabilities to organizations across the world.

Key Responsibilities

• Analyze, enhance, prepare and load spatial data into normalized databases on regular intervals
• Write and maintain Python and SQL scripts for data processing and loading
• Evaluate new data sources for quality and attribution to support product requirements
• Review data specifications and changes, adjust scripts and processes where necessary

Requirements

• 1+ years of experience developing Python scripts or tools
• Familiarity writing scripts to perform spatial operations, advanced queries, and joins in SQL
• Familiarity working with large, normalized databases
• Prior experience with ETL workflows
• Ability to manage priorities and tasks as needed in a fast-paced work environment
• A keen attention to detail and drive to resolve any issues encountered
• Bachelor's degree in computer science, information systems, GIS, or related field
• Experience creating stored procedures for optimizing common tasks and operations
• Experience working with ArcMap, ArcGIS Pro, and ArcGIS geoprocessing
• Prior experience with geocoding, geocoding data, or address data
• Knowledge of Agile software development using Scrum
• Prior experience with software development and release of commercial software product
• #LI-EL1
• #LI-Onsite
• Esri’s competitive total rewards strategy includes industry-leading health and welfare benefits: medical, dental, vision, basic and supplemental life insurance for employees (and their families), 401(k) and profit-sharing programs, minimum accrual of 80 hours of vacation leave, twelve paid holidays throughout the calendar year, and opportunities for personal and professional growth. Base salary is one component of our total rewards strategy. Compensation decisions and the base range for this role take into account many factors including but not limited to skill sets; experience and training; licensure and certifications; and other business and organizational needs.
• A reasonable estimate of the base salary range is