Senior Data Engineer, Baseball Systems - Remote

Overview

The Boston Red Sox are seeking a Senior Data Engineer for the Baseball Systems team, responsible for optimizing SQL environments and building data pipelines that support Baseball Operations.

In Short

• Administer and optimize Snowflake and SQL Server environments.
• Develop robust data transformation pipelines.
• Leverage tools like dbt and Snowpipe for data transformations.
• Design and monitor data pipelines from Azure Blob Storage to Snowflake.
• Maintain and modernize legacy SQL Server data pipelines.
• Provide proactive support for critical production systems.
• Collaborate with software developers and analysts.
• Participate in code reviews and architecture discussions.
• Work in a fast-paced environment.
• Comfortable working remotely and using communication tools.

Requirements

• Bachelor’s degree in a technical field.
• 3-5 years of experience in data engineering.
• Strong SQL development and optimization skills.
• Hands-on experience with Snowflake.
• Proficiency in building data pipelines from Azure to Snowflake.
• Solid understanding of ELT/ETL concepts.
• Familiarity with DBT for data transformation preferred.
• Ability to work autonomously and in teams.
• High attention to detail and time management skills.
• Professionalism and ability to maintain confidentiality.

Benefits

• Opportunity to work with a professional sports team.
• Engagement with cutting-edge data technology.
• Collaborative work environment.
• Flexibility to work remotely.
• Focus on personal and professional development.