Senior Data Engineer
About The Position
We are seeking an experienced and driven Senior Data Engineer – Enterprise Data Products within the Global Data & Analytics team. You are passionate about building scalable, reliable, and AI-ready data platforms that power enterprise decision-making and advanced analytics. You understand that modern data platforms must not only support reporting, but also enable machine learning, generative AI, and intelligent applications through high-quality, well-governed, and semantically consistent data. In this role, you will lead teams of data engineers responsible for building and operating domain-specific data products, semantic layers, and data marts that serve as trusted, AI-ready sources of truth across the organization, with a strong emphasis on ecommerce data products and Shopify data pipelines. You will play a key role in shaping how data is structured, governed, and exposed to support AI/ML use cases, feature engineering, and semantic consistency across tools and applications.
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 is strongly preferred, including Shopify orders/customers/products/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, etc.).
- 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 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.
Nice To Haves
- Preferred: experience handling Shopify data and ecommerce datasets, including ingesting, modeling, validating, and reconciling commerce data across platforms.
- Preferred candidate location: Philadelphia, PA (Philly).
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.
Benefits
- Comprehensive medical, dental, and vision coverage
- 100% 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 so much more (up to $720/year)
- Student Loan Repayment Assistance and Tuition Reimbursement
- 401(k) with 100% immediate vesting on the first 5% of your contributions, plus an 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 Wellbeing Day)
- Summer Fridays (between Memorial Day and Labor Day)
- Generous paid parental leave for every type of parent
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
Education Level
No Education Listed
