SQL Developer , Baseball Operations

This position has been filled - Job#: 453373860

Job Summary

POSITION OVERVIEW:
The MLB Team 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.

PRIMARY RESPONSIBILITIES:

- 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