Sr. Knowledge Engineer, Baseball Methods
Apply for This Job
DEPARTMENT OVERVIEW
Members of the Baseball Methods crew on the Boston Pink Sox are centered on designing, constructing, and refining the software program and information pipelines used inside Baseball Operations. These instruments and purposes are an integral a part of the decision-making course of, are instantly built-in within the workflows of all departments inside Baseball Operations, and supply an environment friendly, constant, and accessible expertise when interacting with our inside information sources and purposes.
POSITION OVERVIEW
The Boston Pink Sox are looking for a Senior Knowledge Engineer, Baseball Methods who’s a hands-on database skilled liable for administering and optimizing large-scale SQL environments, constructing strong information pipelines, and guaranteeing high-performance entry to crucial baseball operations information throughout on-prem and cloud platforms.
The best candidate thrives in a fast-paced surroundings, is comfy managing each trendy Snowflake-based pipelines and legacy SQL Server methods, and brings a robust sense of possession to delivering scalable, environment friendly, and maintainable information options that instantly influence decision-making all through Baseball Operations. This position is central to the reliability and evolution of the Pink Sox’s information infrastructure, supporting analysts, builders, and methods engineers throughout participant analysis, baseball sciences, and scouting domains.
RESPONSIBILITIES
Administer and optimize Snowflake and SQL Server environments, together with warehouse sizing, question tuning, and entry management insurance policies
Develop strong information transformation pipelines, leveraging information from each APIs and file-based sources
Leverage instruments like dbt, Snowpipe, and Snowpark for information transformations
Design, handle, and monitor information pipelines that transfer structured and unstructured information from Azure Blob Storage into Snowflake, guaranteeing reliability, efficiency, and cost-efficiency
Preserve and modernize legacy SQL Server information pipelines, enhancing efficiency by way of question optimization, indexing methods, and useful resource tuning
Contribute to the infrastructure design and software program lifecycle phases—together with technical design, testing, implementation, and high quality assurance
Present proactive help for crucial manufacturing methods, resolving pipeline or efficiency points shortly and successfully
Accomplice with software program builders, analysts, and different stakeholders to help analytical, operational, and reporting wants throughout Baseball Operations
Take part in code evaluations, structure discussions, and DevOps greatest practices with the info engineering and software program improvement groups
COMPETENCIES
Aptitude and skill to use educational or utilized expertise in software program improvement or information engineering associated area.
A sophisticated understanding of recent databases, SQL and question optimizations, saved procedures, views, and different db objects
In a position to design information options to permit for cost-effective, scalable, quick, and versatile options to help front-end improvement, analyst work, and information well being and monitoring wants
In a position to choose up shortly and suppose each creatively and critically to resolve issues
A fundamental understanding of up to date baseball and/or sports activities evaluation and improvement practices
A team-player that collaborates successfully with technical and non-technical stakeholders
ADDITIONAL QUALIFICATIONS
Bachelor’s diploma in Pc Science, Software program Engineering, Pc Engineering, or a associated technical area
3-5 years of expertise in a knowledge engineering or information platform position with a give attention to database efficiency and pipeline reliability
Sturdy SQL improvement and optimization abilities, together with expertise with saved procedures, indexing, and question tuning in SQL Server
Palms-on expertise administering and creating in Snowflake, together with warehouse scaling, role-based entry, and utilization monitoring
Proficiency in constructing and sustaining information pipelines from Azure Blob Storage to Snowflake, utilizing instruments like dbt, Snowpipe (or equal)
Stable understanding of ELT/ETL ideas and information structure greatest practices throughout cloud and hybrid methods
Familiarity with DBT for information transformation and modeling is strongly most well-liked
Expertise with GraphQL is a plus however not required
Capability to work autonomously and as a crew in a quick paced surroundings.
Excessive stage of consideration to element with the flexibility to multi-task successfully.
Snug working remotely when required and utilizing Zoom, Groups, Slack, Trello, and different instruments to speak with all crew members.
Excessive diploma of professionalism and skill to keep up confidential data.
Glorious organizational and time administration abilities.
Along with the above necessities, all roles inside Baseball Operations are anticipated to successfully display our common competencies associated to downside fixing, teamwork, readability of communication, and time administration, together with embodying our tradition of honesty, humility, relentlessness, and dedication to DEIB.
Apply for This Job
Thanks for studying
This can be a free article. In the event you loved it, think about subscribing to Baseball Prospectus. Subscriptions help ongoing public baseball analysis and evaluation in an more and more proprietary surroundings.
Subscribe now
