Senior Data Engineer

• 
  CURRENT PENN STATE EMPLOYEE (faculty, staff, technical service, or student), please login to Workday to complete the internal application process . Please do not apply here, apply internally through Workday.
  

• 
  CURRENT PENN STATE STUDENT (not employed previously at the university) and seeking employment with Penn State, please login to Workday to complete the student application process. Please do not apply here, apply internally through Workday.
  

• 
  If you are NOT a current employee or student, please click “Apply” and complete the application process for external applicants .
  

JOB DESCRIPTION AND POSITION REQUIREMENTS:

Penn State’s Office of Planning, Assessment, and Institutional Research (OPAIR) is seeking a motivated Senior Data Engineer to join our Data Engineering Team. The Data Engineering Team collaborates with the Data Modeling, Institutional Reporting, Data Science and Analytics, and Operations Teams.  You’ll be able 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. 

Responsibilities Include: 

• Collaborate with a team of data engineers to support OPAIR's Institutional Research, Assessment, Data Governance, Planning, and Data Science teams, contributing to the continual evolution of Penn State’s data ecosystem. 

• Assume a pivotal role as the backup for the Director of Data Engineering, ensuring seamless continuity and essential assistance in their absence. 

• Craft, sustain, and enhance legacy data warehouses/ETL solutions on Microsoft SQL Server and Oracle databases, 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 both management and peers for streamlined communication. 

• Collaborate with teams to identify risks, issues, requirements; and design solutions for project-level activities. 

• Facilitate collaborative partnerships among university teams 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. 

Application instructions: A cover letter and resume are required to be considered for this role.  

Education and experience:

Preferred Experience: 

• Extensive experience with ETL, Data Warehouse, SSIS Programming, ODI, Informatica (or comparable/compatible tools/packages); SQL, PL/SQL, Stored Procedure/C#/VB/.Net Programming experience; Data Analyst skills; Data architecture skills  

• Experience with Microsoft SQL Server and Oracle Database Infrastructure.    

• Management experience in leading projects and/or staff.  Examples of experience can include team-lead for a large-scale project; point-person or liaison for multiple teams on a project or engagement; serve as a mentor for new and fellow team members.    

• Excellent communication, time management, collaboration skills 

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

Requirements: 

• Minimally requires a Bachelor’s degree (or equivalent) or higher in an IT–related discipline and at least 6 years of relevant experience as described above.   

• Work location is flexible: 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. 

The Pennsylvania State University is committed to and accountable for advancing diversity, equity, inclusion, and sustainability in all of its forms. We embrace individual uniqueness, foster a culture of inclusion that supports both broad and specific diversity initiatives, leverage the educational and institutional benefits of diversity in society and nature, and engage all individuals to help them thrive. We value inclusion as a core strength and an essential element of our public service mission.

The salary range for this position, including all possible grades is:

$76,700.00 - $115,100.00

Salary Structure - additional information on Penn State's job and salary structure. 

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 .

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

EEO IS THE LAW

Penn State is an equal opportunity, affirmative action 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.

Federal Contractors Labor Law Poster

PA State Labor Law Poster

Affirmative Action

Penn State Policies

Copyright Information

Hotlines

University Park, PA