Sr. Data Engineer, Baseball Systems

DEPARTMENT OVERVIEW :

Members of the Baseball Systems team at the Boston Red Sox are focused on designing, building, and refining the software and data pipelines used within Baseball Operations. These tools and applications are an integral part of the decision-making process, are directly integrated in the workflows of all departments within Baseball Operations, and provide an efficient, consistent, and accessible experience when interacting with our internal data sources and applications.

POSITION OVERVIEW :

The Boston Red Sox are seeking a Senior Data Engineer, Baseball Systems who is a hands-on database expert responsible for administering and optimizing large-scale SQL environments, building robust data pipelines, and ensuring high-performance access to critical baseball operations data across on-prem and cloud platforms.

The ideal candidate thrives in a fast-paced environment, is comfortable managing both modern Snowflake-based pipelines and legacy SQL Server systems, and brings a strong sense of ownership to delivering scalable, efficient, and maintainable data solutions that directly impact decision-making throughout Baseball Operations. This role is central to the reliability and evolution of the Red Sox’s data infrastructure, supporting analysts, developers, and systems engineers across player evaluation, baseball sciences, and scouting domains.

RESPONSIBILITIES

• Administer and optimize Snowflake and SQL Server environments, including warehouse sizing, query tuning, and access control policies
• Develop robust data transformation pipelines, leveraging data from both APIs and file-based sources
• Leverage tools like dbt, Snowpipe, and Snowpark for data transformations
• Design, manage, and monitor data pipelines that move structured and unstructured data from Azure Blob Storage into Snowflake, ensuring reliability, performance, and cost-efficiency
• Maintain and modernize legacy SQL Server data pipelines, improving performance through query optimization, indexing strategies, and resource tuning
• Contribute to the infrastructure design and software lifecycle phases—including technical design, testing, implementation, and quality assurance
• Provide proactive support for critical production systems, resolving pipeline or performance issues quickly and effectively
• Partner with software developers, analysts, and other stakeholders to support analytical, operational, and reporting needs across Baseball Operations
• Participate in code reviews, architecture discussions, and DevOps best practices with the data engineering and software development teams

COMPETENCIES

ADDITIONAL QUALIFICATIONS

In addition to the above requirements, all roles within Baseball Operations are expected to effectively demonstrate our universal competencies related to problem solving, teamwork, clarity of communication, and time management, along with embodying our culture of honesty, humility, relentlessness, and commitment to DEIB.