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
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