Data Engineer II

Fanatics Collectibles is transforming the trading card industry through innovative technology, data, and fan-first thinking. As a leading licensee and producer of physical and digital trading cards, we’ve partnered exclusively with the MLB, NFL, and NBA. Backed by Fanatics’ global digital sports platform and 90M+ fans, we’re building a marketplace, live streaming platform, and secure vaulting solution to reimagine the collector experience.

We’re seeking a Data Engineer II (TP2) to help scale and evolve our data infrastructure as we build greenfield systems and develop a modern, cloud-native data stack. This FTE role will be primarily dedicated to supporting the Topps data engineering platform. You will also contribute to Snowflake architecture, modeling, and optimization, ensuring strong foundations for analytics, business intelligence, and operational data products.

This role is ideal for an engineer with 2+ years of experience who thrives in a collaborative, agile environment and is excited by the opportunity to directly impact the collectibles industry.

• Develop, deploy, and maintain components of cloud-native data pipelines, integrating a variety of structured and unstructured data sources
• Build and optimize data models in relational and NoSQL databases to support scalable data access patterns
• Implement and monitor data quality, observability, and reliability checks using modern best practices
• Support and enhance Snowflake data modeling for Topps-related datasets and analytics pipelines via Shopify APIs
• Support and enhance Terraform project for Snowflake RBAC
• Collaborate closely with data engineers, analysts, product managers, and business stakeholders to understand data needs and deliver usable solutions
• Participate in code reviews (GitHub) and adopt engineering standards aligned to a high-performing data engineering culture
• Contribute to onboarding and documentation of data sources, transformations, and pipelines
• Continuously learn and adapt new technologies to improve system performance and maintainability

• Bachelor’s degree in Computer Science, Engineering, or a related field, or equivalent practical experience
• 2+ years of experience in data engineering or software engineering roles with a focus on backend data systems
• Proficiency in Python, SQL, and dbt for data manipulation and pipeline development
• Familiarity with Shopify APIs
• Experience with Snowflake including performance tuning, schema design, and query optimization
• Experience with cloud platforms (AWS preferred), and tools like Lambda, S3, Glue, or similar
• Familiarity with distributed data processing tools (e.g., Spark, Airflow) and modern orchestration
• Working knowledge of both SQL and NoSQL databases and data modeling techniques
• Comfortable working in a fast-paced environment with iterative product development

This is a hands-on engineering role. A successful TP2 Data Engineer will be expected to regularly write clean, maintainable code to support ingestion pipelines, transformation logic, and data validation. Contributions are typically reviewed by senior engineers and integrated into production workflows.

• You’re energized by solving problems with data and improving access, quality, and usability
• You care about craftsmanship and continuously look for ways to improve how data flows across systems
• You’re a sports or collectibles fan and love thinking about how data can enhance the fan experience
• You’re eager to grow your technical skills and learn from a collaborative and talented team

In NYC, the salary range for this position is $135,000 - $168,000, which represents base pay only and does not include short-term or long-term incentive compensation. In Los Angeles, the salary range for this position is $122,000 - $152,000. The listed salary ranges are specific to Los Angeles or NYC and may not be applicable to other locations. When determining base pay, as part of a final compensation package, we consider several factors such as location, experience, qualifications, and training.

Ensure your Fanatics job offer is legitimate and don’t fall victim to fraud. Fanatics never seeks payment from job applicants. Feel free to ask your recruiter for a phone call or other type of communication for interview, and ensure your communication is coming from a Fanatics email address (including @collectfanatics.com). For added security, where possible, apply through our company website at www.fanaticsinc.com/careers