Please note, this posting contains multiple positions.
Position: SQL Developer
Position Overview:
The New York Yankees organization is accepting applications for an experienced SQL developer in their Baseball Operations department. This position reports to their senior Baseball Operations executives and will assist in the development of database systems. Their goal is to integrate these systems with existing baseball analytics tools and web-applications as part of their player information and evaluation platform.
Primary Responsibilities:
- Analyze business requirements and design reports using stored procedures to support Yankees 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
Job Questions:
- 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.
To Apply:
To apply, please complete the following application.
Position: Web Application Developer
Primary Responsibilities:
- Assist in the design and implementation of web-based tools and applications for senior baseball operations personnel
- Migrate and adapt existing web applications for mobile devices and various hardware platforms
- Interface with all departments within Baseball Operations (scouting, player development, coaching, analytics) to build tools and reporting capabilities to meet their needs
- 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:
- Bachelor’s degree in Computer Science or related field
- 3-5 years experience with data-driven web application development using:
- ASP.NET/C# using MVC and WebAPI
- nHibernate or other O/R framework
- AngularJS and Bootstrap
- An understanding of CSS, cross-browser, and responsive web development, including a strong understanding of desktop vs. mobile UI/UX design techniques
- Familiarity with Microsoft Visual Studio and source code management tools (Subversion, Git, TFS/VSS)
- Proficient in SQL databases and various database design principles (Microsoft SQL Server a plus)
- Knowledge of the software development lifecycle (requirements definition, design, development, testing, implementation, verification), Agile, and industry best practices
- 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 a plus
Job Questions:
- How did you hear about this job?
- Do you have experience writing database-driven web applications, using ASP.Net/C#?
- Describe one data-driven web application you’ve developed and how you’ve utilized ASP.NET/C# and an RDBMS in its development?
- Do you have experience with AngularJS or other client-side Javascript framework?
- List any active websites or mobile applications you have developed (and the technologies they use) that might showcase your work.
To Apply:
To apply, please complete the following application.
Position: Data Engineer
Description:
The New York Yankees Baseball Operations department is accepting applications for an experienced data engineer with a focus on data quality analysis. This position reports to the senior Baseball Operations executives and will assist in the development and maintenance of the Yankees data processing pipelines.
Primary Responsibilities:
- Prepare, clean, format analytical datasets for processing by data scientists
- Become an expert in the team’s datasets, their strengths and weaknesses, and write code to pull and verify data in response to data scientist requests
- Using R, visualize complex, multi-source data to pinpoint data quality issues
- Build automated pipelines for processing and cleaning data
- Conduct database feature engineering to support ongoing quantitative research
- Work with developers to create and deploy systems for anomaly detection
- Interface with data scientists, software developers, and other baseball operations staff as needed
- Design department-wide principles and workflow for data quality management
- Serve as the main point-of-contact for questions about data structures, definitions, and quality
Qualifications and Experience:
- Bachelor’s degree in Computer Science or related field
- 3+ years of experience developing in SQL (preferably T-SQL)
- 2+ years of experience with data profiling, data modeling, and data pipeline development
- 2+ years of experience developing in R (or a similar statistical programming language), including experience with data manipulation and visualization in that language
- Ability to write succinct code with optimal performance and simplicity
- Excellent communication and problem-solving skills – must be able to break down 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
Job Questions:
- How did you hear about this job?
- Describe your experience writing in T-SQL.
- Describe your experience writing in R. What packages do you use most?
- Describe your experience with data engineering and the specific techniques you’ve used.
- At a high-level, describe briefly what steps you would take to identify data biases or inconsistencies in an unfamiliar/new dataset?
- Have you ever worked with baseball data sets before? If so, please describe which ones and how you used them.
To Apply:
To apply, please complete the following application.
Position: Associate, Quantitative Analysis
Description:
This position is a rigorous 12-month program geared to prepare entry level candidates for a career within the Baseball Operations industry.
Responsibilities:
- Assist in research and analysis of various baseball topics
- Design, test and implement predictive models using advanced statistical techniques
- Prepare, manage, and visualize large-scale data sets
- Develop processes for monitoring and ensuring data quality across multiple data sources
- Responsibilities may also include data collection and entry, running database queries and administrative tasks
Qualifications:
- Bachelor’s degree or higher in a Mathematics, Statistics, Computer Science or related field required
- Experience building predictive models, preferably in R
- Computer programming experience
- Experience using SQL
- Familiarity with current baseball research
- Understanding of fundamental concepts in statistics and probability
Job Questions:
- How did you hear about this job?
- When are you available to start?
- What classes have you completed in math, statistics, probability, and/or computer science?
- Describe any previous experience building statistical models.
- Which programming languages are you proficient in and what is your preferred language? If applicable to the language, please describe any libraries/packages you use.
- Describe any previous experience using SQL, if any.
- Please list any previous baseball/softball experience. This can include playing experience, research experience, coaching experience, writing experience, and more.
- Will you now or in the future need visa sponsorship status to lawfully work in the United States?
To Apply:
To apply, please complete the following application.
Position: Associate, Baseball Operations
Description:
This position is a rigorous 12-month program geared to prepare entry level candidates for a career within the Baseball Operations industry.
Responsibilities:
- Coordinate and prepare advance scouting material for the New York Yankees
- Support the Baseball Operations and Pro Scouting staffs with daily logistical tasks
- Chart select games from video, as well as execute additional video projects
- Introductory level player evaluation
- Assist with various research tasks
- Data collection and entry
- Administrative tasks as assigned
Qualifications:
- Bachelor’s degree required
- Experience working with BATS coaching system
- Must be able to recognize pitch types and know how to score a baseball game
- General understanding of MLB rules and regulations
- Detail oriented and organized
- Strong verbal communication and collaborative skills
- Experience working with video and in baseball
Job Questions:
- How did you hear about this job?
- What is the earliest date that you are available to start the Associate program?
- What are your favorite statistics for evaluating baseball players?
- What are your favorite baseball-related websites, books, or podcasts?
- Who do you think are the five best starting pitchers in MLB right now?
- Do you have any previous baseball or softball experience? Please provide specific examples.
- Will you now or in the future need visa sponsorship status to lawfully work in the United States?
To Apply:
To apply, please complete the following application.
These descriptions are intended to describe the type of work being performed by a person assigned to these positions. They are 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.
iTunes Feed (Please rate and review us!)
Sponsor Us on Patreon
Facebook Group
Effectively Wild Wiki
Twitter Account
Get Our Merch!
Email Us: podcast@fangraphs.com
