On Call Dimensional Engineer Jobs (NOW HIRING)

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.

• Modernize & Migrate: Lead the technical refactoring of legacy data pipelines into modern, cloud-native pipelines within Snowflake and Google BigQuery.

• Technical Standards: Establish and champion best practices for source control (Git), branching strategies, and CI/CD patterns within the Data Engineering team.

• Pipeline Engineering: Design and implement robust data pipelines for merchandising, web analytics, multi-touch attribution (MTA), and customer journey mapping.

• Operational Excellence & On-Call Support: 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.

• AI-Augmented Development: Leverage AI coding assistants (e.g., Claude Code, Snowflake Cortex) to accelerate development, documentation, and the refactoring of legacy codebases.

• Data Quality & Observability: Implement advanced Snowflake telemetry and data quality management functions to ensure pipeline reliability and proactive error detection.

• Collaborative Modeling: Partner with Senior Engineers to implement "Modeling-as-Code," ensuring new data structures follow established dimensional modeling standards while remaining modular and testable.

• Source Integration: Navigate complex integrations across a diverse source landscape, including Warehouse Management System, Sterling Order Management, Island Pacific Merchandising System, and POS systems.

• Offshore Collaboration: Work closely with our offshore engineering partners to provide technical guidance and ensure consistency across global development efforts.

• Experience: 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).

• Modern Tooling: Proficiency in modern version control (Git) and CI/CD workflows. While we currently use Skybot for orchestration, familiarity with DAG-based tools (Airflow, Dagster, etc.) is a plus.

• Advanced SQL: Expert-level SQL skills with the ability to write modular, performant code. Experience with modular SQL transformation pattern is highly preferred.

• Domain Expertise: Previous experience with retail or e-commerce data models, specifically in web analytics pipelines and attribution logic.

• Cloud Mastery: Deep hands-on experience with Snowflake (including telemetry and administrative functions) and/or Google Cloud Platform (BigQuery).

• AI Literacy: Comfortable using AI assistants to optimize workflows and generate boilerplate code; ability to judge and audit AI-generated outputs for correctness.

• Communication: Ability to explain complex technical migrations to stakeholders and collaborate effectively in a "team sport" modeling environment.

URBN offers comprehensive Perks & Benefits to employees. Availability and eligibility to specific benefits may be subject to your location and employment status. Benefits include medical, dental, vision, PTO, generous employee discounts, retirement savings and much more! For additional information visit www.urbn.com/work-with-us/benefits

URBN celebrates diversity and is committed to creating an inclusive environment for all employees. We are proud to provide equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, sex (including gender, pregnancy, sexual orientation, and gender identity or expression), religion, creed, age, physical or mental disability, national origin or ancestry, ethnicity, citizenship, service in the uniformed services, genetic information, or any other protected characteristic as established by law. We believe strongly in fostering a safe, fair and respectful work environment. To ensure compliance with our non-discrimination and anti-harassment policies, we offer anti-harassment training to managers and employees.