Junior Data Engineer (Faculty Specialist)
Core
Design, develop, and support data platforms for transportation analytics, managing relational and distributed databases to generate insights for government operations.
Role type
Junior Data Engineer (Faculty Specialist)
Builds
Relational database instances, distributed Cassandra and Hadoop clusters, and custom data analytics applications for transportation practitioners.
Domain
Transportation data analytics, GIS, and large-scale data processing
Required skills
Python, Java, SQL, ETL scripting, database server administration, Linux (RHEL), Bash scripting
Preferred skills
PostgreSQL administration, Cassandra/Hadoop/Spark/Iceberg/Sedona, PostGIS, AWS/GCP, Git/Jira/Confluence/Bitbucket
Technologies
Python, Java, SQL, Cassandra, Hadoop, Spark, Iceberg, Sedona, PostGIS, Linux (RHEL), Bash, AWS, GCP, PostgreSQL, PgBouncer, Jira, Confluence, Bitbucket, Git
Responsibilities
Design, develop, and support over 40 relational database instances; manage distributed Cassandra and Hadoop instances; write and tune SQL queries; deploy and maintain production-level database servers; create stable and secure data platforms for custom analytics applications.
Seniority
Junior, early career IC
