Data Engineer

Penn State University; University Park (IL); Hybrid; USD 66,000 - 95,000; Full time

Benefits offered by this job

75% tuition discount

Robust retirement plans

Paid time off and holidays

Job summary

The Pennsylvania State University is seeking a Data Engineer to join the Data Engineering Team and empower informed decision-making through a robust data ecosystem for reporting and university-wide initiatives. A cover letter and resume are required for consideration.

You'll collaborate with data engineers, support OPAIR and IT teams, and maintain legacy ETL solutions built on Oracle and SQL Server. Remote/hybrid work options are available, with Eastern time zone hours.

Qualifications

• 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 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.
• Minimum Education, Work Experience & Required Certifications: Bachelor's Degree + 1+ years of relevant experience or equivalent.
• Required Certifications: None

Responsibilities

• Collaborate with our team of data engineers to support data initiatives.
• Support OPAIR's Institutional Research, Assessment, Data Governance, Planning, and Data Science teams.
• Craft, sustain, and enhance legacy data warehouses/ETL solutions on Microsoft SQL Server and Oracle Database Infrastructure.
• Monitor and maintain existing portfolio of data acquisition jobs.
• Analyze and enhance software development methodologies, focusing on source code control, testing procedures, and release management.
• Communicate progress updates and address concerns with management and peers.

Skills

SQL proficiency

PL/SQL

C#

Data analysis

Data architecture

Cloud familiarity

Education

Bachelor's Degree

Tools

Oracle ODI

Microsoft SQL Server

SSIS

Informatica

Job description

POSITION SPECIFICS

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.

CORE RESPONSIBILITIES

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.

LOCATION

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.

QUALIFICATIONS

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

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.

SALARY & BENEFITS

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.

CAMPUS SECURITY CRIME STATISTICS

Pursuant to the Jeanne Clery Disclosure of Campus Security Policy and Campus Crime Statistics Act and the Pennsylvania Act of 1988, Penn State publishes a combined Annual Security and Annual Fire Safety Report (ASR). The ASR includes crime statistics and institutional policies concerning campus security, such as those concerning alcohol and drug use, crime prevention, the reporting of crimes, sexual assault and other matters. The ASR is available for review here.

EEO IS THE LAW

Penn State is an equal opportunity employer and is committed to providing employment opportunities to all qualified applicants without regard to race, color, religion, age, sex, sexual orientation, gender identity, national origin, disability or protected veteran status.

If you are unable to use our online application process due to an impairment or disability, please contact 814-865-1473.

Penn State is committed to and accountable for advancing equity, respect, and belonging.

We embrace individual uniqueness, as well as a culture of belonging that supports equity initiatives, leverages the educational and institutional benefits of inclusion in society, and provides opportunities for engagement intended to help all members of the community thrive.

We value belonging as a core strength and an essential element of the university’s teaching, research, and service mission.

There’s a reason Penn State consistently ranks among the top one percent of the world’s universities. Across 24 campuses, our 100,000 students and 40,000 faculty and staff know the real measure of success goes beyond the classroom – it’s the positive impact made on communities across the world. Our ideals stem from our origins as Pennsylvania’s sole land-grant institution, which allow us to continue to bring positive impact to humanity through our teaching, research, and engagement mission. And across the world is a community of Penn Staters – more than half a million strong – driven by that same spirit to serve our local and global communities. At Penn State, passion is met with collaboration in an environment that is rooted in shared pride for the accomplishments of our fellow students, faculty, staff, and alumni. Penn Staters cheer each other on to build a culture committed to service and engagement. Our University values represent our core ethical aspirations for all our daily activities and actions as students, faculty, staff, and volunteers at Penn State. Our values are as follows; Integrity, Respect, Responsibility, Discovery, Excellence, and Community. We Are Penn State. One Community. Impacting Many.