SQL Developer , Baseball Operations

  MLB Franchise
  Northeast Region
  Sports Technology
  Posted/Updated: 11/29/18



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


How to Apply for Position:

Upgrade your account to paid subscription and gain access to this job as well as all other sports job opportunities:

Make Your Career Move Today!

Subscribe today and gain access to 53,260 jobs in the sports industry and Break Through!

Payment Details

Transaction Processing
*By joining JobsInSports.com, you agree to the Terms of Agreement and to receive important email communications. To ensure uninterrupted service, your membership will be autorenewed at the regular price at the time you joined. You may cancel at any time. Simply refer to our Cancellation Policy.

Similar Jobs

Part-time Video Operator
  Sports Network
  Northeast Region
  Sports Technology
  Posted/Updated: 01/16/19
Technical Support Representative
  Sports Technology Company
  Northeast Region
  Sports Technology
  Posted/Updated: 01/02/19
Creative Content Producer
  Univeristy (NY)
  Northeast Region
  Sports Technology
  Posted/Updated: 01/02/19
Customer Success Representative
  Sports Technology Company
  Northeast Region
  Sports Technology
  Posted/Updated: 12/27/18
Field Marketing Sports Representative
  Sports Technology Company
  Northeast Region
  Sports Technology
  Posted/Updated: 12/11/18

Explore the Job Market in Sports

One place with all the tools, statistics, and job information you need. Know your options.

Ready to Get Started?

Get access to the most up-to-date live sports jobs now!