URBN Senior Data Engineer

URBN•Philadelphia, PA

13d

About The Position

URBN is seeking a Senior Data Engineer to join our Enterprise Data Warehouse (EDW) team during a pivotal phase of modernization. As we transition from legacy ETL frameworks to cloud-native architectures, we are looking for a builder who can bridge the gap between our established data foundations and the future of AI-augmented engineering. In this role, you will be a key player in modernizing our data pipelines, moving toward high-performance, modular code. You will collaborate with a deeply experienced team of engineers and managers to deliver complex projects across Marketing and Merchandising, ensuring our data ecosystem is scalable, observable, and ready for the next generation of retail analytics.

Requirements

At least 6-8 years of experience in data engineering, with a proven track record of modernizing data pipelines in cloud environments (Snowflake or BigQuery).
Proficiency in modern version control (Git) and CI/CD workflows.
Expert-level SQL skills with the ability to write modular, performant code.
Previous experience with retail or e-commerce data models, specifically in web analytics pipelines and attribution logic.
Deep hands-on experience with Snowflake (including telemetry and administrative functions) and/or Google Cloud Platform (BigQuery).
Comfortable using AI assistants to optimize workflows and generate boilerplate code; ability to judge and audit AI-generated outputs for correctness.
Ability to explain complex technical migrations to stakeholders and collaborate effectively in a "team sport" modeling environment.

Nice To Haves

Familiarity with DAG-based tools (Airflow, Dagster, etc.) is a plus.
Experience with modular SQL transformation pattern is highly preferred.

Responsibilities

Lead the technical refactoring of legacy data pipelines into modern, cloud-native pipelines within Snowflake and Google BigQuery.
Establish and champion best practices for source control (Git), branching strategies, and CI/CD patterns within the Data Engineering team.
Design and implement robust data pipelines for merchandising, web analytics, multi-touch attribution (MTA), and customer journey mapping.
Participate in a rotating on-call schedule to provide support for EDW Data Engineering owned assets and processes. Respond to alerts from Operations, troubleshoot and diagnose technical issues, coordinate with internal stakeholders and vendors, and manage escalations to ensure timely resolution.
Leverage AI coding assistants (e.g., Claude Code, Snowflake Cortex) to accelerate development, documentation, and the refactoring of legacy codebases.
Implement advanced Snowflake telemetry and data quality management functions to ensure pipeline reliability and proactive error detection.
Partner with Senior Engineers to implement "Modeling-as-Code," ensuring new data structures follow established dimensional modeling standards while remaining modular and testable.
Navigate complex integrations across a diverse source landscape, including Warehouse Management System, Sterling Order Management, Island Pacific Merchandising System, and POS systems.
Work closely with our offshore engineering partners to provide technical guidance and ensure consistency across global development efforts.