Data Engineer – Data Architecture for Data Science & Machine Learning at The Pennsylvania State University

APPLICATION INSTRUCTIONS: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.Approval of remote and hybrid work is not guaranteed regardless of work additional information on remote work at Penn State seeNotice to Out of State Applicants. POSITION SPECIFICSWe 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 Visualization and Decision Support Division of Penn State ARL. 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.The ideal candidate is a PostgreSQL expert who also brings hands-on experience with other modern data storage technologiessuch as NoSQL graph and time-series databasesand can guide the organization in choosing the right tools and structures for each data use case.Located in either State College PA or Reston VAARL is an authorized DoD SkillBridge partner and welcomes all transitioning military members to apply. You will:Design and maintain scalable high-performance database solutions to support data science workflows and ML experimentationPartner with data scientists to understand data access patterns and develop storage strategies that accelerate analysis and model trainingServe as the internal subject matter expert on PostgreSQLincluding schema design indexing partitioning and query optimizationEvaluate and integrate alternative database technologies (e.g. MongoDB Neo4j Redis Cassandra) where they provide clear advantagesLead efforts to optimize data pipelines for both structured and unstructured data used in algorithm developmentEnsure data integrity security and governance across storage systemsImplement monitoring automation and performance-tuning tools for all database environmentsAdvise on data lifecycle managementbalancing accessibility for R&D with efficiency and compliance requirementsRequired skills/experience includes:5 years of experience in data engineering database architecture or related technical rolesExpert-level proficiency in PostgreSQL (query tuning schema design indexing partitioning replication)Strong understanding of data modeling normalization vs. denormalization tradeoffs and query optimizationExperience 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 deploymentExperience 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 skillscomfortable working closely with data scientists ML engineers and software developersPreferred 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).Bachelors or Masters degree in Computer Science Data Engineering or a related field.Work location can be State College PA or Reston VAMINIMUM EDUCATION WORK EXPERIENCE & REQUIRED CERTIFICATIONSIf filled as Research and Development Engineer - Principal Professional this position requires:
Bachelors Degree - Engineering or Science
19 years of relevant experience
Required Certifications:
None

If filled as Research and Development Engineer - Advanced Professional this position requires:
Bachelors Degree - Engineering or Science
5 years of relevant experience
Required Certifications:
None

If filled as Research and Development Engineer - Senior Professional this position requires:
Bachelors Degree - Engineering or Science
14 years of relevant experience
Required Certifications:
NoneARLs purpose is to research and develop innovative solutions to challenging scientific engineering and technology problems in support of the Navy the Department of Defense (DoD) and the Intel Community (IC).FOR FURTHER INFORMATION on ARL visit our web site at .BACKGROUND CHECKS/CLEARANCESEmployment with the University will require successful completion of background check(s) in accordance with University policies.All positions at ARL require candidates topossess the ability to obtain a government security clearance; you will be notified during the interview process if this position is subject to a government background investigation. You must be a U.S. citizen to apply. Employment with the ARL will require successful completion of a pre-employment drug screen.SALARY & BENEFITSThe salary range for this position including all possible grades is $109300.00 - $219600.00.**THE PROPOSED SALARY RANGE MAY BE IMPACTED BY GEOGRAPHIC DIFFERENTIAL**Salary Structure - Information on Penn States salary structurePenn State provides a competitive benefits package for full-time employees designed to support both personal and professional 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 STATISTICSPursuant 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 LAWPenn 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 .Federal Contractors Labor Law PosterPA State Labor Law PosterPenn State PoliciesCopyright InformationHotlines Key Skills Apache Hive,S3,Hadoop,Redshift,Spark,AWS,Apache Pig,NoSQL,Big Data,Data Warehouse,Kafka,Scala Employment Type : Full-Time Experience: years Vacancy: 1 Monthly Salary Salary: 109300 - 219600