Data Engineer II — Growth Path, Mentorship & Impact

Fanatics; New York (NY); On-site; USD 118,000 - 156,000; Full time

Job summary

Fanatics is seeking a Data Engineer II to join the Data Engineering team in New York. You will help build data pipelines using Python, Airflow, and Snowflake/Databricks, ensuring secure, decision-ready data delivery.

This entry-level role emphasizes learning from senior engineers, writing reliable code, and growing into independent ownership. You’ll work on ingestion pipelines, data governance, reverse ETL, and collaboration with BI analysts and data scientists to meet business needs.

Qualifications

• 1-3 years of professional software or data engineering experience.
• A self-learner with a strong ability to gather, evaluate, and analyze requirements.
• Solid foundation in Python and deep understanding of SQL and ETL/ELT for complex data transformations.
• Comfort reading and writing unit tests, and working within an established codebase and conventions.
• Familiarity with workflow orchestration tools like Airflow (Managed Workflows for Apache Airflow).
• Knowledge of several of the following technologies: Snowflake, Databricks, AWS, dbt, Tableau, MongoDB, PostgreSQL.
• Git-based version control and PR-based code review workflows.
• Strong communication skills — asks clarifying questions, writes clear PR descriptions, and escalates blockers with useful context rather than staying stuck silently.
• A growth mindset: takes review feedback well, improves processes, and champions best practices to avoid technical debt.

Responsibilities

• Implement ingestion pipelines and Airflow DAGs from a senior engineer's design, using the team's scaffolding and conventions — including writing the code, unit tests, and documentation.
• Support data security and governance work, such as PII masking and access controls, following established patterns.
• Contribute to data delivery work, including reverse ETL integrations, under guidance from senior engineers.
• Add and extend fields in existing pipelines, incorporating review feedback and applying learned patterns on future work.
• Take oncall pages for pipeline failures, work through runbooks, and elevate with clear context when needed.
• Pair with senior engineers on data integrity issues you can't yet diagnose alone.
• Write clear, reviewer-friendly PR descriptions and ask clarifying questions before starting new work.
• Flag blockers early and with context rather than going quiet when stuck.
• Build strong working relationships with internal stakeholders (BI analysts, other data engineers, data scientists) and help gather and clarify requirements.
• Conduct and participate in code and system inspections.
• Help the team define and adhere to data engineering best practices.
• Mentor more junior data engineers as you grow into the role.

Skills

Python

SQL

ETL/ELT

Airflow

Git

Unit tests

Communication

Tools

Snowflake

Databricks

AWS

dbt

Tableau

MongoDB

PostgreSQL

Job description

Fanatics is seeking a Data Engineer II to join the Data Engineering team in New York. You will help build data pipelines using Python, Airflow, and Snowflake/Databricks, ensuring secure, decision-ready data delivery.

This entry-level role emphasizes learning from senior engineers, writing reliable code, and growing into independent ownership. You’ll work on ingestion pipelines, data governance, reverse ETL, and collaboration with BI analysts and data scientists to meet business needs.