Data Engineer

Main Princeton

Princeton (NJ)

Hybrid

USD 120,000 - 135,000

Full time

11 days ago

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Princeton University is seeking a Data Engineer for the DMIA Integration team in Princeton, NJ. You will own and evolve our data integration practice, ingesting data from enterprise sources into the data warehouse and supporting migration to a cloud-native platform such as Fabric, Snowflake, or Databricks.

You will design ETL/ELT pipelines, enforce data quality and lineage, ensure security, and collaborate with analysts and BI teams.

Qualifications

  • Bachelor's degree in computer science or equivalent.
  • 5+ years of experience with enterprise ETL/ELT tooling.
  • Experience migrating on-prem pipelines to cloud-native platforms.
  • Strong SQL and Python for data transformation.
  • Familiarity with data warehousing concepts.

Responsibilities

  • Design, build, and maintain ETL/ELT pipelines.
  • Lead migration to cloud-native data platforms (Fabric, Snowflake, Databricks).
  • Implement data quality checks and data lineage.
  • Ensure data security and IAM controls.
  • Collaborate with analysts and BI teams.
  • Develop pipeline documentation and SLAs.

Skills

Linux / Shell scripting
Python programming
SQL querying
Cloud fundamentals
IAM concepts
REST APIs
ETL/ELT tooling
Advanced SQL

Education

Bachelor's degree in computer science

Tools

dbt
Fivetran
Snowflake
Databricks

Job description

Overview

The Princeton DMIA Integration team is looking for a Data Engineer to own and evolve our data integration practice. You will be responsible for ingesting data from enterprise source systems into our data warehouse platform — what the CIO office refers to as system-to-data-repository integrations. You will play a key role in our migration to a cloud-native data platform, with candidates expected to bring expertise in modern tooling such as Microsoft Fabric, Snowflake with dbt and Fivetran, or Databricks. The existing data warehouse technologies include IBM DataStage, SQL, Oracle, and Shell-based pipelines running on on-premises Linux infrastructure.

This is a hybrid position based out of Princeton, NJ.

Responsibilities
Architect, Design, Develop:
  • Design, build, and maintain ETL/ELT pipelines to ingest, transform, and load data from source systems into the enterprise data warehouse.
  • Lead the migration of on-premises data pipelines to the organization’s future cloud-native data platform (one of Fabric, Snowflake + dbt + Fivetran, or Databricks).
  • Implement and enforce data quality checks, data lineage tracking, and pipeline observability across all integration workflows.
  • Ensure data security and compliance requirements are met, including encryption at rest and in transit, and access controls aligned with IAM policies.
  • Optimize pipeline performance, scheduling, and resource utilization across batch and incremental load patterns.
Collaborate and Coordinate:
  • Partner with data analysts, BI developers, and source system owners to understand data requirements and translate them into robust ingestion pipelines.
Production Support:
  • Operate and support ingestion and transformation pipelines.
  • Develop and maintain data pipeline documentation, data dictionaries, and SLA agreements for ingestion jobs.
  • Participate in on-call production support rotation and respond to integration incidents per SLA.
  • Contribute to CI/CD pipeline setup and DevOps practices for data integration deployments.
Qualifications
Essential Qualifications:
  • CORE SKILLS
  • Linux / Shell scripting
  • Python programming
  • SQL (query authoring and data validation)
  • Basic networking (DNS, HTTP/S, TCP/IP, proxies, firewalls)
  • Cloud infrastructure fundamentals (any major provider)
  • IAM: LDAP, Active Directory, OAuth 2.0, certificate management
  • 5+ years of proven experience with enterprise ETL/ELT tooling
  • Advanced SQL skills across multiple platforms (Oracle, SQL Server, PostgreSQL)
  • Strong Python programming skills for data transformation, scripting, and pipeline automation
  • Shell scripting proficiency for batch job automation on Linux/Unix servers
  • Hands-on experience with at least one cloud data platform: Microsoft Fabric, Snowflake (with dbt and/or Fivetran), or Databricks
  • Experience with dbt (data build tool) for transformation layer development
  • Linux/Unix systems fluency including file management, cron scheduling, and process monitoring
  • Understanding of data warehousing concepts: dimensional modelling, star/snowflake schemas, slowly changing dimensions
  • Familiarity with basic networking, storage, and cloud infrastructure concepts
  • Experience with IAM and access control: LDAP, Active Directory, and database-level permission management
  • Working knowledge of REST APIs for source system data extraction and pipeline orchestration
  • Ability to document data flows, pipeline architecture, and transformation logic clearly
  • Education : Bachelor’s degree in computer science
Preferred Qualifications:
  • 7+ years proven experience with enterprise ETL/ELT tooling
  • Familiarity with orchestration tools such as Apache Airflow, Azure Data Factory, or Prefect
  • Exposure to streaming or near-real-time ingestion patterns (Kafka, Kinesis, Event Hubs)
  • Experience with data quality frameworks (Great Expectations, Soda, or equivalent)
  • Cloud platform certifications (Azure, AWS, or GCP data engineering tracks)
Princeton University is an Equal Opportunity Employer

and all qualified applicants will receive consideration for employment without regard to age, race, color, religion, sex, sexual orientation, gender identity or expression, national origin, disability status, protected veteran status, or any other characteristic protected by law.

The University considers factors such as (but not limited to) scope and responsibilities of the position, candidate's qualifications, work experience, education/training, key skills, market, collective bargaining agreements as applicable, and organizational considerations when extending an offer.

If the salary range on the posted position shows an hourly rate, this is the baseline; the actual hourly rate may be higher, depending on the position and factors listed above.

The University also offers a comprehensive benefit program to eligible employees. Please see this link for more information.

Standard Weekly Hours

36.25

Eligible for Overtime

No

Benefits Eligible

Yes

Probationary Period

180 days

Essential Services Personnel (see policy for detail)

No

Physical Capacity Exam Required

No

Valid Driver’s License Required

No

Experience Level

Mid-Senior Level

#Ll-DP1

Salary Range

$120,000 to $135,000

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineer
Data Engineer

Princeton University • Princeton (NJ)

On-site
USD 120,000 - 135,000
Research Data Engineer
Research Data Engineer

Princeton University • Princeton (NJ)

On-site
USD 120,000 - 135,000
Associate Director, Data Management
Associate Director, Data Management

Princeton University • Princeton (NJ)

Hybrid
USD 140,000 - 157,000
Data Engineer I (HR Data and Analytics)
Data Engineer I (HR Data and Analytics)

John Hopkin’s University • Baltimore (MD)

Hybrid
USD 88,000 - 154,000
Data Governance Manager
Data Governance Manager

Princeton University • Princeton (NJ)

Hybrid
USD 152,000 - 170,000
Data Engineer, OIT
Data Engineer, OIT

University of Idaho • Moscow (ID)

Hybrid
USD 77,000 - 94,000
Data Engineer, Senior
Data Engineer, Senior

Purdue University • United States

Remote
USD 83,000 - 88,000
Data Engineer, OIT
Data Engineer, OIT

University of Idaho Careers • Moscow (ID)

Hybrid
USD 85,000 - 100,000
Hybrid Data Engineer - Cloud-Native ETL & Pipelines
Hybrid Data Engineer - Cloud-Native ETL & Pipelines

Main Princeton • Princeton (NJ)

Hybrid
USD 120,000 - 135,000
Senior Data Engineer
Senior Data Engineer

The Hanover Insurance Group • Worcester (MA)

Remote
USD 105,000 - 130,000