Data Engineer – Data Architecture for Data Science & Machine Learning

The Pennsylvania State University; United States; On-site; USD 146,000 - 319,000; Full time

Benefits offered by this job

75% tuition discount

Job summary

The Pennsylvania State University is seeking a Senior Data Engineer to design and optimize scalable data systems for data science and ML initiatives within the ARL’s Information Science Division. You will partner with data scientists to shape storage strategies, focus on PostgreSQL excellence, and evaluate alternative databases for mixed workloads.

Responsibilities include leading data pipeline optimization, ensuring data integrity and governance, and implementing monitoring and automation

Qualifications

• 5+ years of experience in data engineering, database architecture, or related technical roles.
• Expert-level proficiency in PostgreSQL (schema design, indexing, partitioning, replication).
• Strong understanding of data modeling, normalization vs. denormalization, and query optimization.

Responsibilities

• Design and maintain scalable, high-performance database solutions to support data science workflows and ML experimentation.
• Partner with data scientists to understand data access patterns and develop storage strategies that accelerate analysis and model training.
• Serve as the internal subject matter expert on PostgreSQL—including schema design, indexing, partitioning, and query optimization.
• Evaluate and integrate alternative database technologies where they provide clear advantages.
• Lead efforts to optimize data pipelines for both structured and unstructured data used in algorithm development.
• Ensure data integrity, security, and governance across storage systems.
• Implement monitoring, automation, and performance‑tuning tools for all database environments.
• Advise on data lifecycle management—balancing accessibility for R&D with efficiency and compliance requirements.

Skills

PostgreSQL expert

Database design

Query optimization

Data modeling

Cloud databases

Python scripting

Communication

Education

Bachelor’s or Master’s degree in CS / Data Engineering

Tools

PostgreSQL

MongoDB

Cassandra

Neo4j

Redis

DynamoDB

AWS RDS/Aurora

SQL

Job description

POSITION SPECIFICS

We are seeking a Senior Data Engineer with deep expertise in database design, optimization, and data access strategies to support our growing data science and machine learning initiatives within the Information Science Division of the Applied Research Laboratory (ARL) at Penn State. In this role, you will architect and optimize data systems that empower our data scientists to efficiently research, train, and deploy both traditional and ML-based algorithms and applications.

• Design and maintain scalable, high-performance database solutions to support data science workflows and ML experimentation


• Partner with data scientists to understand data access patterns and develop storage strategies that accelerate analysis and model training


• Serve as the internal subject matter expert on PostgreSQL—including schema design, indexing, partitioning, and query optimization


• Evaluate and integrate alternative database technologies (e.g., MongoDB, Neo4j, Redis, Cassandra) where they provide clear advantages


• Lead efforts to optimize data pipelines for both structured and unstructured data used in algorithm development


• Ensure data integrity, security, and governance across storage systems


• Implement monitoring, automation, and performance‑tuning tools for all database environments


• Advise on data lifecycle management—balancing accessibility for R&D with efficiency and compliance requirements

Required skills/experience includes:

• 5+ years of experience in data engineering, database architecture, or related technical roles


• Expert-level proficiency in PostgreSQL (query tuning, schema design, indexing, partitioning, replication)


• Strong understanding of data modeling, normalization vs. denormalization tradeoffs, and query optimization


• Experience with non-relational databases (e.g., MongoDB, Cassandra, Neo4j, Redis, or DynamoDB)


• Familiarity with machine learning workflows and how data is consumed for training, evaluation, and deployment


• Experience with cloud database services (AWS RDS/Aurora, GCP Cloud SQL, Azure Database)


• Proficiency in SQL and one or more scripting languages (Python preferred)


• Excellent communication and collaboration skills—comfortable working closely with data scientists, ML engineers, and software developers

Preferred skills/experience includes:

• Experience architecting hybrid data ecosystems spanning relational, NoSQL, and analytical databases.


• Knowledge of data lake, warehouse, and feature store architectures (e.g., Snowflake, Redshift, BigQuery, Feast)


• Familiarity with ETL/ELT frameworks and data orchestration tools (e.g., Airflow, dbt)


• Bachelor’s or Master’s degree in Computer Science, Data Engineering, or a related field

Minimum Education, Work Experience & Certifications

• If filled as R&D Engineer - Data Science (ARL) - Principal Professional, this position requires: Bachelor's Degree - Engineering or Science 19+ years of relevant experience Required Certifications: None


• If filled as R&D Engineer - Data Science (ARL) - Advanced Professional, this position requires: Bachelor's Degree - Engineering or Science 5+ years of relevant experience Required Certifications: None


• If filled as R&D Engineer - Data Science (ARL) - Senior Professional, this position requires: Bachelor's Degree - Engineering or Science 14+ years of relevant experience Required Certifications: None

Background checks & clearances

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

Notice regarding employment at the Applied Research Laboratory (ARL): Employees must be eligible to obtain a government security clearance, participate in the ARL drug testing program, and comply with electronic and physical monitoring requirements applicable to federal contractors. ARL operates in a secure information environment involving Unclassified, Controlled Unclassified Information (CUI), and Classified information. Personal electronic devices brought onsite must be registered and may be restricted from certain areas. You must be a U.S. citizen to apply.

Salary & benefits

The salary range for this position, including all possible grades, is $146,040.00 - $318,840.00. This salary range includes an adjustment based on required geographic work location. 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.

Federal Contractors Labor Law Poster PA State Labor Law Poster Penn State Policies Copyright Information Hotlines 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.