A Data Engineer responsible for designing, developing, and maintaining ETL pipelines to process and optimize street and roadway data for transportation network analysis and routing applications used globally.
Key Responsibilities
Design, implement, and maintain scalable ETL pipelines for street data ingestion, transformation, and loading
Automate, maintain, and optimize data processing workflows for timely and accurate transportation network updates
Collaborate with data providers, customers, and software engineers to understand data requirements and deliver solutions
Develop and maintain processes to analyze routing requests for data errors and coordinate data corrections
Document data models, workflows, and best practices
Requirements
Minimum of 2 years of experience building and maintaining ETL pipelines
Proficiency in Python, SQL, and data-processing frameworks or orchestration tools such as Apache Airflow or Dagster
Strong understanding of relational databases such as PostgreSQL and SQL Server
Experience with containerization such as Docker and CI/CD pipelines
Familiarity with version control systems such as Git
Excellent problem-solving skills
Excellent communication skills
Bachelor’s degree in Computer Science, Data Engineering, GIS, or related field
Benefits & Perks
Relocation Assistance Program
Industry-leading health and welfare benefits including medical, dental, and vision insurance
Basic and supplemental life insurance for employees and their families
401(k) and profit-sharing programs
Minimum of 80 hours of vacation leave
Twelve paid holidays throughout the year
Opportunities for personal and professional growth