Remote Data Engineer: ETL, Data Warehousing & Oracle SQL

The Pennsylvania State University; University Park (TX); Hybrid; USD 66,000 - 95,000; Full time

Benefits offered by this job

75% tuition discount

Robust retirement plans

Generous paid time off

Job summary

Penn State Information Technology seeks a Data Engineer to support our data ecosystem for state and federal reporting, accreditation, and university-wide initiatives. A cover letter and resume are required for consideration.

Responsibilities include maintaining data warehouses, ETL processes on SQL Server and Oracle, collaborating across teams, and advancing data governance and BI practices. Flexible work location options apply within the U.S.

Qualifications

• Extensive experience with Oracle database systems and ODI.
• Experience with Microsoft SQL Server and SSIS.
• Familiarity with ETL, Data Warehouse, Informatica or similar tools.
• Programming knowledge: SQL/PL-SQL, Stored Procedures, C#/VB/.NET.
• Proficient in Python/JSON/Powershell scripting; cloud familiarity.

Responsibilities

• Collaborate with data engineers on Penn State IT data initiatives.
• Support OPAIR's Institutional Research, Assessment, Data Governance and Data Science teams.
• Maintain and optimize legacy data warehouses/ETL on SQL Server and Oracle.

Skills

ODI

Oracle DB

SQL Server

SSIS

Python

Education

Bachelor's Degree

Tools

Informatica

Oracle PL/SQL

C#/.NET

Job description

Penn State Information Technology seeks a Data Engineer to support our data ecosystem for state and federal reporting, accreditation, and university-wide initiatives. A cover letter and resume are required for consideration.

Responsibilities include maintaining data warehouses, ETL processes on SQL Server and Oracle, collaborating across teams, and advancing data governance and BI practices. Flexible work location options apply within the U.S.