Senior Data Engineer

600 UMG Recordings Inc; Philadelphia (Philadelphia County); On-site; USD 68,100 - 153,000; Full time

Benefits offered by this job

Medical coverage

401(k) plan

PTO and holidays

Job summary

Universal Music Group in Philadelphia is seeking a data engineer to design and maintain scalable data pipelines and semantic layers for analytics and AI/ML use cases. You will focus on ecommerce data products and Shopify data such as orders, customers, products, and fulfillment, while contributing to data quality and reliability.

You will work with data scientists and analysts on feature engineering, model training data, and experimentation needs, and help optimize performance with cloud

Qualifications

• 5–8 years of data engineering or related roles.
• Experience building data pipelines, data models, and data platforms.
• Familiarity with Shopify data and ecommerce analytics.

Responsibilities

• Design and build scalable data pipelines and data products for analytics and AI/ML use cases.
• Develop and maintain AI-ready datasets with high quality and usability.
• Collaborate with product, analytics, and governance teams to ensure data is documented and trusted.

Skills

SQL

Python

dbt

LookML

Cloud platforms

Snowflake

Spark

Data warehousing

Cross-functional

Education

Bachelor's degree in CS or related field

Tools

BigQuery

Parquet

Job description

Responsibilities

• Design and build scalable data pipelines and data products that support analytics and AI/ML use cases.
• Build and scale ecommerce data products and pipelines, with particular focus on Shopify data such as orders, customers, products, transactions, fulfillment, and marketing events.
• Develop and maintain AI‑ready datasets, ensuring high quality, consistency, and usability for downstream applications.
• Work with data scientists and analysts to support feature engineering, model training data, and experimentation needs.
• Contribute to building and maintaining semantic layers that standardize business definitions and enable consistent reporting and analysis.
• Implement data validation, testing, and monitoring to ensure data quality and reliability.
• Build and optimize data models (dimensional, curated layers) aligned with business requirements.
• Optimize data storage and query performance by leveraging columnar data structures and databases where applicable.
• Support batch and real‑time data pipelines using modern data stack tools.
• Follow best practices for code quality, version control, and CI/CD in data engineering workflows.
• Collaborate with product, analytics, and governance teams to ensure data is well‑documented, discoverable, and trusted.
• Troubleshoot and resolve data issues, ensuring minimal disruption to downstream users.

Qualifications

• 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.
• Proven experience handling ecommerce data at scale, including orders, carts, customers, product catalog, inventory, fulfillment, payments, refunds/returns, promotions/discounts, subscriptions, web/app clickstream, and marketing attribution.
• Familiarity with AI/ML data requirements, including preparing datasets for model training and analytics.
• Hands‑on experience working with or contributing to semantic layers (e.g., dbt, LookML).
• Solid understanding of data warehousing, dimensional modeling, and modern data architectures.
• Experience with cloud platforms (AWS, Azure, or GCP) and tools like Spark, Snowflake, Databricks, or similar.
• Strong SQL skills and proficiency in Python or a similar language.
• Experience working with columnar databases or columnar storage formats (e.g., BigQuery, Redshift, Snowflake, Parquet) and optimizing query performance.
• Experience implementing data quality checks and monitoring.
• Ability to work cross‑functionally and translate requirements into technical solutions.

Preferred Location

Philadelphia, PA (Philly).

Salary Range

$68,100 - $153,000

Benefits

• Comprehensive medical, dental, and vision coverage.
• 100% coverage for outpatient in‑network mental health services.
• Fertility coverage for eligible medical plan participants.
• Well‑being reimbursements for fitness classes, spa treatments, meals, travel, and more (up to $720/year).
• Student loan repayment assistance and tuition reimbursement.
• 401(k) with 100% immediate vesting on the first 5% of contributions plus additional UMG contribution.
• Flexible paid time off (PTO) for exempt employees.
• 3‑weeks PTO for non‑exempt employees.
• 2‑weeks paid winter break.
• 10 company holidays (including Juneteenth and Well‑being Day).
• Summer Fridays (between Memorial Day and Labor Day).
• Generous paid parental leave for every type of parent.

Equal Opportunity Employer

Universal Music Group is an Equal Opportunity Employer.We are an E‑Verify employer in Alabama, Arizona, Georgia, Mississippi, North Carolina, South Carolina, Tennessee, and Utah.Please note, UMG is not enrolled in E‑Verify in California and New York, and cannot support employment of candidates whose employer must enroll in E‑Verify, for example candidates on STEM‑OPT.

Job Category

Data, Analytics & Business Intelligence