Remote Data Engineer - ETL & Data Warehouse Expert

Penn State Lady Lions; State College (Centre County); Hybrid; USD 66,000 - 95,000; Full time

Benefits offered by this job

Tuition discount

Retirement plans

Paid time off

Medical, dental, vision coverage

Job summary

Penn State Information Technology, in partnership with OPAIR, is seeking a Data Engineer to join our Data Engineering Team. You'll empower informed decision-making through a robust data ecosystem for state and federal reporting, accreditation, and university-wide initiatives.

The role requires experience with Oracle ODI, SQL Server/SSIS, and related data integration tools. You will collaborate across teams to improve ETL processes, data warehouses, and governance, while staying current with BI

Qualifications

• Required Experience: Oracle database systems and ODI.
• Required Experience: Microsoft SQL database systems and SSIS.
• Preferred Experience: Informatica (or comparable tools), SQL, PL/SQL, Stored Procedures, C#, VB/.Net.
• Additional skills: Python/JSON/PowerShell scripting; cloud technologies.
• Excellent communication, time management, and collaboration skills.

Responsibilities

• Collaborate with data engineers to support Penn State IT data initiatives.
• Support OPAIR's Institutional Research, Assessment, Data Governance, Planning and Data Science teams.
• Craft, sustain, and enhance legacy data warehouses/ETL on Microsoft SQL Server and Oracle.
• Monitor and maintain data acquisition jobs.
• Analyze and improve software development methodologies (source control, testing, release management).
• Articulate progress updates and address concerns with management and peers.
• Collaborate intra- and inter-team to identify risks and design solutions.
• Foster partnerships to advance data-related initiatives.
• Work with various cloud technologies as needed; focus on on-premise currently.
• Pursue continuous professional growth and share knowledge with the team.

Skills

ETL processes

Data warehousing

Data architecture

Data analysis

Communication skills

Collaboration skills

Education

Bachelor's Degree

Tools

Oracle ODI

Oracle Database

Microsoft SSIS

SQL Server

Informatica

PL/SQL

C#

VB.NET

Python

PowerShell

JSON

Job description

Penn State Information Technology, in partnership with OPAIR, is seeking a Data Engineer to join our Data Engineering Team. You'll empower informed decision-making through a robust data ecosystem for state and federal reporting, accreditation, and university-wide initiatives.

The role requires experience with Oracle ODI, SQL Server/SSIS, and related data integration tools. You will collaborate across teams to improve ETL processes, data warehouses, and governance, while staying current with BI