Data Engineer 2

About Fanatics Collectibles

Fanatics Collectibles is the home of sports cards, trading cards, and collectibles for over 100 million fans worldwide. As part of the global Fanatics platform, we're rebuilding how collectors discover, buy, sell, and experience their hobby with world class technology and product experiences.

As part of Fanatics Collectibles’ continued global growth, we are establishing a new technology hub in Mexico City focused on operational excellence, platform scalability, trust, and customer experience. This team partners closely with Customer Experience (CX), Trust & Safety, Fraud Prevention, Payments, and Financial Operations organizations to build scalable systems and operational tooling that support millions of users and transactions globally.

The Role

As a Data Engineer II, you will 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.

• 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 (Gand 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

Basic Qualifications

• Bachelor’s degree or higher 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

Code-Writing Contribution

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.

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