The Center for Advanced Transportation Technology CATT Laboratory is the industry leader for transportation information analysis visualization and user interface design We provide cutting edge analytics products and an integrated suite of situational awareness tools for transportation practitioners These products and services are rapidly changing the way governments operate and make decisions We receive hundreds of gigabytes of transportation data daily making our petabytes of archived data likely the largest collection of traffic data in the world Our clients use our software to monitor real time operations and analyze that data to generate valuable insights Our work saves taxpayer money improves the environment and saves lives Were as passionate about transportation as we are about building great software We care about building usable stable and secure software to analyze massive amounts of data We use cutting edge tech to build and maintain our software We have a mature development process and use industry best practices to build the best software possible Our team is composed of application developers analysts UX designers data scientists IT quality assurance specialists and customer support operating in an Agile environment Our office is in College Park near the University of Maryland easily accessible by DC Metro MARC train bus car and bike Local employees are welcome to work from the office or other locations with a flexible schedule around our core hours We also have many employees who are fully remote and work from different states UMD requires all employees to live in the US We believe varied perspectives build better products are proud to have a diverse team and encourage people of all backgrounds to apply When you join our team you will work to design develop and support over 40 relational database instances and distributed Cassandra and Hadoop instances You will apply your knowledge skills and experience to create stable secure and reliable data platforms supporting custom data analytics applications You will learn new skills and stay current with industry best practices and emerging technologiesEssential duties and responsibilities Design develop deploy and manage data storage and processing solutions Develop data models and schemas for new data sources for both relational and non relational distributed platforms Write and maintain data pipelines to ingest large datasets from APIs and cloud storage to local storage instances Write data retrieval statistical calculation and geospatial analysis queries and stored procedures Assist with analysis and discovery of new datasets for integration into existing internal platforms Work with application developers to debug and tune queries for performance Estimate effort for work tasks and report on work progress to technical team lead Participate in our Tier II Support team rotation