Job Posting: Yankees Database Developer

SQL Server Database Developer, Baseball Operations – New York Yankees (Bronx, NY)

Description:

The New York Yankees organization is accepting applications for an experienced SQL developer in their Baseball Operations department. This position reports to the senior Baseball Operations staff and will assist in the development of database systems which integrate 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 duplicate records, incorrect imports or data mapping issues
• Setting up ETL operations to import and normalize data from different data providers
• Performance tuning of SQL objects and queries
• Working 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
• Deep 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, triggers, etc.
• 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, etc. Ability to utilize SQL Profiler and a thorough understanding of execution plans is a must
• Excellent communication and problem solving skills – must be able to breakdown a complex task and put together an execution strategy with little guidance
• An understanding of typical baseball data structures, basic and advanced baseball metrics, and knowledge of current baseball research areas
• Basic knowledge of Microsoft SQL Server Database administration tasks including backups, maintenance plans, replication, security.
• Experience developing CLR user-defined functions and aggregates
• .NET development experience in C#, primarily as it relates to the data access layer, including things like nHibernate, Microsoft.Practices and/or other ORM tools
• Experience with SSIS and PowerShell
• Unit testing in SQL
• MCSA/MCSE Certification preferred, but not required

This description is intended to describe the type of work being performed by a person assigned to this position. It is not an exhaustive list of all duties and responsibilities required by the employee. The New York Yankees is an Equal Opportunity Employer. The company is committed to the principles of equal employment opportunity for all employees and applicants for employment.

Note: When you apply for this job online, you will be required to answer the following questions:

1. Do you have 3+ years experience writing in T-SQL? YES/NO
2. If Yes, describe when you would use a CTE vs. a temp table in your work?
3. Have you used SQL Profiler or execution plans to analyze performance bottlenecks in your code? YES/NO
4. If Yes, describe briefly how you would approach the identification of a performance issue in a SQL query.
5. Have you ever used the bcp utility to bulk import data into a SQL database? YES/NO

Apply Here




Print This Post



David Appelman is the creator of FanGraphs.


19 Responses to “Job Posting: Yankees Database Developer”

You can follow any responses to this entry through the RSS 2.0 feed.
  1. tz says:

    Can Red Sox fans apply?

    +10 Vote -1 Vote +1

  2. mgoetze says:

    As yes, the Yankees and Microsoft. Evil empires gotta stick together.

    Vote -1 Vote +1

    • HUH? says:

      How is Microsoft the Evil Empire? Apple is – that’s why it has all the money.

      Vote -1 Vote +1

      • mgoetze says:

        How old are you dude, 16? Also, Apple might have even more but $75 billion cash reserves is nothing to sneeze at.

        Vote -1 Vote +1

        • I am not 16 says:

          I’m just annoyed at the perception that Microsoft is the Evil Empire of Technology. Apple is bigger and has been for some time. Additionally it engineers worse products and sells them for more. Though it does have far better designers.

          Vote -1 Vote +1

        • Gribo says:

          Get in touch with reality dude. Nobody squeezes the common man like Apple. Microsoft overcharges big business primarily for enterprise level software, Windows isn’t expensive by any definition, while Mac takes the peasants money through slick advertising. But hey, keep taking pride in being overcharged for what can be had for free. It is a status symbol after all. Viva La Mac!

          +8 Vote -1 Vote +1

        • Nostress says:

          hahahaha nice definition of ‘evil empire’

          Vote -1 Vote +1

    • ALZ says:

      Fangraphs uses ASP.NET, so there is some Microsoft here.

      Vote -1 Vote +1

  3. Uninterested Cat says:

    Is this for real? I’d be a great fir. Granted, I’m not the most qualified. However, I hate the Yankees, so it works out nicely.

    Vote -1 Vote +1

  4. MikePhoenix says:

    Don’t know where else to post this: On the Fangraphs Iphone App, everything works fine. But when you look up the stats for a minor leaguer it has two lines for 2014. The bottom one is their actual stats this year, the top one is just gibberish. For example, AJ Cole has a line that reads: 2014 WSH (AA) w 13, L14, ERA 4.47, G32, GS 32, Sv O, IP 200, etc. You can’t find this line on the website version of Fangraphs at all (not actual stats, not projected stats). Anyway-just something odd on the app. Figured Appelman would be el App Man to at least call the design company and figure out what is going on. (Note: not a problem for major leaguers)

    Vote -1 Vote +1

  5. Eric R says:

    Unsure the point of those couple of questions… it’d take maybe a minute or two to Google the questions and get what is considered the right answer. So what’s the point if it doesn’t really screen out any non-qualified applicants…

    Vote -1 Vote +1

    • Interviewer says:

      I hire people for technical jobs. Very often I give them basic questions a few days prior to the interview. Part of it is to see if they can handle a simple research assignment (you’d be surprised), but usually I’ll ask more in-depth and complicated questions based on their answers. You can probe for their strengths and weaknesses in different technical areas based on which direction they go with an answer to a basic question.

      Vote -1 Vote +1

  6. Brian says:

    “It is not an exhaustive list of all duties and responsibilities required by the employee.”

    I’m assuming gift basket assembly is part of the job.

    Vote -1 Vote +1

  7. ChadT says:

    Downside: you report to the Assistant to the Traveling Secretary.

    Vote -1 Vote +1

    • Peter 2 says:

      Now that you mention it, Assistant to the Traveling Secretary of the New York Yankees must actually be my absolute dream job, given my love of baseball and shows about nothing

      Vote -1 Vote +1

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Current ye@r *