Data Engineer

The Pennsylvania State University • University Park, FL

1d

About The Position

Penn State Information Technology, in partnership with the Office of Planning, Assessment, and Institutional Research (OPAIR), is seeking a Data Engineer to join its Data Engineering Team. The role supports a robust data ecosystem used for state and federal reporting, accreditation, and university-wide initiatives. The current focus is on on-premise systems, with cloud technologies used as needed. The work location may be fully remote within the United States, fully in person at the University Park Campus, or hybrid, subject to restrictions and approval. Standard working hours are in the Eastern time zone. A cover letter and resume are required.

Requirements

• Extensive experience with Oracle database systems and Oracle Data Integrator (ODI).
• Experience with Microsoft SQL database systems and Microsoft SSIS.
• Bachelor’s degree.
• At least 1 year of relevant experience, or an equivalent combination of education and experience.
• Applicants must be authorized to work in the United States; Penn State does not sponsor or take over sponsorship of staff employment visas.

Nice To Haves

• Familiarity with ETL, data warehousing, and Informatica or comparable/compatible tools and packages.
• SQL, PL/SQL, stored procedure, C#, VB, or .NET programming experience.
• Data analyst skills.
• Data architecture skills.
• Excellent communication, time-management, and collaboration skills.
• Python, JSON, or PowerShell scripting.
• Familiarity with cloud technologies.

Responsibilities

• Support Penn State Information Technology’s data initiatives.
• Support OPAIR’s Institutional Research, Assessment, Data Governance, Planning, and Data Science teams and contribute to the evolution of Penn State’s data ecosystem.
• Craft, sustain, and enhance legacy data warehouses and ETL solutions built on Microsoft SQL Server and Oracle database infrastructure, maintaining efficiency and optimization.
• Monitor and maintain the existing portfolio of data acquisition jobs.
• Analyze and enhance software development methodologies, including source code control, testing procedures, and release management.
• Communicate progress updates and concerns transparently with management and peers.
• Collaborate across and within teams to identify risks, issues, and requirements and design solutions for project activities.
• Exchange information and provide support to team members to strengthen collaboration on data-related initiatives.
• Use cloud technologies as needed.
• Stay current on developments in data engineering, technology, and business intelligence, and share relevant knowledge with the team.

Benefits

• Medical, dental, and vision coverage.
• Retirement plans.
• Paid holidays, vacation, and sick time.
• 75% tuition discount for employees and eligible spouses and children.

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level