Sr. Data Engineer, Baseball Systems (Boston) Job at Houston Texans, Boston, MA

blRmbnlrK2Vwb01KWmNQOTAzM3YrK1pyUFE9PQ==
  • Houston Texans
  • Boston, MA

Job Description

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

  • Bachelors 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

Job Tags

Full time, Flexible hours,

Similar Jobs

McLeod Express

CDL A Local Truck Driver - Home Daily Job at McLeod Express

 ...family-focused, family-driven company, we are committed to offering CDL-A local truck driving careers with daily home time and great pay while making safety a top priority. Step back from making a mega-carrier mistake and take a closer look at the CDL-A local truck driver... 

UF Health

Homecare Staff RN/ Gainesville/ Homecare/Days/ Full-Time Job at UF Health

Overview The Registered Professional Nurse is responsible for identifying the patient's alterations in health, assessing the patient's human response to actual and potential health problems, implementing nursing interventions based on theoretical concepts from nursing...

Tryfacta, Inc.

Clinical Specialist Job at Tryfacta, Inc.

 ...Solicitation #: 46893 Location: California preferred ~ Key Requirements: ~210 years of experience with EHR (Electronic Health Record) systems, specifically Epic Orders/Inpatient modules ~ Epic Orders certification (required)~ Tier 2 build support for physicians... 

Nordstrom

Barista - Specialty Coffee - Ross Park Job at Nordstrom

 ...The ideal barista is motivated, outgoing and committed to providing outstanding customer service every day. A day in the life Prepare and serve beverages and food items consistently by adhering to all recipe standards, while also delivering exceptional customer... 

Copilot Careers

Child Transport Driver - Set Your Hours - Local Routes Job at Copilot Careers

 ...years with children Must be at least 23 years old Valid drivers license with three or more years of driving experience...  ...Support families and kids in your area Position Type: Independent Contractor Earnings: Up to $50 per ride. Terms apply* Terms:...