Data Engineer

Penn State Information Technology, in partnership with Office of Planning, Assessment, and Institutional Research (OPAIR) is seeking a motivated Data Engineer to join our Data Engineering Team. You’ll have the opportunity to use your talent and skill to empower informed decision-making through a robust data ecosystem for state and federal reporting, accreditation, and university-wide initiatives. To be considered for this role, a cover letter and resume are required.

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.

Work location is flexible (restrictions apply): fully remote within the United States, fully in-person at our University Park Campus, or a hybrid model. Standard working hours are in the Eastern time zone.

Required Experience:

• 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

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…