The Data Architect, Baseball Systems position will be a member of the baseball operations software development team, and is responsible for the design, implementation, and deployment of the information architecture of all baseball systems. This position must be comfortable with on-premises and cloud solutions, and take the initiative to explore new optimizations and cutting-edge data technologies and isexpectedto research industry trends to stay current on new tools and technology, and will work closely with our data engineers, analysts, developers, and other members of baseball operations.

RESPONSIBILITIES:

• Through research, design, and architectural efforts, and in collaboration with software developmentresources,ensurewe have access to world-class data for analytical and system purposes.
• Develop a thorough understanding of the all areas within Baseball Operations to help design effective and highly integrated solutions
• Ensure processes and systems are in place to support the integrity, accuracy, consistency, and availability of all content
• Create and manage ETL (extract, transform, load) data integration processes
• In collaboration with the analytics and software development teams, design and implement baseball algorithms and functionality
• Partner with data providers to understand current and future data roadmaps, identify limitations, and develop along-term data content plan in collaboration with baseball leadership
• Respond to and resolve data-related problems and issues in a timely manner.
• Completead-hoc database queries and analysisas directed
• Effectively communicate statuses to the Director, aswell as other leadership as requested throughout all projects

KNOWLEDGE & EXPERIENCE:

• Bachelor’s degree in computer science, computer engineering, data engineering, or equivalent professional experience; Master’s degree a plus
• 6+ years of related work experience, including demonstrated knowledge about data management best practices and ability to effectively solve problems pertaining to data infrastructure and integrity
• Proven track record of collecting and understanding complex requirements and delivering creative and effective solutions
• Expertise in relational databases, database design, architecture, and development
• Expertise designing and building data models for Snowflake and ingesting data into Snowflake using various pipelines
• Expertise in writing and optimizing SQL queries in SQL Server or other database technologies
• Experience with Azure, AWS, and/or GCP cloud technologies, such as Cloud SQL, RDS, Redshift, Azure SQL, and others, and working with hybrid on-premises technologies
• Experience building solutions using Python, C#, C++, Ruby, or other languages
• Experience with scheduling and workflow management platforms, such as Airflow
• Experience with big data systems such as Spark or Hadoop is a plus
• Experience with R and RStudio is a plus

PERSONAL ATTRIBUTES:

• Ability to work autonomously and as a team in a fast-paced environment
• High level of attention to detail with the ability to multi-task effectively
• Comfortable working remotely using Zoom, Teams, Slack, Trello, and other tools to communicate with all team members
• High degree of professionalism and ability to maintain confidential information
• Excellent organizational and time management skills
• An understanding of baseball is a plus

The Red Sox (or FSM) requires proof of being up-to-date on COVID-19 vaccination as a condition of employment, subject to applicable legal requirements.  Up-to-date means having received all recommended COVID-19 vaccination doses in the primary series and a booster dose(s) when eligible, per CDC guidelines.  

 

Prospective employees will receive consideration without discrimination based on race, religious creed, color, sex, age, national origin, handicap, disability, military/veteran status, ancestry, sexual orientation, gender identity/expression or protected genetic information.