Senior Research Assistant

Position Summary

The Senior Research Assistant I (SRA I) will assist in technical management of two transportation data projects, PORTAL and Bike Ped Portal, that archive diverse transportation data sources and provide access and analysis through a website to transportation professionals.

• Database and website management (90%) – manage or maintain data feeds and database content; develop new analysis and visualization applications and tools for both projects.
• Other duties assigned (10%) – troubleshoot and manage other web‑related projects as assigned by the supervisor.

• Bachelor’s or Master’s Degree with at least two years relevant experience.
• 2+ years of relevant data engineering experience – Deep familiarity with Postgre
  
  SQL (or similar relational database) and Python, 2+ years of PL/SQL experience, advanced understanding of working with big data (> 20 TB) and concurrent data source management, database tuning such as changing parameters, creating indexes, partitioning tables, clustering data, very good at creating complex queries and analyzing data.
• Experience with operating systems – 2+ years working with Linux, installing packages, scheduling cron jobs, diagnosing problems, connecting to servers remotely with SSH, running and restarting services.
• Experience with back‑end development environments – 2+ years of Django framework experience, working with Apache, NGINX, and uWSGI web servers, scheduling jobs using Celery and Supervisor, some familiarity with PHP, Code Igniter framework, 2+ years of experience building and working with RESTful APIs.
• Strong written and communication skills, strong teamwork ethic.

• Creates an environment that acknowledges, encourages and celebrates differences.
• Functions and communicates effectively and respectfully within the context of varying beliefs, behaviors, orientations, identities and cultural backgrounds.
• Seeks opportunities to gain experience working and collaborating in diverse, multicultural, and inclusive settings with a willingness to change for continual improvement.
• Adheres to all PSU policies including the policies on Prohibited Discrimination & Harassment and the Professional Standards of Conduct.

Starting annual salary $67,200 (at 1.0 FTE). 95% premium paid healthcare, generous retirement and vacation package, reduced tuition rates for employee, spouse or dependent at any of the Oregon University System schools.