Posting Details Posting Details Position Number: 129158 Title: Faculty Assistant Functional Title: Data Engineer Category Status: 15-Fac.Non-Tenured,Continuing Con Applicant Search Category: Faculty University Authorized FTE: 100 Unit: ENGR-Civil-Center for Advanced Transportation Technology Campus/College Information: Founded in 1856, University of Maryland, College Park is the state's flagship institution. Our 1,250-acre College Park campus is just minutes away from Washington, D.C., and the nexus of the nation's legislative, executive, and judicial centers of power. This unique proximity to business and technology leaders, federal departments and agencies, and a myriad of research entities, embassies, think tanks, cultural centers, and non-profit organizations is simply unparalleled. Synergistic opportunities for our faculty and students abound and are virtually limitless in the nation's capital and surrounding areas. The University is committed to attracting and retaining outstanding and diverse faculty and staff that will enhance our stature of preeminence in our three missions of teaching, scholarship, and full engagement in our community, the state of Maryland, and in the world. Background Checks Offers of employment are contingent on completion of a background check. Information reported by the background check will not automatically disqualify you from employment. Position Summary/Purpose of Position: 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! We're 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 technologies. Essential 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.
Benefits Summary
Top Benefits and Perks: Faculty Benefits Summary Minimum Qualifications:Education:
- B.S. Degree in Computer Science or related field.
Experience:
- 3+ years experience with design, development, and administration of data platform solutions.
- Experience writing ETL scripts and standalone applications in Python and/or Java.
Knowledge, Skills, and Abilities:
- Expertise writing and tuning SQL queries.
- Experience deploying, configuring, maintaining, and upgrading production-level database servers and services.
- Strong communication skills.
Preferences:Preferences:
- Experience administering PostgreSQL servers, performance tuning, streaming replication, and PgBouncer failover configuration.
- Experience with non-relational data storage and processing solutions like Cassandra, Hadoop, Spark etc.
- Experience working with geospatial datasets, using geospatial extensions (such as PostGIS) and querying features.
- Experience with Linux (RHEL), including writing robust Bash scripts.
- Experience architecting and implementing backup and recovery strategies.
- Experience with Git, Jira, Confluence, and Bitbucket.
Additional Certifications:Additional Information:Posting Date: 03/08/2024 Closing Date:Open Until Filled Yes Best Consideration Date 04/05/2024 Physical Demands Sedentary work. Repetitive motion. Substantial movements (motions) of the wrists, hands, and/or fingers. The worker is required to have close visual acuity to perform an activity such as: preparing and analyzing data and figures; transcribing; viewing a computer terminal; extensive reading. Diversity Statement: The University of Maryland, College Park, an equal opportunity/affirmative action employer, complies with all applicable federal and state laws and regulations regarding nondiscrimination and affirmative action; all qualified applicants will receive consideration for employment. The University is committed to a policy of equal opportunity for all persons and does not discriminate on the basis of race, color, religion, sex, national origin, physical or mental disability, protected veteran status, age, gender identity or expression, sexual orientation, creed, marital status, political affiliation, personal appearance, or on the basis of rights secured by the First Amendment, in all aspects of employment, educational programs and activities, and admissions.