Data Engineer II

Fanatics Collectibles; Ciudad de México; Presencial; MXN 600.000 - 1.000.000; Jornada completa

Descripción de la vacante

Fanatics Collectibles is establishing a new Mexico City technology hub focused on scalable data systems. We seek a Data Engineer II to scale our data infrastructure, support the Topps data platform, and optimize Snowflake architecture for analytics and BI.

You will build pipelines across structured and unstructured sources and collaborate with product and business teams. Responsibilities include modeling in SQL/NoSQL, data quality, and improving ETL processes using Python, dbt, and AWS tools in

Formación

• Bachelor’s degree in Computer Science, Engineering, or related field, or equivalent experience.
• 2+ years in data or backend data systems roles.
• Proficiency in Python, SQL, and dbt for data manipulation and pipelines.
• Familiarity with Shopify APIs.
• Experience with Snowflake including design and query optimization.
• Experience with AWS and tools like Lambda, S3, Glue.
• Familiarity with Spark or Airflow and modern orchestration.
• Comfortable in a fast-paced, iterative environment.

Responsabilidades

• Develop, deploy, and maintain cloud-native data pipelines and integrations.
• Build and optimize data models in relational and NoSQL databases.
• Implement data quality, observability, and reliability checks.
• Support Snowflake modeling for Topps datasets and analytics pipelines.
• Enhance Terraform projects for Snowflake RBAC.
• Collaborate with data engineers, analysts, PMs, and stakeholders to deliver data solutions.
• Participate in code reviews and adopt high engineering standards.
• Contribute to onboarding and documentation of data sources and pipelines.
• Continuously learn new technologies to improve performance and maintainability.

Conocimientos

Python

SQL

dbt

Shopify APIs

Snowflake

AWS

Spark

Airflow

NoSQL

Team collaboration

Educación

Bachelor’s degree in CS/Engineering

Herramientas

Snowflake

AWS

dbt

S3

Lambda

Descripción del empleo

Fanatics is building a leading global digital sports platform. We ignite the passions of global sports fans and maximize the presence and reach for our hundreds of sports partners globally by offering products and services across Fanatics Commerce, Fanatics Collectibles, and Fanatics Betting & Gaming, allowing sports fans to Buy, Collect, and Bet. Through the Fanatics platform, sports fans can buy licensed fan gear, jerseys, lifestyle and streetwear products, headwear, and hardgoods; collect physical and digital trading cards, sports memorabilia, and other digital assets; and bet as the company builds its Sportsbook and iGaming platform. Fanatics has an established database of over 100 million global sports fans; a global partner network with approximately 900 sports properties, including major national and international professional sports leagues, players associations, teams, colleges, college conferences and retail partners, 2,500 athletes and celebrities, and 200 exclusive athletes; and over 2,000 retail locations, including its Lids retail stores. Our more than 22,000 employees are committed to relentlessly enhancing the fan experience and delighting sports fans globally.

About Fanatics

Fanatics is building a leading global digital sports platform. We ignite the passions of global sports fans and maximize the presence and reach for our hundreds of sports partners globally by offering products and services across Fanatics Commerce, Fanatics Collectibles, and Fanatics Betting & Gaming, allowing sports fans to Buy, Collect, and Bet. Through the Fanatics platform, sports fans can buy licensed fan gear, jerseys, lifestyle and streetwear products, headwear, and hardgoods; collect physical and digital trading cards, sports memorabilia, and other digital assets; and bet as the company builds its Sportsbook and iGaming platform. Fanatics has an established database of over 100 million global sports fans; a global partner network with approximately 900 sports properties, including major national and international professional sports leagues, players associations, teams, colleges, college conferences and retail partners, 2,500 athletes and celebrities, and 200 exclusive athletes; and over 2,000 retail locations, including its Lids retail stores. Our more than 22,000 employees are committed to relentlessly enhancing the fan experience and delighting sports fans globally.

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.

Voluntary Self-Identification

For government reporting purposes, we ask candidates to respond to the below self-identification survey.Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiringprocess or thereafter. Any information that you do provide will be recorded and maintained in aconfidential file.

As set forth in Fanatics Collectibles’s Equal Employment Opportunity policy,we do not discriminate on the basis of any protected group status under any applicable law.

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection.As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measurethe effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categoriesis as follows:

A \"disabled veteran\" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A \"recently separated veteran\" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval or air service.

An \"active duty wartime or campaign badge veteran\" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An \"Armed forces service medal veteran\" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.