Spatial Data Engineer II

Esri; Redlands (CA); On-site; USD 80,000 - 133,000; Full time

Benefits offered by this job

Relocation assistance

Job summary

Esri in Redlands, CA seeks a Spatial Data Engineer to join the geocoding team. You will analyze and load massive spatial data, write Python and SQL scripts, and evaluate new data sources to support product requirements. A Bachelor's degree in CS/IS/GIS is expected, with relocation assistance offered.

Experience with ETL, large normalized databases, and data modeling is required. The base salary range is $79,664 — $133,120 USD and relocation support is provided.

Qualifications

• 2+ years of experience developing Python scripts or tools.
• Experience writing scripts to perform spatial operations, advanced queries, and joins in SQL.
• Intermediate to advanced experience working with large, normalized databases.
• Experience transforming data from flat to normalized databases.
• Prior experience with ETL workflows.
• Ability to read data product specifications and translate into database models and tables.
• 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.

Responsibilities

• Analyze, enhance, prepare and loadspatial 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

Skills

Python scripting

SQL

Data normalization

ETL

Database modeling

Attention to detail

Task prioritization

Education

Bachelor's degree in computer science, information systems, GIS, or related field

Tools

ArcMap

ArcGIS Pro

ArcGIS geoprocessing

Job description

Overview

Esri’s ArcGIS World Geocoding solutions deliver global search and geocoding capabilities to organizations across the world. Search and geocoding are used in a wide range of applications across the ArcGIS platform such as where to open your retail store, how to best allocate resources for delivering packages, or where is, and how do I get to, my favorite coffee shop?

As a Spatial Data Engineer on the geocoding team, you will work with massive spatial data from both commercial and open sources. You’ll be asked to master data specifications, automate processes for acquiring and loading spatial datasets, transform those datasets into normalized data models, and work with product teams to ensure continuous quality improvements driven by the best available content.

If you are passionate about data and geospatial technology, join the geocoding team because you can’t have “The Science of Where” if you don’t know where to start!

Esri has a Relocation Assistance Program and can provide support with relocating to the Redlands, CA area for this position.

Responsibilities

• Analyze, enhance, prepare and loadspatial 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

• 2+ years of experience developing Python scripts or tools
• Experience writing scripts to perform spatial operations, advanced queries, and joins in SQL
• Intermediate to advanced experience working with large, normalized databases
• Experience transforming data from flat to normalized databases
• Prior experience with ETL workflows
• Ability to read data product specifications and translate into database models and tables
• 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

Recommended Qualifications

• Experience working with commercial data from data vendors such as Here, TomTom or Infutor
• Experience working with open-source spatial data such as OpenStreetMap, or Tiger/Line
• 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
• Prior experience with ETL workflows

Total Rewards

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

$79,664 — $133,120 USD

The Company

At Esri, diversity is more than just a word on a map. When employees of different experiences, perspectives, backgrounds, and cultures come together, we are more innovative and ultimately a better place to work. We believe in having a diverse workforce that is unified under our mission of creating positive global change. We understand that diversity, equity, and inclusion is not a destination but an ongoing process. We are committed to the continuation of learning, growing, and changing our workplace so every employee can contribute to their life’s best work. Our commitment to these principles extends to the global communities we serve by creating positive change with GIS technology. For more information on Esri’s Racial Equity and Social Justice initiatives, please visit our website here.

If you don’t meet all of the preferred qualifications for this position, we encourage you to still apply!

Esri is an equal opportunity employer (EOE) and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability status, protected veteran status, or any other characteristic protected by law. If you need reasonable accommodation for any part of the employment process, please email [e-mail] and let us know the nature of your request and your contact information. Please note that only those inquiries concerning a request for reasonable accommodation will be responded to from this e-mail address.

Esri Privacy Esri takes our responsibility to protect your privacy seriously. We are committed to respecting your privacy by providing transparency in how we acquire and use your information, giving you control of your information and preferences, and holding ourselves to the highest national and international standards, including CCPA and GDPR compliance.