Data Engineer II

About Us 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. 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 By submitting your application, you agree to our terms of service and acknowledge you have read our Candidate Privacy Policy. Fanatics will never ask candidates for money, banking information, or other sensitive personal information as part of the interview process. If you receive a suspicious message claiming to be from Fanatics recruiting, please do not respond and report it here .