Data Engineer
Princeton University2 months ago
Princeton, NJ, USASenior
Base Salary
$120k - $135k/yr
Responsibilities
- Design, build, and maintain ETL/ELT pipelines for ingesting, transforming, and loading enterprise source-system data.
- Lead migration of on-premises data pipelines to a cloud-native platform using Microsoft Fabric, Snowflake with dbt and Fivetran, or Databricks.
- Implement data quality checks, lineage tracking, pipeline observability, security controls, and compliance measures.
- Optimize batch and incremental pipeline performance, scheduling, and resource utilization.
- Collaborate with data analysts, BI developers, and source-system owners to define data requirements and ingestion solutions.
- Operate and support production ingestion and transformation pipelines, including participation in an on-call rotation and incident response.
- Maintain pipeline documentation, data dictionaries, transformation logic, and ingestion-job SLA agreements.
- Contribute to CI/CD setup and DevOps practices for data integration deployments.
Requirements
- Bachelor’s degree in computer science.
- At least 5 years of proven experience with enterprise ETL/ELT tooling.
- Advanced SQL skills across Oracle, SQL Server, and PostgreSQL.
- Strong Python programming skills for data transformation, scripting, and pipeline automation.
- Shell scripting proficiency and fluency with Linux/Unix systems, including file management, cron scheduling, and process monitoring.
- Hands-on experience with at least one cloud data platform: Microsoft Fabric, Snowflake with dbt and/or Fivetran, or Databricks.
- Experience with dbt for transformation-layer development.
- Understanding of data warehousing concepts, including dimensional modeling, star and snowflake schemas, and slowly changing dimensions.
- Familiarity with networking, storage, cloud infrastructure, IAM, and access control, including LDAP, Active Directory, and database permissions.
- Working knowledge of REST APIs for source-system extraction and pipeline orchestration.
- Ability to clearly document data flows, pipeline architecture, and transformation logic.
- Preferred qualifications include 7 or more years of enterprise ETL/ELT experience, familiarity with Apache Airflow, Azure Data Factory, or Prefect, exposure to Kafka, Kinesis, or Event Hubs, experience with Great Expectations or Soda, and relevant Azure, AWS, or GCP data engineering certifications.
Benefits
- Benefits eligible with a comprehensive benefits program for eligible employees.
- Standard weekly hours are 36.25; the position is not eligible for overtime.
- The position has a 180-day probationary period.
- The role includes participation in an on-call production support rotation.
- Full-time salary range is $120,000 to $135,000.
Tech Stack
Apache AirflowApache KafkaAWSAzureDatabricksdbtGoogle Cloud PlatformLinuxMicrosoft SQL ServerPostgreSQLPythonSnowflakeSQL
Categories
Data Engineering
About Princeton University
Princeton University is a private Ivy League research university that provides undergraduate and graduate education and supports research across science, engineering, humanities, and social sciences. Its operations are funded by tuition, sponsored research, and a large endowment, and it engages industry through technology transfer, licensing, and corporate partnerships. Founded in 1746 and headquartered in Princeton, New Jersey, it maintains extensive campus IT and research infrastructure to support teaching, discovery, and administration.