Data Engineer

• Collaborate with our team of data engineers to:

• Support Penn State Information Technology’s data initiatives

• Support OPAIR’s Institutional Research, Assessment, Data Governance, Planning, and Data Science teams, contributing to the continual evolution of Penn State’s data ecosystem.

• Craft, sustain, and enhance legacy data warehouses/ETL solutions on built on Microsoft SQL Server and Oracle Database Infrastructure, ensuring their ongoing efficiency and optimization.

• Monitor and maintain existing portfolio of data acquisition jobs.

• Analyze and enhance existing software development methodologies, focusing on source code control, testing procedures, and release management to drive continuous improvement and effective implementation.

• Articulate progress updates and address any concerns transparently with management and peers for streamlined communication.

• Collaborate inter-team and intra-team to identify risks, issues, requirements; and design solutions for project-level activities.

• Work with team members to facilitate collaborative partnerships by actively exchanging information and lending support to enhance data-related initiatives.

• Work with various cloud technologies as needed. (Current focus is on-premise systems.)

• Proactively pursue continuous professional growth by remaining abreast of the latest advancements in data engineering, technology, and business intelligence practices. Share acquired insights and knowledge with the team to foster a collaborative learning environment.

• Extensive experience with Oracle database systems and Oracle Data Integrator (ODI)

• Experience with Microsoft SQL database systems and Microsoft SSIS

Preferred Experience:

• Familiarity with a combination of the following technologies: ETL, Data Warehouse, Informatica (or comparable/compatible tools/packages); SQL, PL/SQL, Stored Procedure/C#/VB/.Net Programming experience; Data Analyst skills; Data architecture skills.

• Excellent communication, time management, and collaboration skills.

• Additional skills: Python/JSON/Powershell Scripting, familiarity with cloud technologies.

MINIMUM EDUCATION, WORK EXPERIENCE & REQUIRED CERTIFICATIONS Bachelor’s Degree 1+ years of relevant experience; or an equivalent combination of education and experience accepted Required Certifications: None

BACKGROUND CHECKS/CLEARANCES Employment with the University will require successful completion of background check(s) in accordance with University policies.

Penn State does not sponsor or take over sponsorship of a staff employment Visa. Applicants must be authorized to work in the U.S.

The salary range for this position, including all possible grades, is $65,508.00 - $94,980.00.

Salary Structure - Information on Penn State’s salary structure

Penn State provides a competitive benefits package for full-time employees designed to support both personal and professional well-being. In addition to comprehensive medical, dental, and vision coverage, employees enjoy robust retirement plans and substantial paid time off which includes holidays, vacation and sick time. One of the standout benefits is the generous 75% tuition discount, available to employees as well as eligible spouses and children. For more detailed information, please visit our Benefits Page.