Data Engineer, Baseball Systems

DEPARTMENT: Baseball Systems REPORTS TO: VP, Baseball Systems STATUS: Full-Time|Exempt San Diego Padres Commitment: The San Diego Padres are committed to creating a diverse and inclusive environment for our employees. We strive to create an environment for everyone by including perspectives from backgrounds that vary by race, ethnicity, religion, gender, age, disability, sexual orientation, veteran status, and national origin. If you are not sure you’re 100% qualified but are up for the challenge – we want you to apply. We believe skills are transferable and passion for our mission goes a long way. Your role as a Data Engineer: You will help to design, develop, and maintain large data pipelines to support a wide range of baseball operations (including Front Office, Scouting, Player Development and Major League Operations) with the goal of ultimately building a winning team on the field. All the responsibilities we will trust you with: * Assist in the building and maintaining of our internal data model of play-by-play and player-tracking data and the pipelines necessary to populate it * Transform data in meaningful ways to ensure the data is reliable, clean, and easily accessible by developers and analysts * Develop auditing SQL queries and quality-check systems for ensuring the data has all of the attributes listed above * Construct and maintain data pipelines that bring data from external baseball information vendors into our own system * Innovate solutions for optimizing these processes to improve performance and scalability Your areas of knowledge and expertise that matter most: * Experience designing and building professional databases and data warehouses * Knowledge of database architecture, design patterns, and best practices to ensure the best system performance and long-term maintainability * Strong proficiency in writing SQL and understanding the intricacies of how queries work * Experience working with code versioning management systems like Git * Strong problem-solving skills and attention to detail, with the ability to analyze and debug complex software issues * Ability to communicate with non-technical users to understand their roles and requirements and propose appropriate solutions * Proficient computer skills including experience with MS Office products such as Word, Excel, Outlook, etc., and general knowledge of basic office equipment including copier, laser printer, telephone, and computer * Possess strong communication skills, both written and verbal, and effectively work well with others in a collaborative, respectful manner * Exceptional time management and organizational skills with capacity to handle high volumes of detailed work, multi-task and manage projects on strict deadlines * Maintain professional demeanor with a high degree of discretion, integrity, and accountability * Maintain consistent, punctual, and reliable attendance You will be required to meet the following: * Must be at least 18 years of age by the start of employment * 4-year Bachelor’s Degree in Computer Science or related field strongly preferred * Prior experience with AWS cloud services like Redshift, Glue, RDS (or Azure/GCP equivalents) strongly preferred * Proven proficiency in Python as to be able to write scripts to manipulate data strongly preferred * Familiarity with Apache Spark preferred * Passion for baseball and understanding of baseball statistics and analytics * Able to work flexible hours including evenings, weekends, holidays and extended hours as dictated by the baseball calendar * Able to travel as needed * Minimum physical requirements: able to travel to and gain access to various areas of the ballpark for prolonged periods of time during games and events; able to lift and transport up to 25 pounds * As a condition of employment, you must successfully complete all post-offer, pre-employment requirements, including but not limited to a background check Salary and additional compensation: Per the California pay transparency law, the base salary range for this full-time position is $100,000 - $120,000. As a candidate for this position, your salary and related elements of compensation will be contingent upon your work experience, education, job-related skills and any other factors the San Diego Padres considers relevant to the hiring decision for this position. In addition to the base salary, the Padres believe in providing a very competitive and generous compensation and benefits package for its employees. Benefits include, but are not limited to: Medical, Dental, Vision, 401(k) with employer match + automatic company Safe Harbor contribution, Basic Life Insurance (with option to purchase Supplemental Life Insurance), Pet Insurance, generous paid time off (PTO) and holiday program, paid employee parking, onsite barista service, employer provided game tickets to home games, onsite experiences, ballpark discounts on food and retail, work from home Fridays (during the off-season and when team is on the road), smart casual dress code and so much more! All benefits are subject to eligibility requirements and the terms of official plan documents which may be modified or amended at any given time. The San Diego Padres are an Equal Opportunity Employer. #LI-onsite