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.
