Sr. Knowledge Engineer, Baseball Techniques
Apply for This Job
DEPARTMENT OVERVIEW
Members of the Baseball Techniques group on the Boston Crimson Sox are targeted on designing, constructing, and refining the software program and knowledge pipelines used inside Baseball Operations. These instruments and functions are an integral a part of the decision-making course of, are immediately 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 knowledge sources and functions.
POSITION OVERVIEW
The Boston Crimson Sox are in search of a Senior Knowledge Engineer, Baseball Techniques who’s a hands-on database professional chargeable for administering and optimizing large-scale SQL environments, constructing sturdy knowledge pipelines, and making certain high-performance entry to crucial baseball operations knowledge throughout on-prem and cloud platforms.
The best candidate thrives in a fast-paced setting, is comfy managing each fashionable Snowflake-based pipelines and legacy SQL Server programs, and brings a robust sense of possession to delivering scalable, environment friendly, and maintainable knowledge options that immediately impression decision-making all through Baseball Operations. This function is central to the reliability and evolution of the Crimson Sox’s knowledge infrastructure, supporting analysts, builders, and programs 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 sturdy knowledge transformation pipelines, leveraging knowledge from each APIs and file-based sources
Leverage instruments like dbt, Snowpipe, and Snowpark for knowledge transformations
Design, handle, and monitor knowledge pipelines that transfer structured and unstructured knowledge from Azure Blob Storage into Snowflake, making certain reliability, efficiency, and cost-efficiency
Keep and modernize legacy SQL Server knowledge pipelines, bettering 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 assist for crucial manufacturing programs, resolving pipeline or efficiency points rapidly and successfully
Companion with software program builders, analysts, and different stakeholders to assist analytical, operational, and reporting wants throughout Baseball Operations
Take part in code critiques, structure discussions, and DevOps greatest practices with the info engineering and software program improvement groups
COMPETENCIES
Aptitude and talent to use tutorial or utilized expertise in software program improvement or knowledge 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 knowledge options to permit for cost-effective, scalable, quick, and versatile options to assist front-end improvement, analyst work, and knowledge well being and monitoring wants
In a position to choose up rapidly and assume each creatively and critically to unravel issues
A primary 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 an information engineering or knowledge platform function 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 knowledge pipelines from Azure Blob Storage to Snowflake, utilizing instruments like dbt, Snowpipe (or equal)
Stable understanding of ELT/ETL ideas and knowledge structure greatest practices throughout cloud and hybrid programs
Familiarity with DBT for knowledge transformation and modeling is strongly most popular
Expertise with GraphQL is a plus however not required
Capacity to work autonomously and as a group in a quick paced setting.
Excessive degree 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 group members.
Excessive diploma of professionalism and talent to keep up confidential data.
Wonderful organizational and time administration abilities.
Along with the above necessities, all roles inside Baseball Operations are anticipated to successfully show our common competencies associated to drawback 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
It is a free article. In the event you loved it, contemplate subscribing to Baseball Prospectus. Subscriptions assist ongoing public baseball analysis and evaluation in an more and more proprietary setting.
Subscribe now
