SQL Developer , Baseball Operations

This position has been filled - Job#: 453373860

  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 48,206 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

Application Developer
  Northeastern Hockey Franchise
  Northeast Region
  Sports Technology
  Posted/Updated: 03/13/19
Cloud Infrastructure Engineer
  Northeastern Hockey Franchise
  Northeast Region
  Sports Technology
  Posted/Updated: 03/04/19
Technical Project Manager
  Sports Media Company
  Northeast Region
  Sports Technology
  Posted/Updated: 02/25/19
Part-time Video Operator
  Sports Network
  Northeast Region
  Sports Technology
  Posted/Updated: 02/11/19
IT Assistant
  Sports Arena
  Northeast Region
  Sports Technology
  Posted/Updated: 02/08/19

Everything You Need to Land Your Dream Sports Job

Jobs In Sports offers all of the tools, statistics, and job information you need to start a career in sports.

Ready to Get Started?

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