Data Engineer II - Street Data

Socket.dev; Redlands (CA); On-site; USD 80,000 - 133,000; Full time

Job summary

Esri in Redlands, CA is seeking a Data Engineer to design, develop, and maintain ETL processes that transform street and roadway data for Esri’s core transportation network applications used by millions worldwide.

You will design scalable ETL pipelines, automate data workflows, collaborate with data providers and software engineers, and document data models and best practices to ensure accurate and timely updates to datasets.

Qualifications

• 2+ years of experience building and maintaining ETL pipelines

Responsibilities

• Design, implement, and maintain scalable ETL pipelines for ingesting, transforming, and loading street data from various sources
• Automate, maintain, and optimize data processing workflows to ensure timely and accurate updates to transportation network datasets
• Collaborate with data providers, customers, and software engineers to understand data requirements and deliver high-quality solutions
• Develop and maintain processes to analyze routing requests for data-related errors and collaborate with data providers to ensure issues are corrected in future data updates
• Document data models, workflows, and best practices
• Bachelor’s degree in Computer Science, Data Engineering, GIS, or related field

Skills

Python

SQL

Airflow

Dagster

PostgreSQL

SQL Server

Docker

Git

Communication

Education

Bachelor’s degree in Computer Science, Data Engineering, GIS, or related field

Tools

Airflow

Dagster

Job description

Overview

We are seeking a talented Data Engineer to join our team and play a key role in building world-wide street networks. You will be responsible for designing, developing, and maintaining ETL processes to transform street and roadway data into formats optimized for Esri’s core transportation network analysis and routing applications used by millions around the world.

Responsibilities

• Design, implement, and maintain scalable ETL pipelines for ingesting, transforming, and loading street data from various sources
• Automate, maintain, and optimize data processing workflows to ensure timely and accurate updates to transportation network datasets
• Collaborate with data providers, customers, and software engineers to understand data requirements and deliver high-quality solutions
• Develop and maintain processes to analyze routing requests for data-related errors and collaborate with data providers to ensure issues are corrected in future data updates
• Document data models, workflows, and best practices

Requirements

• 2+ years of experience building and maintaining ETL pipelines
• Proficiency in Python, SQL, and data-processing frameworks or orchestration tools (such as Apache Airflow, Dagster)
• Strong understanding of relational databases (such as PostgreSQL, SQL Server)
• Experience with containerization (such as Docker) and CI/CD pipelines
• Familiarity with version control systems (such as Git)
• Excellent problem-solving and communication skills
• Bachelor’s degree in Computer Science, Data Engineering, GIS, or related field

Recommended Qualifications

• Experience with geospatial data formats
• Experience with cloud data platforms (such as AWS, Azure) and cloud-based ETL tools
• Exposure to big data technologies (such as Spark, Hadoop)
• Knowledge of transportation network modeling and routing algorithms
• Familiarity with APIs for street data (such as OpenStreetMap, HERE, TomTom)
• Understanding of data governance, quality, and security best practices

#LI-EL1

#LI-Onsite

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.

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.