Senior Data Engineer
Universal Music Group3 months ago
Philadelphia, PA, USASenior
Base Salary
$68k - $179k/yr
Responsibilities
- Design and build scalable data pipelines and enterprise data products for analytics and AI/ML use cases.
- Build and scale ecommerce data products and Shopify pipelines covering orders, customers, products, transactions, fulfillment, and marketing events.
- Develop and maintain high-quality, consistent, AI-ready datasets for downstream applications.
- Support data scientists and analysts with feature engineering, model-training data, and experimentation needs.
- Build and maintain semantic layers that standardize business definitions and enable consistent reporting.
- Implement data validation, testing, monitoring, and troubleshooting processes to maintain data quality and reliability.
- Build and optimize dimensional data models and curated data layers aligned with business requirements.
- Optimize data storage and query performance using columnar data structures and databases.
- Support batch and real-time data pipelines using modern data-stack tools.
- Collaborate with product, analytics, and governance teams to ensure data is documented, discoverable, and trusted.
- Lead teams of data engineers responsible for domain-specific data products.
Requirements
- 5–8 years of experience in data engineering or related roles.
- Strong experience building data pipelines, data models, and data platforms.
- Experience working with Shopify data, including orders, customers, products, and fulfillment schemas, is strongly preferred.
- Proven experience handling ecommerce data at scale, including catalog, inventory, payments, refunds and returns, promotions, subscriptions, clickstream, and marketing attribution data.
- Familiarity with AI/ML data requirements and preparing datasets for model training and analytics.
- Hands-on experience with semantic layers such as dbt or LookML.
- Solid understanding of data warehousing, dimensional modeling, and modern data architectures.
- Experience with AWS, Azure, or GCP and tools such as Spark, Snowflake, or Databricks.
- Strong SQL skills and proficiency in Python or a similar language.
- Experience with columnar databases or storage formats such as BigQuery, Redshift, Snowflake, or Parquet, including query-performance optimization.
- Experience implementing data quality checks and monitoring.
- Ability to work cross-functionally and translate requirements into technical solutions.
Benefits
- Comprehensive medical, dental, and vision coverage, including full coverage for out-patient in-network mental health services.
- Fertility coverage for eligible medical plan participants.
- Wellbeing reimbursements for fitness classes, spa treatments, meal services, travel, and other expenses up to $720 per year.
- Student loan repayment assistance and tuition reimbursement.
- 401(k) with immediate vesting on the first 5% of employee contributions plus an additional UMG contribution.
- Flexible PTO for exempt employees and three weeks of PTO for non-exempt employees.
- Two-week paid winter break, 10 company holidays, summer Fridays, and generous paid parental leave.
- Preferred candidate location is Philadelphia, Pennsylvania.
Tech Stack
Amazon RedshiftApache SparkAWSAzureDatabricksdbtGoogle BigQueryGoogle Cloud PlatformPythonSnowflakeSQL
Categories
Data Engineering
About Universal Music Group
Universal Music Group is a public music-entertainment company that produces, distributes, and licenses recorded music; operates music publishing; and runs artist merchandising and audiovisual content businesses. It owns labels such as Interscope, Republic, Def Jam, Capitol, and Deutsche Grammophon, and works across more than 60 countries. Headquartered in Santa Monica, California, it is listed on Euronext Amsterdam and generates revenue from streaming and physical sales, licensing, publishing royalties, and merchandise.