Remote Data Engineer — ETL, Data Warehouse & Oracle/SQL

Penn State University; Oregon; Hybrid; USD 66,000 - 95,000; Full time

Benefits offered by this job

75% tuition discount

Job summary

Penn State Information Technology, in partnership with OPAIR, seeks a Data Engineer to empower informed decision-making through a robust data ecosystem for reporting and university initiatives.

The role involves ETL/warehouse design on SQL Server and Oracle, collaboration across teams, and ongoing process improvement. Flexible location: remote within the US, onsite at University Park, or hybrid.

Qualifications

• Bachelor's Degree 1+ years of relevant experience; or an equivalent combination of education and experience accepted.
• Extensive experience with Oracle database systems and ODI.
• Experience with Microsoft SQL database systems and SSIS.

Responsibilities

• Collaborate with our team of data engineers to support data initiatives.
• Monitor and maintain existing portfolio of data acquisition jobs.
• Contribute to data governance, planning, and data science collaborations.
• Craft, sustain, and enhance ETL solutions on SQL Server and Oracle Infrastructure.
• Analyze and improve development methodologies, including source control and release management.
• Communicate progress and risks with management and peers.
• Collaborate across teams to identify requirements and design solutions.
• Work with various cloud technologies as needed (on-prem focus currently).
• Pursue continuous professional growth and share insights with the team.

Skills

ETL

Data Warehouse

SQL

PL/SQL

Stored Procedures

C#/VB/.Net

Data Architecture

Data Analyst

Python

Cloud Technologies

Communication

Time Management

Collaboration

Education

Bachelor's Degree

Tools

ODI

SSIS

Informatica

Oracle Database

Microsoft SQL Server

Job description

Penn State Information Technology, in partnership with OPAIR, seeks a Data Engineer to empower informed decision-making through a robust data ecosystem for reporting and university initiatives.

The role involves ETL/warehouse design on SQL Server and Oracle, collaboration across teams, and ongoing process improvement. Flexible location: remote within the US, onsite at University Park, or hybrid.