Offshore Rotation Jobs in Pennsylvania (NOW HIRING)

Job Summary:
URBN is a company that encompasses Urban Outfitters, Anthropologie Group, Free People, and Nuuly, seeking a Senior Data Engineer to join their Enterprise Data Warehouse team. The role focuses on modernizing data pipelines and collaborating with a team to enhance their data ecosystem for retail analytics.
Responsibilities:
• 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.
Qualifications:
Required:
• 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.
Preferred:
• Familiarity with DAG-based tools (Airflow, Dagster, etc.).
• Experience with modular SQL transformation pattern.
Company:
URBN Urban Outfitters, Inc. Founded in 1970, the company is headquartered in Philadelphia, USA, with a team of 10001+ employees. The company is currently Late Stage.