Apply on Employer Site

Career Center at Portland State University · 3 weeks ago

Senior Research Assistant I

Portland, OR

Full-time

Onsite

Mid, Senior Level

$67K/yr - $67K/yr

2+ years exp

Portland State University is home to the Transportation Research and Education Center, which focuses on impactful transportation research. The Senior Research Assistant I will assist in managing transportation data projects, performing statistical analyses, and maintaining databases to support transportation professionals.

Higher Education

No H1B

Responsibilities

Performing basic statistical analyses

Managing and maintaining our databases

Coordinating and developing data collection procedures

Helping with managing or maintaining the data feeds and the data in the database

Help manage and maintain primarily the back-end the web interface with some front-end work, and help in developing new analysis and visualization applications and tools for both projects

Other duties assigned at the discretion of the supervisor, which may include troubleshooting and some management of other web related projects that may come up

Qualification

PostgreSQLPythonData engineeringPL/SQLDjango frameworkLinuxBack-end developmentTeamwork ethicTechnical documentationCommunication skills

Required

Bachelor's or Master's Degree with at least two years relevant experience

2+ years of relevant data engineering experience

Deep familiarity with PostgreSQL (or other similar relational database) and Python

2+ years of PL/SQL experience

Advanced understanding of working with big data (> 20 TB) and concurrently managing multiple data sources, database tuning such as changing database parameters, creating indexes, partitioning tables, and clustering data

Very good at creating complex queries and analyzing data

Experience with the following operation systems: 2+ years working with Linux

Must know how to do many of the OS amid work such as installing packages, scheduling cron jobs, diagnosing problems, connection to servers remotely with SSH, running and restarting services, etc

Experience with back-end development environments: 2+ years of Django framework experience

Working with Apache, NGINX, and uWSGI webservers

Scheduling jobs using celery and supervisor

Some familiarity with PHP

CodeIgniter framework, 2+ years of experience

Building and working with restful APIs

Experience building technical documentation

Strong written and communication skills

Strong teamwork ethic

Preferred

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's policies including the policies on Prohibited Discrimination & Harassment and the Professional Standards of Conduct

Contributes to a culture of environmental stewardship, practices resource conservation, and actively works toward achieving long-term sustainability goals

At Portland State University, all employees are expected to conduct themselves in a professional manner which maintains a safe, respectful, and productive environment for faculty, students, administrators, and staff

Work Sample