Data Architect I

Job Purpose

The Data Architect I, as part of the Baseball Information Systems team, is responsible for the development and maintenance of baseball-related databases and data architecture. The Data Architect I will work with the team to evaluate and improve our data systems, ETL processes, and integrations with internal and external data sources. The successful candidate will also help identify changing data needs and develop related solutions.

Duties and Responsibilities:

• Assist in designing and evolving data architecture across databases, data warehouses, data lakes/lakehouses, and related data systems
• Design, develop, and maintain ETL/ELT processes that integrate data from internal systems and external vendors
• Research and evaluate emerging data technologies and platforms, including cloud data platforms and technologies such as Databricks, Microsoft Azure, and Google Cloud, and assist in determining where they may provide value
• Work with baseball-related departments to understand data needs and develop solutions that support scouting, player development, baseball administration, and research
• Evaluate existing databases, data processes, and vendor integrations to identify opportunities for improvement, modernization, and automation
• Import and integrate data from disparate external sources and automate processes for repeatability and reliability
• Optimize centralized MS SQL databases and data processes for efficient retrieval and processing of large datasets
• Monitor databases and data processes and help identify and resolve issues affecting data quality, reliability, or performance
• Follow data security, development, and architectural standards
• Additional duties as assigned

Qualifications

• Bachelor’s degree in computer science or equivalent field
• Knowledge and interest in the latest technologies with the ability to learn new technologies quickly
• Good communication skills – both written and verbal
• Ability to work independently or collaboratively and multi-task efficiently
• Strong SQL and database programming skills
• Experience working with Microsoft SQL Server RDBMS
• Experience with ETL processes, data integration, or cloud data platforms preferred
• Experience with Python or another programming language preferred
• Baseball knowledge and experience is preferred