In order to be considered for this role, after clicking "Apply Now" above and being redirected, you must fully complete the application process on the follow-up screen. DEPARTMENT OVERVIEW: Members of the Baseball Systems team at the Boston Red Sox focus on designing, building, and refining software and data pipelines used within Baseball Operations. These tools are integral to decision-making, directly integrated into workflows across all departments, and provide efficient access to internal data sources and applications. POSITION OVERVIEW: The Boston Red Sox seek a hands-on Senior Data Engineer, Baseball Systems, responsible for administering and optimizing large-scale SQL environments, building data pipelines, and ensuring high-performance access to baseball operations data across on-prem and cloud platforms. The ideal candidate thrives in a fast-paced environment, manages Snowflake-based pipelines and legacy SQL Server systems, and delivers scalable, efficient data solutions impacting decision-making in Baseball Operations. This role supports analysts, developers, and engineers in player evaluation, baseball sciences, and scouting. RESPONSIBILITIES Administer and optimize Snowflake and SQL Server environments, including sizing, query tuning, and access control Develop data transformation pipelines from APIs and file sources Leverage tools like dbt, Snowpipe, and Snowpark for data transformations Design, manage, and monitor data pipelines from Azure Blob Storage to Snowflake, ensuring reliability and performance Maintain and modernize legacy SQL Server pipelines, improving performance through optimization and tuning Contribute to infrastructure design, testing, implementation, and quality assurance Support critical production systems, resolving pipeline or performance issues promptly Collaborate with stakeholders to support analytical, operational, and reporting needs Participate in code reviews, architecture discussions, and DevOps practices COMPETENCIES Strong understanding of databases, SQL, query optimization, stored procedures, and views Ability to design cost-effective, scalable, and flexible data solutions Creative and critical thinking to solve problems Basic knowledge of baseball or sports analysis is a plus Effective collaboration with technical and non-technical teams ADDITIONAL QUALIFICATIONS Bachelor’s degree in a related field 3-5 years in a data engineering role focusing on database performance and pipelines Experience with SQL Server and Snowflake administration and development Proficiency with Azure Blob Storage, dbt, Snowpipe, and ELT/ETL concepts Familiarity with GraphQL is a plus Ability to work independently and in teams, with strong attention to detail Comfort with remote work and communication tools Professionalism and confidentiality Excellent organizational and time management skills All roles in Baseball Operations also require demonstrating problem solving, teamwork, communication, and time management skills, embodying our values of honesty, humility, relentlessness, and commitment to DEIB.

#J-18808-Ljbffr