Remote Data Engineer – Oracle/SQL ETL & Data Warehousing

The Pennsylvania State University; State College (Centre County); Remote; USD 110,000 - 150,000; Full time

Benefits offered by this job

75% tuition discount

Excellent benefits

Job summary

Penn State Information Technology (OPAIR) seeks a Data Engineer to join our Data Engineering Team. You will help empower decision-making through a robust data ecosystem for reporting and university-wide initiatives, with a focus on on-premise systems and cloud technologies.

Collaborate across teams to evolve data warehouses, ETL processes, and data governance. Strong SQL/ODI/Informatica experience and excellent communication are essential.

Qualifications

• Extensive experience with Oracle database systems and ODI.
• Experience with Microsoft SQL database systems and SSIS.
• Familiarity with ETL, Data Warehouse, Informatica or comparable tools.
• Proficiency in SQL, PL/SQL, and Stored Procedures.
• C#/VB/.Net programming, data analyst and data architecture skills.
• Excellent communication, time management and collaboration abilities.

Responsibilities

• Collaborate with data engineers to support Penn State's data initiatives.
• Craft, sustain, and enhance legacy data warehouses and ETL solutions on SQL Server and Oracle.
• Monitor and maintain data acquisition jobs; ensure efficiency and reliability.
• Improve software development practices including source control, testing, and release management.
• Communicate progress and risks transparently with management and peers.

Skills

Oracle ODI

MS SQL SSIS

ETL

Data Warehouse

Informatica

SQL

PL/SQL

Stored Procedures

C#/VB/.Net

Data Architecture

Data Analysis

Tools

Python

PowerShell

JSON

Cloud Technologies

Job description

Penn State Information Technology (OPAIR) seeks a Data Engineer to join our Data Engineering Team. You will help empower decision-making through a robust data ecosystem for reporting and university-wide initiatives, with a focus on on-premise systems and cloud technologies.

Collaborate across teams to evolve data warehouses, ETL processes, and data governance. Strong SQL/ODI/Informatica experience and excellent communication are essential.