Facebook pixel

Data Architect
Baseball Systems
Confirmed live in the last 24 hours
Locations
Dorchester, Boston, MA, USA
Experience Level
Entry
Junior
Mid
Senior
Expert
Desired Skills
Apache Spark
AWS
Data Analysis
Data Science
Data Structures & Algorithms
Google Cloud Platform
Hadoop
C/C++/C#
Leadership
Management
Microsoft Azure
R
Redshift
Research
Ruby
Snowflake
SQL
Python
Writing
Requirements
  • 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
  • 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
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
Desired Qualifications
  • Experience with big data systems such as Spark or Hadoop is a plus
  • Experience with R and RStudio is a plus
  • An understanding of baseball is a plus
Boston Red Sox

501-1,000 employees

Professional baseball team (MLB)
Company Overview
The Boston Red Sox's mission is to make a difference in the lives of children, families, veterans, and communities in need by improving their health, education, and recreational opportunities.