SQL Developer - Baseball Operations
New York YankeesBronx, NY
Full Time Job
The New York Yankees organization is accepting applications for an experienced SQL developer in our Baseball Operations department. This position reports to our senior Baseball Operations executives and will assist in the development of database systems. Our goal is to integrate these systems with existing baseball analytics tools and web-applications as part of our player information and evaluation platform.
• Analyze business requirements and design reports using stored procedures to support our front office baseball applications
• Perform data integrity checks between systems to identify discrepancies
• Set up ETL operations to import and normalize data from different data providers
• Performance tuning of SQL objects and queries
• Work with major and minor league pitch, hit and player tracking datasets, college and other amateur data, international baseball data, and many other baseball data sources
QUALIFICATIONS AND EXPERIENCE:
• Must have 3-5 years experience developing in T-SQL
• Proven experience developing stored procedures, CRUD operations and advanced data manipulation skills with T-SQL (CTEs, pivots, temp tables, XML)
• Ability to design and layout a database schema from scratch, including table objects, constraints, indexes, foreign keys, and triggers
• Experience in ETL operations, specifically loading data via different techniques, including bulk loading using BCP operations
• Experience performance tuning of queries and database objects, including things like table partitioning, index tuning, query hints, locking, schema normalization
• Ability to utilize SQL Profiler and a thorough understanding of execution plans
• Excellent communication and problem-solving skills – must be able to breakdown a complex task and put together an execution strategy with little guidance
• Proven understanding of typical baseball data structures, basic and advanced baseball metrics, and knowledge of current baseball research areas
• How did you hear about this job?
• Do you have 3 years experience writing in T-SQL?
• Describe techniques you have used for performing data loading operations.
• How you would approach the identification of a performance issue in a SQL query?
• Have you ever worked with any baseball datasets before? If so, please describe which ones and how you used them.